com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

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

    Payara Cluster DB Connection Issue

    Stack Overflow | 6 months ago | ci_ms
    com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

    Root Cause Analysis

    1. com.microsoft.sqlserver.jdbc.SQLServerException

      The connection is closed.

      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError()
    2. com.microsoft.sqlserver
      SQLServerConnection.getTransactionIsolation
      1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
      2. com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:388)
      3. com.microsoft.sqlserver.jdbc.SQLServerConnection.getTransactionIsolation(SQLServerConnection.java:2102)
      3 frames
    3. Embedded GlassFish Web
      ManagedConnectionImpl.cleanup
      1. com.sun.gjc.spi.ManagedConnectionFactoryImpl.resetIsolation(ManagedConnectionFactoryImpl.java:523)
      2. com.sun.gjc.spi.ManagedConnectionImpl.resetConnectionProperties(ManagedConnectionImpl.java:495)
      3. com.sun.gjc.spi.ManagedConnectionImpl.cleanup(ManagedConnectionImpl.java:347)
      3 frames
    4. 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
    5. 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
    6. 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
    7. org.glassfish.ejb
      TimerBean.countTimersByContainer
      1. org.glassfish.ejb.persistent.timer.TimerBean.countTimersByContainer(TimerBean.java:229)
      1 frame
    8. 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
    9. 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
    10. 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
    11. 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
    12. com.sun.proxy
      $Proxy314.countTimersByContainer
      1. com.sun.proxy.$Proxy314.countTimersByContainer(Unknown Source)
      1 frame
    13. 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
    14. 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
    15. 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
    16. Embedded GlassFish Web
      DeployCommand.execute
      1. org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:487)
      1 frame
    17. 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
    18. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:360)
      2 frames
    19. 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
    20. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:360)
      2 frames