Highlighted

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

Avatar

15-05-2008

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

Replies

Highlighted

Avatar

12-08-2008

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

Avatar

Avatar

Jayan_Kandathil

Avatar

Jayan_Kandathil

Jayan_Kandathil

12-08-2008

Highlighted

Avatar

14-08-2008

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