javax.resource.ResourceException: The isolation level could not be set: The connection is closed.

Stack Overflow | ci_ms | 5 months 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

    Payara Cluster DB Connection Issue

    Stack Overflow | 5 months ago | ci_ms
    javax.resource.ResourceException: The isolation level could not be set: The connection is closed.

    Root Cause Analysis

    1. javax.resource.ResourceException

      The isolation level could not be set: The connection is closed.

      at com.sun.gjc.spi.ManagedConnectionFactoryImpl.resetIsolation()
    2. Embedded GlassFish Web
      ManagedConnectionImpl.cleanup
      1. com.sun.gjc.spi.ManagedConnectionFactoryImpl.resetIsolation(ManagedConnectionFactoryImpl.java:529)
      2. com.sun.gjc.spi.ManagedConnectionImpl.resetConnectionProperties(ManagedConnectionImpl.java:495)
      3. com.sun.gjc.spi.ManagedConnectionImpl.cleanup(ManagedConnectionImpl.java:347)
      3 frames
    3. Connectors Runtime
      LocalTxConnectionEventListener.connectionClosed
      1. com.sun.enterprise.resource.allocator.AbstractConnectorAllocator.cleanup(AbstractConnectorAllocator.java:166)
      2. com.sun.enterprise.resource.pool.ConnectionPool.cleanupResource(ConnectionPool.java:1082)
      3. com.sun.enterprise.resource.pool.ConnectionPool.freeResource(ConnectionPool.java:1057)
      4. com.sun.enterprise.resource.pool.ConnectionPool.freeUnenlistedResource(ConnectionPool.java:1053)
      5. com.sun.enterprise.resource.pool.ConnectionPool.resourceClosed(ConnectionPool.java:1017)
      6. com.sun.enterprise.resource.pool.PoolManagerImpl.putbackResourceToPool(PoolManagerImpl.java:426)
      7. com.sun.enterprise.resource.pool.PoolManagerImpl.resourceClosed(PoolManagerImpl.java:380)
      8. com.sun.enterprise.resource.listener.LocalTxConnectionEventListener.connectionClosed(LocalTxConnectionEventListener.java:77)
      8 frames
    4. Embedded GlassFish Web
      ConnectionHolder40.close
      1. com.sun.gjc.spi.ManagedConnectionImpl.connectionClosed(ManagedConnectionImpl.java:783)
      2. com.sun.gjc.spi.base.ConnectionHolder.close(ConnectionHolder.java:214)
      3. com.sun.gjc.spi.jdbc40.ConnectionHolder40.close(ConnectionHolder40.java:591)
      3 frames
    5. EclipseLink (non-OSGi)
      EJBQueryImpl.getSingleResult
      1. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.closeDatasourceConnection(DatabaseAccessor.java:495)
      2. org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.closeConnection(DatasourceAccessor.java:520)
      3. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.closeConnection(DatabaseAccessor.java:520)
      4. org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.decrementCallCount(DatasourceAccessor.java:290)
      5. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.closeStatement(DatabaseAccessor.java:403)
      6. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:679)
      7. org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
      8. org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055)
      9. org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:570)
      10. org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:258)
      11. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
      12. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
      13. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
      14. org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:694)
      15. org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2740)
      16. org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllReportQueryRows(ExpressionQueryMechanism.java:2677)
      17. org.eclipse.persistence.queries.ReportQuery.executeDatabaseQuery(ReportQuery.java:852)
      18. org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
      19. org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:1134)
      20. org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:460)
      21. org.eclipse.persistence.queries.ObjectLevelReadQuery.executeInUnitOfWork(ObjectLevelReadQuery.java:1222)
      22. org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
      23. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
      24. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
      25. org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
      26. org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
      27. org.eclipse.persistence.internal.jpa.QueryImpl.getSingleResult(QueryImpl.java:521)
      28. org.eclipse.persistence.internal.jpa.EJBQueryImpl.getSingleResult(EJBQueryImpl.java:400)
      28 frames
    6. org.glassfish.ejb
      TimerBean.countTimersByContainer
      1. org.glassfish.ejb.persistent.timer.TimerBean.countTimersByContainer(TimerBean.java:229)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:497)
      4 frames
    8. Embedded GlassFish Web
      SystemInterceptorProxy.aroundInvoke
      1. org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1081)
      2. org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1153)
      3. com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:4758)
      4. com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:656)
      5. com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:836)
      6. com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:608)
      7. com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doCall(SystemInterceptorProxy.java:163)
      8. com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:140)
      8 frames
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:497)
      4 frames
    10. Embedded GlassFish Web
      EJBLocalObjectInvocationHandlerDelegate.invoke
      1. com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:895)
      2. com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:835)
      3. com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:374)
      4. com.sun.ejb.containers.BaseContainer.__intercept(BaseContainer.java:4730)
      5. com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:4718)
      6. com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:212)
      7. com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:88)
      7 frames
    11. com.sun.proxy
      $Proxy314.countTimersByContainer
      1. com.sun.proxy.$Proxy314.countTimersByContainer(Unknown Source)
      1 frame
    12. org.glassfish.ejb
      PersistentEJBTimerService.createSchedulesOnServer
      1. org.glassfish.ejb.persistent.timer.PersistentEJBTimerService.createSchedules(PersistentEJBTimerService.java:825)
      2. org.glassfish.ejb.persistent.timer.PersistentEJBTimerService.createSchedulesOnServer(PersistentEJBTimerService.java:804)
      2 frames
    13. Embedded GlassFish Web
      EjbDeployer.event
      1. org.glassfish.ejb.startup.EjbDeployer.createAutomaticPersistentTimersForEJB(EjbDeployer.java:559)
      2. org.glassfish.ejb.startup.EjbDeployer.checkEjbBundleForTimers(EjbDeployer.java:534)
      3. org.glassfish.ejb.startup.EjbDeployer.event(EjbDeployer.java:507)
      3 frames
    14. Kernel Classes
      ApplicationLifecycle.deploy
      1. org.glassfish.kernel.event.EventsImpl.send(EventsImpl.java:131)
      2. com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:488)
      3. com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:220)
      3 frames
    15. Embedded GlassFish Web
      DeployCommand.execute
      1. org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:487)
      1 frame
    16. Kernel Classes
      CommandRunnerImpl$2$1.run
      1. com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:539)
      2. com.sun.enterprise.v3.admin.CommandRunnerImpl$2$1.run(CommandRunnerImpl.java:535)
      2 frames
    17. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:360)
      2 frames
    18. Kernel Classes
      CommandRunnerImpl$3.run
      1. com.sun.enterprise.v3.admin.CommandRunnerImpl$2.execute(CommandRunnerImpl.java:534)
      2. com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:565)
      3. com.sun.enterprise.v3.admin.CommandRunnerImpl$3.run(CommandRunnerImpl.java:557)
      3 frames
    19. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:360)
      2 frames
    20. Kernel Classes
      CommandRunnerImpl$ExecutionContext.execute
      1. com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:556)
      2. com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1464)
      3. com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1300(CommandRunnerImpl.java:109)
      4. com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1846)
      5. com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1722)
      5 frames
    21. GlassFish Admin
      TemplateListOfResource.createResource
      1. org.glassfish.admin.rest.utils.ResourceUtil.runCommand(ResourceUtil.java:263)
      2. org.glassfish.admin.rest.utils.ResourceUtil.runCommand(ResourceUtil.java:234)
      3. org.glassfish.admin.rest.utils.ResourceUtil.runCommand(ResourceUtil.java:285)
      4. org.glassfish.admin.rest.resources.TemplateListOfResource.createResource(TemplateListOfResource.java:136)
      4 frames
    22. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:497)
      4 frames
    23. jersey-core-server
      ServerRuntime$2.run
      1. org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
      2. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
      3. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
      4. org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
      5. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
      6. org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
      7. org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
      8. org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
      9. org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
      9 frames
    24. Jersey Core
      RequestScope.runInScope
      1. org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
      2. org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
      3. org.glassfish.jersey.internal.Errors.process(Errors.java:315)
      4. org.glassfish.jersey.internal.Errors.process(Errors.java:297)
      5. org.glassfish.jersey.internal.Errors.process(Errors.java:267)
      6. org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
      6 frames
    25. jersey-core-server
      ApplicationHandler.handle
      1. org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
      2. org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
      2 frames
    26. jersey-container-grizzly2-http
      GrizzlyHttpContainer.service
      1. org.glassfish.jersey.grizzly2.httpserver.GrizzlyHttpContainer.service(GrizzlyHttpContainer.java:384)
      1 frame
    27. GlassFish Admin
      RestAdapter.service
      1. org.glassfish.admin.rest.adapter.RestAdapter$2.service(RestAdapter.java:316)
      2. org.glassfish.admin.rest.adapter.RestAdapter.service(RestAdapter.java:179)
      2 frames
    28. Kernel Classes
      ContainerMapper.service
      1. com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:466)
      2. com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:169)
      2 frames
    29. Grizzly Server
      HttpHandler.runService
      1. org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:206)
      1 frame