db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ed Bagdonas" <ebagdo...@epropshop.com>
Subject defaultIdMethod=native does not work on SAPDB 7.5 / Torque 3.1 ????
Date Wed, 28 Jan 2004 04:58:55 GMT
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.



  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message