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

Stack Overflow | ci_ms | 3 months ago
  1. 0

    Payara Cluster DB Connection Issue

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

    Problem: Closing a DB connection in an Entity Bean!

    Oracle Community | 1 decade ago | 843830
    javax.resource.ResourceException: The isolation level for this connection could not be retrieved
  3. 0

    How to reestablish a JDBC connection after a timeout?

    Stack Overflow | 6 years ago | Dmitry Chornyi
    javax.resource.ResourceException: This Managed Connection is not valid as the phyiscal connection is not usable
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Full Text Bug Listing

    redhat.com | 11 months ago
    javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection
  6. 0

    JBoss AS 7 shutdown - connection manager closed... | JBoss Developer

    jboss.org | 4 months ago
    org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000451: The connection manager is shutdown: java:/my/DS1

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