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

Oracle Community | 3004 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Update failed when trying to update a nested object

    Oracle Community | 1 decade ago | 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.)
  2. 0

    Hibernate Community • View topic - Auto reconnect to Database using c3p0 connection pool

    hibernate.org | 1 year ago
    java.sql.SQLException: Closed Connection)) at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResou rce.commit(TxConnectionManager.java:701) at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:165 6)

    Root Cause Analysis

    1. 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 org.jboss.tm.TransactionImpl.commit()
    2. JBoss Transaction 7.1.0 SPI
      TransactionImpl.commit
      1. org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:405)
      1 frame
    3. JBoss Application Server Server
      Container.invoke
      1. org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:398)
      2. org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:277)
      3. org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
      4. org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
      5. org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
      6. org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      7. org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
      8. org.jboss.ejb.Container.invoke(Container.java:700)
      8 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    5. org.jboss.mx
      ReflectedMBeanDispatcher.invoke
      1. org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      1 frame
    6. JBoss Application Server J2SE
      MBeanServerImpl.invoke
      1. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      1 frame
    7. JBoss Application Server Server
      ClientContainer.invoke
      1. org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
      2. org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
      3. org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
      4. org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
      5. org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
      6. org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
      6 frames
    8. Unknown
      $Proxy40.execute
      1. $Proxy40.execute(Unknown Source)
      1 frame
    9. com.r911.core
      SessionAction.saveSession
      1. com.r911.core.delegate.BaseDelegate.execute(BaseDelegate.java:50)
      2. com.r911.core.actions.SessionAction.saveSession(SessionAction.java:83)
      2 frames
    10. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    11. struts
      ActionServlet.doPost
      1. org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
      2. org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
      3. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
      4. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
      5. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
      6. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
      6 frames
    12. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2 frames
    13. Glassfish Core
      StandardPipeline$StandardPipelineValveContext.invokeNext
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve..java:256)
      4. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      5. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      6. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      7. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve..java:191)
      8. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      8 frames
    14. JBoss Application Server Tomcat
      JBossSecurityMgrRealm.invoke
      1. org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:228)
      1 frame
    15. Glassfish Core
      StandardPipeline$StandardPipelineValveContext.invokeNext
      1. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      2. org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      3. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      3 frames
    16. org.jboss.web
      ContainerStatsValve.invoke
      1. org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76)
      1 frame
    17. Glassfish Core
      StandardPipeline$StandardPipelineValveContext.invokeNext
      1. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      2. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      3. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      4. org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2416)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      6. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      7. org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      8. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      9. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      10. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      10 frames
    18. JBoss Application Server Tomcat
      SecurityAssociationValve.invoke
      1. org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65)
      1 frame
    19. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      2. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
      3. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      4. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      5. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      6. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      7. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      8. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      9. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      9 frames
    20. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
      1 frame
    21. Grizzly HTTP
      TcpWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:601)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
      3. org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
      3 frames
    22. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
      1 frame
    23. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame