permaculture playing cards*
The moose likes JDBC and the fly likes java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint" Watch "java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint" New topic
Author

java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint

mallikarjun dontamsetti
Ranch Hand

Joined: Mar 18, 2011
Posts: 243

I got the problem when i try to insert the record in database using servlet the code is



Table names are Emp11 and foreign key value is DEPT_ID and its table has value 1,2,3,4 I hard coded it in the PreparedStatement
pstmt.setInt(7, 2);

//Exception is

java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (SCOTT.EMP11_DEPT1_FK1) violated - parent key not found

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:116)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:177)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1490)
at COM.GARNET.EMPLOYEE.AddNew.doPost(AddNew.java:85)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)



please help me
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Don,
If you haven't already done so, I suggest doing an Intenet search for the Oracle error code you are getting, namely ORA-02291
Perhaps this link will help.

Good Luck,
Avi.
Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

I believe, the Department ID that you are supplying is not present in its master table anymore !


S.D. MADHAN
Not many get the right opportunity !
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint
 
Similar Threads
Weblogic 8.1 SP5 server got shutdown due to Connection leak and java.lang.OutofMemory
SQLGrammarException
Error while executing query through JDBC
Error while inserting data through procedure
Database issue; Migrating from weblogic 6 to 9