aspose file tools*
The moose likes Other Open Source Projects and the fly likes DBUnit ...looading data to database getting error of integrity constraint Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "DBUnit ...looading data to database getting error of integrity constraint " Watch "DBUnit ...looading data to database getting error of integrity constraint " New topic
Author

DBUnit ...looading data to database getting error of integrity constraint

pravin karne
Ranch Hand

Joined: Jul 26, 2007
Posts: 31
Hello friends ,

I got following error whrn i load my dataset file to database with

DatabaseOperation.CLEAN_INSERT.execute(conn,data);

error was:

error message="ORA-02292: integrity constraint (SH_USER.SH_CMPG_MA_CMPG_DERV_ASSOC_FK1) violated - child record found
" type="java.sql.SQLException">java.sql.SQLException: ORA-02292: integrity constraint (SH_USER.SH_CMPG_MA_CMPG_DERV_ASSOC_FK1) violated - child record found

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1679)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1645)
at org.dbunit.database.statement.SimpleStatement.executeBatch(SimpleStatement.java:54)
at org.dbunit.operation.DeleteAllOperation.execute(DeleteAllOperation.java:112)
at org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:67)
at com.stratoshear.runtime.pcs.GetGenericAdsTest.handleSetUpOperation(Unknown Source)
at com.stratoshear.runtime.pcs.GetGenericAdsTest.loatDB(Unknown Source)
</error>


any body help me in resolving this error...Please
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DBUnit ...looading data to database getting error of integrity constraint