java.sql.SQLWarning: java.sql.SQLWarning: resultSetType or resultSetConcurrency changed 4598 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] begin rollback 4608 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] end rollback 10ms 4628 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] close: com.solarmetric.datasource.PoolConnection@1878144[[requests=2;size=2;max=70;hits=0;created=2;redundant=0;overflow=0;new=2;leaked=0;unavailable=0]] 4628 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] close connection javax.jdo.JDOFatalDataStoreException: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (null, null, 1, 0)] [PRE=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (?, ?, ?, ?)] GDS Exception. violation of PRIMARY or UNIQUE KEY constraint "PK_PERSON" on table "PERSON" [code=335544665;state=null] NestedThrowables: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (null, null, 1, 0)] [PRE=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (?, ?, ?, ?)] GDS Exception. violation of PRIMARY or UNIQUE KEY constraint "PK_PERSON" on table "PERSON"

Oracle Community | 3004 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    How to insert a new record to table with foreign key

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLWarning: java.sql.SQLWarning: resultSetType or resultSetConcurrency changed 4598 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] begin rollback 4608 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] end rollback 10ms 4628 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] close: com.solarmetric.datasource.PoolConnection@1878144[[requests=2;size=2;max=70;hits=0;created=2;redundant=0;overflow=0;new=2;leaked=0;unavailable=0]] 4628 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] close connection javax.jdo.JDOFatalDataStoreException: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (null, null, 1, 0)] [PRE=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (?, ?, ?, ?)] GDS Exception. violation of PRIMARY or UNIQUE KEY constraint "PK_PERSON" on table "PERSON" [code=335544665;state=null] NestedThrowables: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (null, null, 1, 0)] [PRE=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (?, ?, ?, ?)] GDS Exception. violation of PRIMARY or UNIQUE KEY constraint "PK_PERSON" on table "PERSON"

    Root Cause Analysis

    1. java.sql.SQLWarning

      java.sql.SQLWarning: resultSetType or resultSetConcurrency changed 4598 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] begin rollback 4608 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] end rollback 10ms 4628 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] close: com.solarmetric.datasource.PoolConnection@1878144[[requests=2;size=2;max=70;hits=0;created=2;redundant=0;overflow=0;new=2;leaked=0;unavailable=0]] 4628 [main] INFO jdbc.JDBC - [ C:25657668; T:19356985; D:10268916 ] close connection javax.jdo.JDOFatalDataStoreException: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (null, null, 1, 0)] [PRE=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (?, ?, ?, ?)] GDS Exception. violation of PRIMARY or UNIQUE KEY constraint "PK_PERSON" on table "PERSON" [code=335544665;state=null] NestedThrowables: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (null, null, 1, 0)] [PRE=INSERT INTO PERSON(MGR, NAME, PK, SSNUM) VALUES (?, ?, ?, ?)] GDS Exception. violation of PRIMARY or UNIQUE KEY constraint "PK_PERSON" on table "PERSON"

      at com.solarmetric.kodo.impl.jdbc.runtime.SQLExceptions.throwFatal()
    2. com.solarmetric.kodo
      PersistenceManagerImpl.commit
      1. com.solarmetric.kodo.impl.jdbc.runtime.SQLExceptions.throwFatal(SQLExceptions.java:17)
      2. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:416)
      3. com.solarmetric.kodo.runtime.PersistenceManagerImpl.flush(PersistenceManagerImpl.java:575)
      4. com.solarmetric.kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:438)
      4 frames
    3. reversetutorial
      Finder.main
      1. reversetutorial.Finder.createData(Finder.java:74)
      2. reversetutorial.Finder.main(Finder.java:141)
      2 frames