sorry wrong config file, it must be mysql-ds.xml | <?xml version="1.0" encoding="UTF-8"?> | | <datasources> | <local-tx-datasource> | <jndi-name>jdbc/ProdDataSource</jndi-name> | <connection-url>jdbc:mysql://localhost:3306/mydb?characterEncoding=utf-8&autoReconnect=true | </connection-url> | <use-java-context>true</use-java-context> | <driver-class>com.mysql.jdbc.Driver</driver-class> | <user-name>***</user-name> | <password>***</password> | <max-pool-size>10</max-pool-size> | <check-valid-connection-sql> | select CID from COMMON_ASSET where CID=1000 | </check-valid-connection-sql> | | <metadata> | <type-mapping>mySQL</type-mapping> | </metadata> | | </local-tx-datasource> | | <local-tx-datasource> | <jndi-name>jdbc/LiveDataSource</jndi-name> | <connection-url>jdbc:mysql://localhost:3306/mydb2?characterEncoding=utf-8&autoReconnect=true | </connection-url> | <use-java-context>true</use-java-context> | <driver-class>com.mysql.jdbc.Driver</driver-class> | <user-name>***</user-name> | <password>***</password> | <max-pool-size>10</max-pool-size> | <check-valid-connection-sql> | select CID from COMMON_ASSET where CID=1000 | </check-valid-connection-sql> | | <metadata> | <type-mapping>mySQL</type-mapping> | </metadata> | | </local-tx-datasource> | | </datasources> |
but that didn't solve the problem, still the same error View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4212568#4212568 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4212568 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
