[jboss-user] [Beginners Corner] - Re: DataSource binding to org.jboss.resource.adapter.jdbc.Wr

[mendret]

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