com.liferay.portal.kernel.job.JobExecutionException

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

Samebug tips1

If you're not using yet, consider using the SQLServerDataSource to set your server configurations. Also, check if the server is accepting TCP/IP connections and if there's no firewall blocking the connections.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web15

  • via Liferay Issues by Rushikesh, 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
  • via Liferay Issues by Rushikesh, 11 months ago
    com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
  • com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
  • Stack trace

    • com.liferay.portal.kernel.job.JobExecutionException: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at com.liferay.counter.service.persistence.ConnectionHeartbeatJob.execute(ConnectionHeartbeatJob.java:54) at com.liferay.portal.job.JobWrapper.execute(JobWrapper.java:63) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171) at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:319) at com.microsoft.sqlserver.jdbc.SQLServerConnection.createStatement(SQLServerConnection.java:1829) at com.microsoft.sqlserver.jdbc.SQLServerConnection.createStatement(SQLServerConnection.java:1542) at com.mchange.v2.c3p0.impl.NewProxyConnection.createStatement(NewProxyConnection.java:96) at sun.reflect.GeneratedMethodAccessor936.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy$LazyConnectionInvocationHandler.invoke(LazyConnectionDataSourceProxy.java:364) at $Proxy62.createStatement(Unknown Source) at com.liferay.counter.service.persistence.ConnectionHeartbeatJob.sendHeartbeat(ConnectionHeartbeatJob.java:69) at com.liferay.counter.service.persistence.ConnectionHeartbeatJob.execute(ConnectionHeartbeatJob.java:51) ... 3 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Once, 2 months ago
    Unknown user
    Once, 1 year ago
    4 times, 4 weeks ago
    2 times, 1 month ago
    Unknown user
    Once, 5 months ago
    94 more bugmates