I had some similar problem with Oracle.
It had to do with cached sequence numbers.
The solution was to specify, in the modeler, Cached PK Size as 1.
Hope this helps.
Josep
-----Mensaje original-----
De: bobsponge [mailto:ruben.garci..ecnicasdeingenieria.com]
Enviado el: jueves, 10 de julio de 2008 15:37
Para: use..ayenne.apache.org
Asunto: Autogenerated keys issues
Hello,
I'm using cayenne v2.0.4 with h2 as database engine. All table indexes are
auto-generated with a auto_pk_support table. Table Indexes generation
usually works but some times I get an error like this
org.apache.cayenne.CayenneRuntimeException: [v.2.0.4 October 12 2007] Commit
Exception, org.h2.jdbc.JdbcSQLException: Unique index or primary key
violation: PRIMARY_KEY_36 ON PUBLIC.TABLETEST(ID) [23001-74]
It seems the ID generation fails with no reason at all. I usually get this
problem in the same table when several insertions are performed very
quickly. All changes in the datacontext are committed every time a new
object is created.
żIs there any problem with h2 database and auto_pk_support?
Thank you
-- View this message in context: http://www.nabble.com/Autogenerated-keys-issues-tp18382943p18382943.html Sent from the Cayenne - User mailing list archive at Nabble.com.
This archive was generated by hypermail 2.0.0 : Thu Jul 10 2008 - 09:47:13 EDT