[jboss-user] [Installation, Configuration & DEPLOYMENT] - JBoss AS 4.2.0 with MySQL

[rjstanford]

While setting up a new server I've been having a really hard time getting it to see a local MySQL database.  The error message isn't particularly descriptive (to me at least) and I'm reaching the end of the useful google threads.  Let me go through the steps that I've followed:

The mysql-connector-java-5.0.6-bin.jar file has been placed into /server/default/lib

A new local-mysql.xml file has been placed into /server/default/deploy - initially I was using a very simple one but I went ahead and recopied the jca example from docs/examples/jca/mysql-ds.xml and made the changes for username/password/etc.  The new file is:

<?xml version="1.0" encoding="UTF-8"?>
  | 
  | <datasources>
  |   <local-tx-datasource>
  |     <jndi-name>MySqlDS</jndi-name>
  |     <connection-url>jdbc:mysql://localhost:3306/kimbia</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>

When the file is copied into the deploy directory, the following log message is created:

2007-07-25 10:06:47,132 DEBUG [org.jboss.deployment.MainDeployer] undeploy 'file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml' : package not deployed
  | 2007-07-25 10:06:47,133 DEBUG [org.jboss.deployment.MainDeployer] Starting deployment of package: file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml
  | 2007-07-25 10:06:47,133 DEBUG [org.jboss.deployment.MainDeployer] Starting deployment (init step) of package at: file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml
  | 2007-07-25 10:06:47,133 DEBUG [org.jboss.deployment.MainDeployer] Copying file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml -> /opt/jboss-as/4.2.0.GA/server/default/tmp/deploy/tmp35063local-mysql.xml
  | 2007-07-25 10:06:47,135 DEBUG [org.jboss.deployment.MainDeployer] No deployer found for url: file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml
  | 2007-07-25 10:06:47,135 DEBUG [org.jboss.deployment.MainDeployer] deployment waiting for deployer: file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml
  | 2007-07-25 10:06:47,135 DEBUG [org.jboss.deployment.MainDeployer] Deployment of package: file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml is waiting for an appropriate deployer.
  | 2007-07-25 10:06:47,138 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:
  | 
  | --- Packages waiting for a deployer ---
  | org.jboss.deployment.DeploymentInfo at 2e084371 { url=file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml }
  |   deployer: null
  |   status: null
  |   state: INIT_WAITING_DEPLOYER
  |   watch: file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml
  |   altDD: null
  |   lastDeployed: 1185374184789
  |   lastModified: 1185374184000
  |   mbeans:
  | 
  | --- Incompletely deployed packages ---
  | org.jboss.deployment.DeploymentInfo at 2e084371 { url=file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml }
  |   deployer: null
  |   status: null
  |   state: INIT_WAITING_DEPLOYER
  |   watch: file:/opt/jboss-as/4.2.0.GA/server/default/deploy/local-mysql.xml
  |   altDD: null
  |   lastDeployed: 1185374184789
  |   lastModified: 1185374184000
  |   mbeans:

Everything I've seen referring to this error (which I hadn't previously encountered) indicated that there was either a typo in the file or a missing driver jar.  Since neither of those seem to be the case, I'm looking for a new direction to pursue... any ideas?

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

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