[jboss-user] [JBoss Seam] - Re: Connection handle has been closed and is unusable

[msduk]

<local-tx-datasource>
  |         <jndi-name>nrg2Datasource</jndi-name>
  |         <connection-url>jdbc:mysql://localhost:3306/db</connection-url>
  |         <driver-class>com.mysql.jdbc.Driver</driver-class>
  |         <user-name>db</user-name>
  |         <password>pass</password>
  |         <exception-sorter-class-name>
  |             org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter
  |         </exception-sorter-class-name>
  | 		<metadata>
  |             <type-mapping>mySQL</type-mapping>
  |         </metadata>
  |         <valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name>
  |         <check-valid-connection-sql>SELECT count(warehouseId) FROM warehouse</check-valid-connection-sql>
  |         <new-connection-sql>SELECT count(warehouseId) FROM warehouse</new-connection-sql>
  |     </local-tx-datasource>

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4073108#4073108

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4073108