Hi.
Until now I used v2b41 for our application. But since this version has a problem with pessimistic locking together with postgresql ("SELECT ... FOR UPDATE OF *", psql doesn't like the asterix), I have tried the 2.1b23 version of toplink to get this to work (saw that this has been fixed in a current build). But now I have another problem. I'm generating the database schema with the toplink auto-ddl function. It will create tables and sequences automatically. But since the 2.1b23 version it complains about a non-existing sequence "seq_gen_sequence" when dropping. This causes stopping of the sequence generation process at all. So I have no sequences generated but this "seq_gen_sequence". The following is shown in the log:
[java] [TopLink Warning]: 2008.03.07 01:27:33.363--ServerSession(26081910)--Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.1 (Build b23-fcs (02/28/2008))): oracle.toplink.essentials.exceptions.DatabaseException
[java] Internal Exception: org.postgresql.util.PSQLException: FEHLER: Relation »seq_gen_sequence« existiert nicht
[java] Error Code: 0
[java] Call: select nextval('SEQ_GEN_SEQUENCE')
[java] Query: ValueReadQuery()
Earlier there was no such sequence but all my sequences for each table.
Is this a bug or did something change between these versions I have to consider?
[Message sent by forum member 'vguna' (vguna)]
http://forums.java.net/jive/thread.jspa?messageID=262885