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

Reply via email to