oracle primary key generation.

[Storoe, Shawn]

Hello,
 
I am trying to insert records on my page into a simple database table
that I have generated with the following xml schema using torque.
 
<!--
==================================================================== -->
<!--
-->
<!-- T U R B I N E  P R O J E C T  S C H E M A
-->
<!--
-->
<!--
==================================================================== -->
<!-- This is the schema for the DiarEntry Database
-->
<!--
==================================================================== -->
<database>
  <table name="DIARY">
    <column name="DIARY_ID" required="true" primaryKey="true"
type="INTEGER"/>
    <column name="TITLE" size="255" type="VARCHAR"/>
    <column name="AUTHOR" size="255" type="VARCHAR"/>
    <column name="YEAR" size="255" type="VARCHAR"/>
    <column name="MONTH" size="255" type="VARCHAR"/>
    <column name="DAY" size="255" type="VARCHAR"/>
    <column name="TEXT" size="2000" type="VARCHAR"/>
  </table>
</database>

This is just a test, but I am trying to inser a record and not have to
set the id myself.
 
I thought that the IDBroker service would just work and the id would be
autoincremented, but I keep getting an error that says I can not insert
null into the primary key.
 
So I looked in the docs and I saw this
 
For example if you wish to set up the MapBuilder to take advantage of an
auto-incrementing Primary Key, you can change the entry in your
MapBuilder class from; 

tMap.setPrimaryKeyMethod(TableMap.IDBROKERTABLE);
to

tMap.setPrimaryKeyMethod(TableMap.AUTOINCREMENT);

 

I tried this and I had the same result.

 

I am using the following code to inser my form...

    Diary diary =  new Diary();
    data.getParameters().setProperties(diary);
    DiaryPeer.doInsert(diary);

And my velocity page has the following on it.

        #formCell ("Title" "Title" "")
      </tr>
      <tr>
        #formCell ("Author" "Author" "")
      </tr>
      <tr>
        #formCell ("Year" "Year" "")
      </tr>
      <tr>
        #formCell ("Month" "Month" "")
      </tr>
      <tr>
        #formCell ("Day" "Day" "")
      </tr>
      <tr>
        #formArea ("Text" "Text" "" "10")
      </tr>
      <tr>

which match what the peer class is expecting.

Additionally, I tried to add a DiaryId field to the page and as long as
I set it correctly, no duplicates, the record gets inserted just fine.

Any help would be greatly appreciated.  

Thanks

Shawn

 

<<winmail.dat>>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]