Hi,
Using Castor 0.9.3 (I've also tried the CVS version, but am still sticking to 0.9.3 for now), I've noticed that key-generation (at least with MAX) will consistently fail under race conditions. I'm using MySQL.
ie a whole lot of these:
java.sql.SQLException: Invalid argument value: Duplicate entry '103' for key 1
[java] at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
[java] at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
[java] at org.gjt.mm.mysql.Connection.execSQL(Connection.java:885)
[java] at org.gjt.mm.mysql.PreparedStatement.executeUpdate(PreparedStatement.java:389)
[java] at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:616)
Examining the JDO test cases, I don't see any that test for race conditions on the key-generators.
Using IDENTITY works.
Is this a known issue?
Regards,
Brett
~*~*~*~*~*~*~
Brett Porter - Web Developer
f2 Network ~ everything essential
Ph: +61 2 8596 4437
Email: [EMAIL PROTECTED]
