java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • XA error
    via by 3004,
  • oracle clob problem
    via by 3004,
  • cannot write to the database
    via by 3004,
  • Oracle CLOB problem
    via by 3004,
  • wrong order foreign key constraints
    via by 3004,
  • Kodo v4.0.0EA2 Bugs List
    via by 3004,
    • java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for identity column in table 'SessionType' when IDENTITY_INSERT is set to OFF. at kodo.jdbc.sql.SQLExceptions.getFatalDataStore(SQLExceptions.java:42) at kodo.jdbc.sql.SQLExceptions.getFatalDataStore(SQLExceptions.java:24) at kodo.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:507) at kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:760) at kodo.runtime.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:639) at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1291) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:339) Caused by: com.solarmetric.jdbc.ReportingSQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for identity column in table 'SessionType' when IDENTITY_INSERT is set to OFF. {prepstmnt 13784376 INSERT INTO dbo.SessionType (description, SessionTypeId) VALUES (?, ?) [params_(null) null, (int) 2]} [code_544, state_23000] at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:67) at com.solarmetric.jdbc.LoggingConnectionDecorator.access$400(LoggingConnectionDecorator.java:19) at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:649) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361) at kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager..java:160) at kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager..java:89) at kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:357) at kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:154) at kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:71) at kodo.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:503) ... 7 more
    No Bugmate found.