Skip to main content
Bumped by Community user
deleted 4 characters in body
Source Link
Velmurugan
  • 8.2k
  • 2
  • 15
  • 27

We are getting below exception in the content service logs:

ERROR JPQLExecutor - Can not execute query: org.hibernate.exception.GenericJDBCException: Could not close connection at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final]

Followed by below exception line:

Caused by: java.sql.SQLException: Already closed. at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191) ~[commons-dbcp-1.4.jar:1.4] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.closeConnection(DatasourceConnectionProviderImpl.java:144) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.releaseConnection(AbstractSessionImpl.java:391) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:255) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final]

I found this link on SO website, which suggests to configureconfiguring few parameters in datasourcedata source config https://stackoverflow.com/questions/16331959/java-sql-sqlexception-already-closed

However, I am unable to find any datasource config/XML file for Content Service.

My confusions/Queries:

  • Content service uses/is itself Apache Tomcat App  ?

  • Does this service has files like: server.xml  ? Like we have in an apache tomcat app  ?

We are getting below exception in the content service logs:

ERROR JPQLExecutor - Can not execute query: org.hibernate.exception.GenericJDBCException: Could not close connection at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final]

Followed by below exception line:

Caused by: java.sql.SQLException: Already closed. at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191) ~[commons-dbcp-1.4.jar:1.4] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.closeConnection(DatasourceConnectionProviderImpl.java:144) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.releaseConnection(AbstractSessionImpl.java:391) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:255) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final]

I found this link on SO website, which suggests to configure few parameters in datasource config https://stackoverflow.com/questions/16331959/java-sql-sqlexception-already-closed

However, I am unable to find any datasource config/XML file for Content Service.

My confusions/Queries:

  • Content service uses/is itself Apache Tomcat App  ?

  • Does this service has files like: server.xml  ? Like we have in an apache tomcat app  ?

We are getting below exception in the content service logs:

ERROR JPQLExecutor - Can not execute query: org.hibernate.exception.GenericJDBCException: Could not close connection at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final]

Followed by below exception line:

Caused by: java.sql.SQLException: Already closed. at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191) ~[commons-dbcp-1.4.jar:1.4] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.closeConnection(DatasourceConnectionProviderImpl.java:144) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.releaseConnection(AbstractSessionImpl.java:391) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:255) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final]

I found this link on SO website, which suggests configuring few parameters in data source config https://stackoverflow.com/questions/16331959/java-sql-sqlexception-already-closed

However, I am unable to find any datasource config/XML file for Content Service.

My confusions/Queries:

  • Content service uses/is itself Apache Tomcat App?

  • Does this service has files like server.xml? Like we have in an apache tomcat app?

Source Link

SDL WEB 8 | Content Service exception | java.sql.SQLException: Already closed

We are getting below exception in the content service logs:

ERROR JPQLExecutor - Can not execute query: org.hibernate.exception.GenericJDBCException: Could not close connection at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final]

Followed by below exception line:

Caused by: java.sql.SQLException: Already closed. at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191) ~[commons-dbcp-1.4.jar:1.4] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.closeConnection(DatasourceConnectionProviderImpl.java:144) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.releaseConnection(AbstractSessionImpl.java:391) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final] at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:255) ~[hibernate-core-4.3.9.Final.jar:4.3.9.Final]

I found this link on SO website, which suggests to configure few parameters in datasource config https://stackoverflow.com/questions/16331959/java-sql-sqlexception-already-closed

However, I am unable to find any datasource config/XML file for Content Service.

My confusions/Queries:

  • Content service uses/is itself Apache Tomcat App ?

  • Does this service has files like: server.xml ? Like we have in an apache tomcat app ?