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
  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"
  2. 0

    problem about text

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLWarning: java.sql.SQLWarning: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed language setting to us_english. 17:42:25,500 INFO [SQL] [ C:4592974; T:12011941; D:21240598 ] preparing statement <22006934>: SELECT t0.RECURRENCE_RULE_ID, t0.BY_DAY_LIST, t0.BY_HOUR_LIST, t0.BY_MONTH_DAY_LIST, t0.BY_MONTH_LIST, t0.BY_SECOND_LIST, t0.BY_SET_POS_LIST, t0.BY_WEEK_NO_LIST, t0.BY_YEAR_DAY_LIST, t0.COUNT_NUMBER, t0.FREQUENCY, t0.INTERVAL_NUMBER, t0.UNTIL_DATE_TIME, t0.WEEK_START, t0.X_NAME FROM RECURRENCE_RULE t0 17:42:25,500 INFO [SQL] [ C:4592974; T:12011941; D:21240598 ] executing statement <22006934>: (SELECT t0.RECURRENCE_RULE_ID, t0.BY_DAY_LIST, t0.BY_HOUR_LIST, t0.BY_MONTH_DAY_LIST, t0.BY_MONTH_LIST, t0.BY_SECOND_LIST, t0.BY_SET_POS_LIST, t0.BY_WEEK_NO_LIST, t0.BY_YEAR_DAY_LIST, t0.COUNT_NUMBER, t0.FREQUENCY, t0.INTERVAL_NUMBER, t0.UNTIL_DATE_TIME, t0.WEEK_START, t0.X_NAME FROM RECURRENCE_RULE t0): [reused=1;params={}] 17:42:25,906 INFO [SQL] [ C:4592974; T:12011941; D:21240598 ] preparing statement <4199584>: SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ? 17:42:25,921 INFO [SQL] [ C:4592974; T:12011941; D:21240598 ] executing statement <4199584>: (SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?): [reused=1;params={(String)1}] 17:42:25,937 INFO [SQL] [ C:4592974; T:12011941; D:21240598 ] executing statement <4199584>: (SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?): [reused=2;params={(String)2}] com.solarmetric.kodo.runtime.FatalDataStoreException: com.solarmetric.kodo.runtime.DataStoreException: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = '2'] [PRE=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided (abcdef4) is not valid. [code=16909;state=HY000] NestedThrowables: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = '2'] [PRE=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided (abcdef4) is not valid. NestedThrowables: com.solarmetric.kodo.runtime.DataStoreException: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = '2'] [PRE=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided (abcdef4) is not valid. [code=16909;state=HY000] NestedThrowables: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = '2'] [PRE=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided (abcdef4) is not valid.
  3. 0

    db:: 3.92::com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host port 1433 has failed. 1a

    hivmr.com | 5 months ago
    java.sql.SQLWarning: java.sql.SQLWarning: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed language setting to us_english. 17:42:25,500 INFO [SQL] [ C:4592974; T:12011941; D:21240598 ] preparing statement 22006934: SELECT t0.RECURRENCE_RULE_ID, t0.BY_DAY_LIST, t0.BY_HOUR_LIST, t0.BY_MONTH_DAY_LIST, t0.BY_MONTH_LIST, t0.BY_SECOND_LIST, t0.BY_SET_POS_LIST, t0.BY_WEEK_NO_LIST, t0.BY_YEAR_DAY_LIST, t0.COUNT_NUMBER, t0.FREQUENCY, t0.INTERVAL_NUMBER, t0.UNTIL_DATE_TIME, t0.WEEK_START, t0.X_NAME FROM RECURRENCE_RULE t0 17:42:25,500 INFO [SQL] [ C:4592974; T:12011941; D:21240598 ] executing statement 22006934: (SELECT t0.RECURRENCE_RULE_ID, t0.BY_DAY_LIST, t0.BY_HOUR_LIST, t0.BY_MONTH_DAY_LIST, t0.BY_MONTH_LIST, t0.BY_SECOND_LIST, t0.BY_SET_POS_LIST, t0.BY_WEEK_NO_LIST, t0.BY_YEAR_DAY_LIST, t0.COUNT_NUMBER, t0.FREQUENCY, t0.INTERVAL_NUMBER, t0.UNTIL_DATE_TIME, t0.WEEK_START, t0.X_NAME FROM RECURRENCE_RULE t0): [reused=1;params={}] 17:42:25,906 INFO [SQL] [ C:4592974; T:12011941; D:21240598 ] preparing statement 4199584: SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ? 17:42:25,921 INFO [SQL] [ C:4592974; T:12011941; D:21240598 ] executing statement 4199584: (SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?): [reused=1;params={(String)1}] 17:42:25,937 INFO [SQL] [ C:4592974; T:12011941; D:21240598 ] executing statement 4199584: (SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?): [reused=2;params={(String)2}] com.solarmetric.kodo.runtime.FatalDataStoreException: com.solarmetric.kodo.runtime.DataStoreException: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = '2'] [PRE=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided (abcdef4) is not valid. [code=16909;state=HY000] NestedThrowables: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = '2'] [PRE=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided (abcdef4) is not valid. NestedThrowables: com.solarmetric.kodo.runtime.DataStoreException: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = '2'] [PRE=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided (abcdef4) is not valid. [code=16909;state=HY000] NestedThrowables: com.solarmetric.kodo.impl.jdbc.sql.SQLExceptionWrapper: [SQL=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = '2'] [PRE=SELECT RECURRENCE_RULE.BY_MINUTE_LIST FROM RECURRENCE_RULE WHERE RECURRENCE_RULE.RECURRENCE_RULE_ID = ?] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided (abcdef4) is not valid. at com.solarmetric.kodo.impl.jdbc.runtime.LazyResultList.instantiateRow(LazyRes ultList.java:205) at com.solarmetric.kodo.impl.jdbc.runtime.LazyResultList.get(LazyResultList.jav a:130)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    WebLogic throws SQLWarning Error when attempting to execute Procedure.

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLWarning: Unknown type specified: 0 > Server StackTrace: > [ > <not available>]
  6. 0

    Oracle SQLWarning: specified user name was not quoted

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLWarning: [BEA][Oracle JDBC Driver]Specified user name was not quoted and was, therefore, converted to all upper case.

    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.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