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
Register / Login


JavaRanch » Java Forums » Products » Other Open Source Projects
Reply 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
 
Similar Threads
Error while executing query through JDBC
JDBC Connection
Error while trying to connect to DB from Struts application
Getting java.sql.SQLException: ORA-01465: invalid hex number
java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint