Connections problems between JBoss-EAP-5 and Sybase ASE 15.5
Issue
- Using Sybase DB version 12.5.3 and upgraded to Sybase ASE 15.5. The deployment went fine, however we are having some issues while closing the query statements. Currently we are using Sybase Driver 6.0 and I also checked with Sybase Driver 7.0 too. These are the WARN/ERROR messages :
2013-05-15 17:44:21,517 WARN [org.jboss.resource.connectionmanager.TxConnectionManager] (http-162.49.169.118-12080-1) Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@7c3f475d[state=NORMAL mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection@5f9cbb71 handles=1 lastUse=1368632647502 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@2ad628c1 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@520dacdf xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource@354f12ba txSync=null]
java.sql.SQLException: JZ006: Caught IOException: com.sybase.jdbc3.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed.
at com.sybase.jdbc3.jdbc.ErrorMessage.createIOEKilledConnEx(Unknown Source)
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.cancel(Unknown Source)
at com.sybase.jdbc3.tds.Tds.cancel(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.a(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.checkStatement(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.setMaxRows(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedStatement.setMaxRows(WrappedStatement.java:399)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:299)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:235)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1825)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:258)
at org.hibernate.loader.Loader.doList(Loader.java:2233)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2130)
at org.hibernate.loader.Loader.list(Loader.java:2125)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1150)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:116)
at com.xyz.dx.ejb.utility.facades.impl.PermissionFacade.userHasPermission(PermissionFacade.java:191)
t java.lang.Thread.run(Thread.java:662)
Environment
- JBoss Enterprise Application Platform (EAP)
- 5.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
