3 Replies Latest reply on Mar 8, 2002 3:09 PM by 843854

    'Value conflict occurs' exception

    843854
      Can anyone tell me what causes a 'Value conflict occurs' JDBCException?

      --- the following is a snippet of where the error occurred ---

      rs_target.updateString(column, str);
      rs_target.updateRow();

      --- end ---

      --- this is the stack trace ---
      java.sql.SQLException: Value conflicts occurs
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:219)
      at oracle.jdbc.driver.UpdatableResultSet.execute_updateRow(UpdatableResultSet.java:2103)
      at oracle.jdbc.driver.UpdatableResultSet.updateRow(UpdatableResultSet.java:1288)
      at com.simenettech.ecrm.IOLayer.invokeTrigger(IOLayer.java:8051)
      at com.simenettech.ecrm.IOLayer.doCRMCheckAndManipulate(IOLayer.java:2651)
      at IOLayerCaseJournal.doCRMPreprocess(IOLayerCaseJournal.java:179)
      at IOLayerCaseJournal.doPost(IOLayerCaseJournal.java:58)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
      at org.apache.tomcat.core.Handler.service(Handler.java:287)
      at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
      at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
      at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
      at org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
      at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
      at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
      at java.lang.Thread.run(Thread.java:484)
      --- end stack trace ---

      Has anyone encountered this problem before? Please help. It's urgent.

      Thanks.
        • 1. Re: 'Value conflict occurs' exception
          843854
          Does your database participate in replication? I don't have an answer for you, but I searched for 'Value conflicts occurs' on the Oracle Technical Network and I get many articles centered around replication. You might want to check with you DBA.

          B
          • 2. Re: 'Value conflict occurs' exception
            843854
            Brian,

            According to my DBA, we don't use replication. Thanks for pointing that out anyway.
            • 3. Re: 'Value conflict occurs' exception
              843854
              Sorry, tried....

              You also might want to try, if you have not already, to extract more detailed information about the SQL Exception, such as vendor specific error codes, etc. If you've not seen this before, here's a function I used to convert SQL Exceptions into strings, for backend/logging purposes:
                public static String processEX( SQLException ex , String sql ) {
              
                  String returnMsg = "";  // The string to return
              
                  returnMsg += "Failure::SQL Exception Error::";
                  returnMsg += "SQLCode::" + sql + "::";
              
                  // Loop through each exception
                  do {
                    returnMsg += "SQLState::" + ex.getSQLState() + "::";
                    returnMsg += "VendorErrorCode::" + ex.getErrorCode() + "::";
                    returnMsg += "Message::" + ex.getMessage() + "::";
                  } while ( (ex=ex.getNextException()) != null );
              
                  return returnMsg;
              
                }