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 ---
| [EMAIL PROTECTED] {
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 ---
| [EMAIL PROTECTED] {
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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
