javax.resource.spi.LocalTransactionException: Can't call commit when autocommit=true

Oracle Community | chris.joelly | 6 years 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

    Glassfish 3.1, Mysql datasource, autocommit

    Oracle Community | 6 years ago | chris.joelly
    javax.resource.spi.LocalTransactionException: Can't call commit when autocommit=true
  2. 0

    Update MySQL table from jsp

    Stack Overflow | 5 years ago | vishnu
    java.sql.SQLException: Can't call commit when autocommit=true
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    "Can't call commit when autocommit=true"

    GitHub | 2 years ago | krillr
    java.sql.SQLException: Can't call commit when autocommit=true
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.SQLException

    Can't call commit when autocommit=true

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    ConnectionImpl.commit
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:930)
    2. com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1602)
    2 frames
  3. Embedded GlassFish Web
    LocalTransaction.commit
    1. com.sun.gjc.spi.LocalTransaction.commit(LocalTransaction.java:106)
    1 frame
  4. Connectors Runtime
    ConnectorXAResource.commit
    1. com.sun.enterprise.resource.ConnectorXAResource.commit(ConnectorXAResource.java:124)
    1 frame
  5. Embedded GlassFish Web
    EjbApplication.start
    1. com.sun.enterprise.transaction.JavaEETransactionImpl.commit(JavaEETransactionImpl.java:503)
    2. com.sun.enterprise.transaction.JavaEETransactionManagerSimplified.commit(JavaEETransactionManagerSimplified.java:867)
    3. com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:5115)
    4. com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4894)
    5. com.sun.ejb.containers.AbstractSingletonContainer.createSingletonEJB(AbstractSingletonContainer.java:555)
    6. com.sun.ejb.containers.AbstractSingletonContainer.access$100(AbstractSingletonContainer.java:79)
    7. com.sun.ejb.containers.AbstractSingletonContainer$SingletonContextFactory.create(AbstractSingletonContainer.java:717)
    8. com.sun.ejb.containers.AbstractSingletonContainer.instantiateSingletonInstance(AbstractSingletonContainer.java:449)
    9. org.glassfish.ejb.startup.SingletonLifeCycleManager.initializeSingleton(SingletonLifeCycleManager.java:216)
    10. org.glassfish.ejb.startup.SingletonLifeCycleManager.initializeSingleton(SingletonLifeCycleManager.java:177)
    11. org.glassfish.ejb.startup.SingletonLifeCycleManager.doStartup(SingletonLifeCycleManager.java:155)
    12. org.glassfish.ejb.startup.EjbApplication.start(EjbApplication.java:177)
    12 frames
  6. Private APIs of Glassfish
    ApplicationInfo.start
    1. org.glassfish.internal.data.EngineRef.start(EngineRef.java:130)
    2. org.glassfish.internal.data.ModuleInfo.start(ModuleInfo.java:269)
    3. org.glassfish.internal.data.ApplicationInfo.start(ApplicationInfo.java:286)
    3 frames
  7. Kernel Classes
    ApplicationLifecycle.deploy
    1. com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:461)
    2. com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:240)
    2 frames
  8. Embedded GlassFish Web
    DeployCommand.execute
    1. org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:370)
    1 frame
  9. Kernel Classes
    AdminAdapter.service
    1. com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:355)
    2. com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:370)
    3. com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1067)
    4. com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:96)
    5. com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1247)
    6. com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1235)
    7. com.sun.enterprise.v3.admin.AdminAdapter.doCommand(AdminAdapter.java:465)
    8. com.sun.enterprise.v3.admin.AdminAdapter.service(AdminAdapter.java:222)
    8 frames
  10. Grizzly WS
    GrizzlyAdapter.service
    1. com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:168)
    1 frame
  11. Kernel Classes
    ContainerMapper.service
    1. com.sun.enterprise.v3.server.HK2Dispatcher.dispath(HK2Dispatcher.java:117)
    2. com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:234)
    2 frames
  12. Grizzly WS
    AbstractThreadPool$Worker.run
    1. com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:822)
    2. com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:719)
    3. com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1013)
    4. com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:225)
    5. com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
    6. com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
    7. com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
    8. com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
    9. com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
    10. com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
    11. com.sun.grizzly.ContextTask.run(ContextTask.java:71)
    12. com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
    13. com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
    13 frames
  13. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame