[jboss-user] [Beginners Corner] - Re: Error setting up MySql as DefaultDS

[pepelara]

Thanks Peter for your interesting, indeed.

Yes, it is 4.0.0. I looked for it because I am using EJB 2.0 and I was not sure what version use. This is my *-ds.xml,
anonymous wrote : 
  |  
  |   <local-tx-datasource> 
  |  
  |     <jndi-name>DefaultDS</jndi-name> 
  |     <connection-url>jdbc:mysql://localhost:3306/myDB</connection-url> 
  |     <driver-class>com.mysql.jdbc.Driver</driver-class> 
  |  
  |     <user-name>some user</user-name> 
  |     some password 
  |     
  |     <!--
  |     <security-domain>MySqlDbRealm</security-domain>
  |     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
  |     <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
  | 
  |     <new-connection-sql>select * from books</new-connection-sql>
  |     <check-valid-connection-sql>select id from books</check-valid-connection-sql>
  |     -->
  | 
  |     <!-- Typemapping for JBoss 4.0.0 --> 
  |      
  |       <type-mapping>mySQL</type-mapping> 
  |      
  |  
  |   </local-tx-datasource> 
  | 
  | 

I took it from the instruction in Jboss.org (http://wiki.jboss.org/wiki/MySQL)

Can you see anything wrong?

Regarding,
Jose Alvarez de Lara

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

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