[jboss-user] [Beginners Corner] - Jboss 4.2.1 mysql-ds.xml initialization error.

[zulqarnain]

Hi,
I've installed jboss 4.2.1 and is trying to setup mysql connection.
I've copied mysql-connector-java-5.1.5-bin.jar to ../default/lib/
Also I've setup mysql-ds.xml in ../deploy/ and removed hsqldb* from ../jms/ . 
Now when I start the jboss server I got the following error:
2007-11-14 06:23:47,079 ERROR [org.jboss.deployment.MainDeployer] Could not initialise deployment: file:/opt/jboss4/server/default/deploy/mysql-ds.xml
2007-11-14 06:23:51,611 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:
Also below is my mysql-ds.xml file:
<?xml version="1.0" encoding="UTF-8"?>
  | 
  | <datasources>
  |   <local-tx-datasource>
  |     <jndi-name>JNDIName</jndi-name>
  |     <connection-url>jdbc:mysql://localhost:myport/myDBName</connection-url>
  |     <driver-class>com.mysql.jdbc.Driver</driver-class>
  |     <user-name>username</user-name>
  |     <password>password</password>
  |     <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>
  |     <metadata>
  |        <type-mapping>mySQL</type-mapping>
  |     </metadata>
  |   </local-tx-datasource>
  | </datasources>
  | 
Any ideas please....

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

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