[jboss-user] [Installation, Configuration & DEPLOYMENT] - JBoss AS 4.2.0 with MySQL
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@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@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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...