JBOSS & MySql module, install error.

[brenden.t]

Hi 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.

[wdfink]

You should look to problems before that JBAS0014775.

If I'm right the problem is the module installation:

[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>

The file name is mysql-connector-java-5.1.22-bin.jar from your ls but if I look to the module.xml the filename is different.

[brenden.t]

Sorry, got busy with other stuff and couldn't get back to this right away.

That's for pointing that out, I was totally missing that misspelling.  I haven't had a chance to try this yet, but I'm sure you've located a real problem, so I'll mark this question as answered.  Thanks again!

I'm curious -- why do you say "look for other errors?"  I have a simple install that I'm adding features to slowly, so there's not much in the boot log, and I'm sure this is the only error message being reported.  Is there a better place to look for errors? 

I'll try to post the existing error log, if needed, so folks can point out what I may have missed.