java.sql.SQLException: ORA-02091: transaction rolled back ORA-02291: integrity constraint (CHANGEREQ.FK_DESCRIPTION_REQUEST_ID) violated - parent key not found

Oracle Community | 3004 | 1 decade ago
  1. 0

    Sequences and app vs. db identity

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-02091: transaction rolled back ORA-02291: integrity constraint (CHANGEREQ.FK_DESCRIPTION_REQUEST_ID) violated - parent key not found
  2. 0

    bea 8.1 oracle thin drivers and deferred constraints

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-02091: transaction rolled back ORA-02291: integrity constraint (NEWTON.FK_SAMPLE_BATCHID) violated - parent key not found OK! this is good. You get a SQLException during commit(). We should also then, and wouldn't ignore it. Would you plese make sure that the Oracle driver you are using in the standalone case is also the one the weblogic server is using. If it's not the one in the weblogic.jar file, you can make sure the zip file is ahead of the official weblogic stuff in the server's classpath. Then please turn on jdbc logging for the server, and repeat the same JDBC from within weblogic, and you should see the same exception in the jdbc log. It would be a bug if the exception showed in the log, but your application code didn't get it too. If the exception doesn't show in the log, something else is afoot. Joe > >
  3. 0

    Thalai Muthu Oracle Apps DBA: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.;

    blogspot.com | 1 year ago
    oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    error after changing domain to the essbase server

    Oracle Community | 7 years ago | user1127616
    java.sql.SQLException: ORA-12638: Recupero credenziali non riuscito
  6. 0

    SQl - ORA-00933 error

    Stack Overflow | 2 years ago | praba
    java.sql.SQLException: ORA-00933: SQL command not properly ended

    26 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-02091: transaction rolled back ORA-02291: integrity constraint (CHANGEREQ.FK_DESCRIPTION_REQUEST_ID) violated - parent key not found

      at oracle.jdbc.dbaccess.DBError.throwSqlException()
    2. oracle.jdbc.dbaccess
      DBError.throwSqlException
      1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      1 frame
    3. oracle.jdbc.ttc7
      TTC7Protocol.commit
      1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
      2. oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.java:138)
      3. oracle.jdbc.ttc7.TTC7Protocol.commit(TTC7Protocol.java:441)
      3 frames
    4. Oracle jdbc
      OracleConnection.commit
      1. oracle.jdbc.driver.OracleConnection.commit(OracleConnection.java:1377)
      1 frame
    5. com.solarmetric.jdbc
      DelegatingConnection.commit
      1. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
      2. com.solarmetric.jdbc.PoolConnection.commit(PoolConnection.java:182)
      3. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
      4. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
      5. com.solarmetric.jdbc.ConfiguringConnectionDecorator$ConfiguringConnection.commit(ConfiguringConnectionDecorator.java:127)
      6. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
      7. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
      8. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection.commit(LoggingConnectionDecorator.java:162)
      9. com.solarmetric.jdbc.DelegatingConnection.commit(DelegatingConnection.java:184)
      9 frames
    6. kodo.jdbc.runtime
      JDBCStoreManager.commit
      1. kodo.jdbc.runtime.JDBCStoreManager.commit(JDBCStoreManager.java:120)
      1 frame
    7. kodo.runtime
      PersistenceManagerImpl.commit
      1. kodo.runtime.PersistenceManagerImpl.endTransaction(PersistenceManagerImpl.java:799)
      2. kodo.runtime.PersistenceManagerImpl.afterCompletion(PersistenceManagerImpl.java:668)
      3. kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:86)
      4. kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:411)
      4 frames
    8. Unknown
      testEntry.doPost
      1. testEntry.processRequest(testEntry.java:433)
      2. testEntry.doPost(testEntry.java:463)
      2 frames
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2 frames
    10. jrun.servlet
      ServletEngineService.dispatch
      1. jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
      2. jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
      3. jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
      4. jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
      4 frames
    11. jrun.servlet.jrpp
      JRunProxyService.invokeRunnable
      1. jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:207)
      1 frame
    12. jrunx.scheduler
      WorkerThread.run
      1. jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
      2. jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
      3. jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
      4. jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
      4 frames