Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

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.

Avatar

Avatar
Level 4
Jayan_Kandathil
Level 4

Likes

0 likes

Total Posts

140 posts

Correct Reply

0 solutions
View profile

Avatar
Level 4
Jayan_Kandathil
Level 4

Likes

0 likes

Total Posts

140 posts

Correct Reply

0 solutions
View profile
Jayan_Kandathil
Level 4

12-08-2008

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