It's the last time i bother you. I have found the problem. I forgot to remove a trigger that also increment the sequence so the sequence was increment twice and provoke a foreign key violation.
But if i try to set the trigger parameter to true for the sequence it cause an error so i dropped the trigger. I use progresql 7.2.1. Sorry for all mistakes i've done
GRAVE: Exception org.exolab.castor.jdo.PersistenceException: SQL exception in the key generator: org.exolab.castor.jdo.PersistenceException: Fatal error in the key generator.. at org.exolab.castor.jdo.drivers.SequenceKeyGenerator.generateKey(SequenceKeyGenerator.java:209) at org.exolab.castor.jdo.engine.SQLEngine.generateKey(SQLEngine.java:501) at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:617) at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:527) at org.exolab.castor.jdo.engine.SQLEngine.create(SQLEngine.java:527) at org.exolab.castor.persist.ClassMolder.create(ClassMolder.java:912) at org.exolab.castor.persist.LockEngine.create(LockEngine.java:489) at org.exolab.castor.persist.TransactionContext.create(TransactionContext.java:883) at org.exolab.castor.jdo.engine.DatabaseImpl.create(DatabaseImpl.java:363) at interIMMO.DataAccess.create(DataAccess.java:390) at tests.TestAnnonce.testAddAnnonce(TestAnnonce.java:52) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at junit.framework.TestCase.runTest(TestCase.java:154) at junit.framework.TestCase.runBare(TestCase.java:127) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:410) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:294) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:182)
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-user
