JBOSS & MySql module, install error.
brenden.t May 20, 2013 9:18 PMHi all, I'm getting an error installing a MySql driver with JBOSS 7. I've done some searches and I see a lot of other folks confused too, so maybe I can ask some questions and clear things up.
The error is:
JBAS014775: | New missing/unsatisfied dependencies: |
service jboss.jdbc-driver.mysql (missing) dependents: [service jboss.data-source.java:/simpletth] |
I'm using JBoss 7.1.1, Final:
[ec2-user@domU-12-31-39-0A-A0-29 ~]$ ls jboss*
jboss-as-7.1.1.Final.tar.gz
I installed the driver as a module:
[jboss@domU-12-31-39-0A-A0-29 main]$ ls
module.xml mysql-connector-java-5.1.22-bin.jar
[jboss@domU-12-31-39-0A-A0-29 main]$ pwd
/usr/share/jboss-as/modules/com/mysql/main
[jboss@domU-12-31-39-0A-A0-29 main]$
Here's the module.xml file listing:
[jboss@domU-12-31-39-0A-A0-29 main]$ cat module.xml
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.mysql">
<resources>
<resource-root path="mysql-connector-java-5.1.22.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
Here's the datasources from standalone/configuration/standalone.xml:
<datasources> | |
<datasource jta="true" jndi-name="java:/simpletth" pool-name="simpletthPool" enabled="true" use-java-context="true"> | |
<connection-url>jdbc:mysql://localhost/simpletth</connection-url> | |
<driver>mysql</driver> | |
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> | |
<security> | |
<user-name>tthuser</user-name> | |
<password>XXXxxx</password> | |
</security> | |
<validation> | |
<check-valid-connection-sql>select 1</check-valid-connection-sql> | |
<exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter"/> | |
</validation> | |
<statement> | |
<prepared-statement-cache-size>10</prepared-statement-cache-size> | |
<share-prepared-statements>true</share-prepared-statements> | |
</statement> | |
</datasource> |
And the relevent driver section:
<drivers> | |
<driver name="mysql" module="com.mysql"> | |
<xa-datasource-class>com.mysql.jdbc.Driver</xa-datasource-class> | |
</driver> |
So I'm kinda stuck, since I think I followed the directions exactly. Does anyone have any ideas? I'm pretty stumped. The error message is fairly usless, it seems to indicate anything could be wrong,and that gives me a lot to try to sort through.
Does anyone know what the xa-datasource-class tag does btw? That one see pretty confusing in the docs.