Expand my Community achievements bar.

DB connection problem : Connection handle has been closed and is unusable

Avatar

Former Community Member
Dear all,

I have all the time this error when 2 or more users work with the workflow.

Any idea?



Thanks in advance,

philippe



[com.adobe.idp.storeprovider.jdbc.DBStatement] errorCode:12290 errorCodeHEX:0x3002 message:execute query failure(select * from (select /*+ FIRST_ROWS */ * from EDCCREDENTIALENTITY where (EDCCREDENTIALENTITY.canonicalName = ?)) where rownum < 2) chainedException:java.sql.SQLException: Connection handle has been closed and is unusablechainedExceptionMessage:Connection handle has been closed and is unusable chainedException trace:java.sql.SQLException: Connection handle has been closed and is unusable

at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:526)

at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:513)

at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:184)

at com.adobe.idp.storeprovider.jdbc.DBStatement.executeQuery(DBStatement.java:295)

at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.retrieveAll(DBStoreProvider.java:2048)

at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.retrieve(DBStoreProvider.java:1757)

at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.retrieve(DBStoreProvider.java:1804)

at com.adobe.idp.storeprovider.spi.StoreProvider.retrieve(StoreProvider.java:146)

at com.adobe.idp.um.credential.CredentialHelper.findCredentialEntityKeyData(CredentialHelper.java:73)

at com.adobe.idp.um.credential.CredentialClient.getCredentials(CredentialClient.java:92)

at com.adobe.workspace.AssemblerUtility.getAdminContext(AssemblerUtility.java:517)

at com.adobe.workspace.users.Authentication.doSSO(Authentication.java:294)

at com.adobe.workspace.users.Authentication.servletCheckLogin(Authentication.java:234)

at com.adobe.workspace.users.AuthenticationServlet.doGet(AuthenticationServlet.java:53)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

at sun.reflect.GeneratedMethodAccessor280.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)

at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)

at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:161)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:245)

at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:50)

at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:156)

at java.security.AccessController.doPrivileged(Native Method)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:152)

at com.adobe.workspace.events.RemoteEventClientLifeCycle.doFilter(RemoteEventClientLifeCycle.java:126)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)

at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)

at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:217)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197)

at org.apache.catalina.core.ApplicationFilterChain.access
3 Replies

Avatar

Former Community Member
Hi,



Did you find a solution for this problem? At our company, we're having trouble to log in to Adobe Workspace with exactly the same error.

Avatar

Former Community Member
If you have MySQL database you might want to do the following (but if you don't have MySQL then you need to use the appropriate class):

In adobe-ds.xml and mysql-ds.xml try adding the following 4 lines to each datasource:

com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker
com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter
SELECT count(*) from DUAL
SELECT count(*) from DUAL