Test database loaded with primary keys in the table utilizing SERIAL
PRIMARY KEY keywords.

Torque schema has defaultIdMethod=native, table idMethod=native

 

When the application attempts to save a new record the database throws
an exception:

[-4020] (at 8): Unknown sequence name:FOO_SEQ

Inspection of the database shows that FOO_SEQ exists - am assuming this
is created as a function of using SERIAL in the create table statement:
FOO_SEQ was not explicitly created.

 

The generated om (FooMap.java) uses "foo_SEQ"  - might this be SapDB
case related? 

Or have I missed something.  Note that selection / update both works
fine through the torque generated om.

 

Sort of need inserts to work .... A work around / fix is essential.

 

 

Reply via email to