[jboss-user] TxConnectionManager issue

[Ákos Maróy]

no takers on the issue below? didn't anyone bump into this one?

Ákos Maróy wrote:
> Hi,
> 
> While developing a web application on JBoss, I come to the following
> issue at one point:
> 
> 19:02:24,119 WARN  [TxConnectionManager] Connection error occured:
> org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener at 76bbe4cf[state=NORMAL
> mc=org.jboss.resource.adapter.jdbc.local.LocalManagedConnection at 59d02cf0
> handles=2 lastUse=1186592544082 permit=true trackByTx=true
> mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool at 72366ea0
> context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool at 539904f4
> xaResource=org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource at 63145a0c
> txSync=null]
> 
> 
> 
> and then, no database related stuff works any longer on that page, and I
> get errors like:
> 
> 
> java.sql.SQLException: No operations allowed after connection closed.
> 
> 
> org.jboss.util.NestedSQLException: Could not enlist in transaction on
> entering meta-aware object!; - nested throwable:
> (java.lang.IllegalStateException: Can't enlist - already a tx!); -
> nested throwable: (org.jboss.resource.JBossResourceException: Could not
> enlist in transaction on entering meta-aware object!; - nested
> throwable: (java.lang.IllegalStateException: Can't enlist - already a tx!))
> 
> 
> 
> It seems like some connection dropped / lost issue. I'm using MySQL as a
> backend. The DS configuration is fairly simple:
> 
>   <local-tx-datasource>
>     <jndi-name>seeDataSource</jndi-name>
>     <connection-url>jdbc:mysql://localhost:3306/Foo</connection-url>
>     <driver-class>com.mysql.jdbc.Driver</driver-class>
>     <user-name>foo</user-name>
>     <password>bar</password>
> 
> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
>     <metadata>
>        <type-mapping>mySQL</type-mapping>
>     </metadata>
>   </local-tx-datasource>
> 
> 
> What could be wrong?
> 
> 
> Akos
> _______________________________________________
> jboss-user mailing list
> jboss-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jboss-user
>