Hi Guillaume, Please translate the text of the exception into English and give more details about this case. Is GNT the name of the table? What are related objects for GNT involved into this thansaction? And the most important question is: Do all database constraints correspond to some relations described in repository.xml? If there is some database constraint that OJB is not aware of, it might be violated with the batch mode, because OJB changes the order of statements to group them into batches, but in such way that doesn't violate *known* constraints.
Regards, Oleg On Tuesday 13 January 2004 08:07, Guillaume Nodet wrote: > Hi ! > > I've got a problem with RC5. > I use the broker api to store several objets with collections and nested > objets. > Under certain circumstances (Oracle, batch mode), i've got the following > exception thrown: > > java.sql.SQLException: ORA-02291: violation de contrainte > (GNT.SYS_C00194175) d'integrite - touche parent introuvable > > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java) > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java) > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java) > at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java) > at > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java) at > oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java) at > oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedState >m ent.java) > at > org.apache.ojb.broker.platforms.PlatformDefaultImpl.executeBatch(Unknown > Source) > at > org.apache.ojb.broker.util.batch.PreparedStatementInvocationHandler.doExecu >t e(Unknown Source) > at > org.apache.ojb.broker.util.batch.PreparedStatementInvocationHandler.invoke( >U nknown Source) > at $Proxy0.doExecute(Unknown Source) > at org.apache.ojb.broker.util.batch.BatchConnection.executeBatch(Unknown > Source) > at org.apache.ojb.broker.util.batch.BatchConnection.commit(Unknown Source) > at > org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localCommit(Unknown > Source) > at > org.apache.ojb.broker.core.PersistenceBrokerImpl.commitTransaction(Unknown > Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.commitTransaction(Un >k nown Source) > at > org.apache.ojb.broker.core.DelegatingPersistenceBroker.commitTransaction(Un >k nown Source) > at > com.optitime.synchronizer6.Synchronizer.initTables(Synchronizer.java:826) > at > com.optitime.synchronizer6.SynchronizerApplication$ActionThread.run(Synchro >n izerApplication.java:1021) > > When I set batch mode to false, or when i commit the transaction between > each stored objects, i've got no problem. > > Has anyone an idea ? > > Guillaume Nodet. > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]