Trying it now...
EDIT:
Changing the <driver-class> line in -ds.xml to "<driver>mysql-connector-java-5.1.13-bin.jar</driver>" doesn't seem to work, however the error is different now:
09:57:52,628 INFO [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-4) Starting Coyote HTTP/1.1 on http-bcjboss7-10.10.10.172-8080
09:57:53,125 INFO [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-11) JBoss Web Services - Stack CXF Server 4.0.2.GA
09:57:53,871 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-9) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]
09:57:54,131 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-10) JBAS015012: Started FileSystemDeploymentService for directory /home/bcantrick/jboss/jboss-as-7.1.1.Final/standalone/deployments
09:57:54,140 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found test.war in deployment directory. To trigger deployment create a file called test.war.dodeploy
09:57:54,148 INFO [org.jboss.as.remoting] (MSC service thread 1-17) JBAS017100: Listening on bcjboss7/10.10.10.172:4447
09:57:54,148 INFO [org.jboss.as.remoting] (MSC service thread 1-18) JBAS017100: Listening on bcjboss7/10.10.10.172:9999
09:57:54,606 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://10.10.10.172:9990
09:57:54,608 INFO [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss AS 7.1.1.Final "Brontes" started in 8986ms - Started 133 of 208 services (74 services are passive or on-demand)
09:58:24,291 INFO [org.jboss.as.server.deployment] (MSC service thread 1-23) JBAS015876: Starting deployment of "test.war"
09:58:25,544 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-16) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
09:58:25,919 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015870: Deploy of deployment "test.war" was rolled back with failure message {"JBAS014771: Services with missing/unavailable dependencies" => ["jboss.data-source.mainPoolTxjboss.jdbc-driver.mysql-connector-java-5_1_13-bin_jarMissing[jboss.data-source.mainPoolTxjboss.jdbc-driver.mysql-connector-java-5_1_13-bin_jar]","jboss.data-source.mainPoolNoTxjboss.jdbc-driver.mysql-connector-java-5_1_13-bin_jarMissing[jboss.data-source.mainPoolNoTxjboss.jdbc-driver.mysql-connector-java-5_1_13-bin_jar]"]}
09:58:25,954 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) JBAS010409: Unbound data source [mainPoolNoTx]
09:58:25,955 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-15) JBAS010409: Unbound data source [mainPoolTx]
09:58:25,978 INFO [org.jboss.as.server.deployment] (MSC service thread 1-14) JBAS015877: Stopped deployment test.war in 60ms
09:58:25,983 INFO [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report
Now adding the MySQL driver as a module in standalone.conf and tweaking .xml files...
EDIT 2:
Still doesn't seem to be working. Errors are similar, though not identical, to the ones at the start of the discussion. Typical output looks like:
[bcantrick@titan bin]$ rm ../standalone/log/* ; ./standalone.sh
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /home/bcantrick/jboss/jboss-as-7.1.1.Final
JAVA: /usr/local/java/jdk1.6.0_22/bin/java
JAVA_OPTS: -server -XX:+UseCompressedOops -XX:+TieredCompilation -Xms64m -Xmx512m -XX:MaxPermSize=256m -Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true -Djboss.server.default.config=standalone.xml -Xrunjdwp:transport=dt_socket,address=8787,server=y,suspend=n -Djboss.bind.address=bcjboss7 -Djboss.bind.address.management=bcjboss7 -DBCONNECTED_CONFIG_DIR=/home/bcantrick/jboss/jboss-as-7.1.1.Final/standalone/deployments/appserver.war/WEB-INF
=========================================================================
Listening for transport dt_socket at address: 8787
10:53:16,114 INFO [org.jboss.modules] JBoss Modules version 1.1.1.GA
10:53:16,365 INFO [org.jboss.msc] JBoss MSC version 1.0.2.GA
10:53:16,435 INFO [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" starting
10:53:18,269 INFO [org.jboss.as.server] JBAS015888: Creating http management service using socket-binding (management-http)
10:53:18,270 INFO [org.xnio] XNIO Version 3.0.3.GA
10:53:18,314 INFO [org.xnio.nio] XNIO NIO Implementation Version 3.0.3.GA
10:53:18,343 INFO [org.jboss.remoting] JBoss Remoting version 3.2.3.GA
10:53:18,391 INFO [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers
10:53:18,398 INFO [org.jboss.as.configadmin] (ServerService Thread Pool -- 26) JBAS016200: Activating ConfigAdmin Subsystem
10:53:18,417 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 31) JBAS010280: Activating Infinispan subsystem.
10:53:18,430 INFO [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011940: Activating OSGi Subsystem
10:53:18,440 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800: Activating Naming Subsystem
10:53:18,441 INFO [org.jboss.as.security] (ServerService Thread Pool -- 44) JBAS013101: Activating Security Subsystem
10:53:18,451 INFO [org.jboss.as.security] (MSC service thread 1-16) JBAS013100: Current PicketBox version=4.0.7.Final
10:53:18,481 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48) JBAS015537: Activating WebServices Extension
10:53:18,556 INFO [org.jboss.as.connector] (MSC service thread 1-15) JBAS010408: Starting JCA Subsystem (JBoss IronJacamar 1.0.9.Final)
10:53:18,567 INFO [org.jboss.as.naming] (MSC service thread 1-22) JBAS011802: Starting Naming Service
10:53:18,584 INFO [org.jboss.as.mail.extension] (MSC service thread 1-19) JBAS015400: Bound mail session [java:jboss/mail/Default]
10:53:18,679 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
10:53:18,701 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 27) JBAS010403: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
10:53:18,744 INFO [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-22) Starting Coyote HTTP/1.1 on http-bcjboss7-10.10.10.172-8080
10:53:18,752 INFO [org.jboss.ws.common.management.AbstractServerConfig] (MSC service thread 1-14) JBoss Web Services - Stack CXF Server 4.0.2.GA
10:53:19,355 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-11) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]
10:53:19,903 INFO [org.jboss.as.remoting] (MSC service thread 1-23) JBAS017100: Listening on bcjboss7/10.10.10.172:9999
10:53:19,903 INFO [org.jboss.as.remoting] (MSC service thread 1-1) JBAS017100: Listening on bcjboss7/10.10.10.172:4447
10:53:19,908 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-11) JBAS015012: Started FileSystemDeploymentService for directory /home/bcantrick/jboss/jboss-as-7.1.1.Final/standalone/deployments
10:53:19,940 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found test.war in deployment directory. To trigger deployment create a file called test.war.dodeploy
10:53:20,275 INFO [org.jboss.as.server.deployment] (MSC service thread 1-10) JBAS015876: Starting deployment of "test.war"
10:53:21,056 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-18) MSC00001: Failed to start service jboss.deployment.unit."test.war".INSTALL: org.jboss.msc.service.StartException in service jboss.deployment.unit."test.war".INSTALL: Failed to process phase INSTALL of deployment "test.war"
at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:119) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_22]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_22]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_22]
Caused by: java.lang.IllegalArgumentException: JBAS011043: Circular dependency installing java:module/env/jdbc/mainPoolNoTx
at org.jboss.as.ee.component.deployers.ModuleJndiBindingProcessor.addJndiBinding(ModuleJndiBindingProcessor.java:239)
at org.jboss.as.ee.component.deployers.ModuleJndiBindingProcessor.deploy(ModuleJndiBindingProcessor.java:118)
at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:113) [jboss-as-server-7.1.1.Final.jar:7.1.1.Final]
... 5 more
10:53:21,081 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015870: Deploy of deployment "test.war" was rolled back with failure message {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"test.war\".INSTALL" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"test.war\".INSTALL: Failed to process phase INSTALL of deployment \"test.war\""}}
10:53:21,110 INFO [org.jboss.as.server.deployment] (MSC service thread 1-19) JBAS015877: Stopped deployment test.war in 29ms
10:53:21,115 INFO [org.jboss.as.controller] (DeploymentScanner-threads - 2) JBAS014774: Service status report
JBAS014777: Services which failed to start: service jboss.deployment.unit."test.war".INSTALL: org.jboss.msc.service.StartException in service jboss.deployment.unit."test.war".INSTALL: Failed to process phase INSTALL of deployment "test.war"
10:53:21,121 ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"test.war\".INSTALL" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"test.war\".INSTALL: Failed to process phase INSTALL of deployment \"test.war\""}}}}
10:54:09,729 INFO [org.jboss.as.logging] JBAS011503: Restored bootstrap log handlers
10:54:09,740 INFO [org.jboss.as.connector.subsystems.datasources] JBAS010409: Unbound data source [java:jboss/datasources/ExampleDS]
10:54:09,775 INFO [com.arjuna.ats.jbossatx] ARJUNA032018: Destroying TransactionManagerService
10:54:09,777 INFO [com.arjuna.ats.jbossatx] ARJUNA032014: Stopping transaction recovery manager
10:54:09,787 INFO [org.jboss.as] JBAS015950: JBoss AS 7.1.1.Final "Brontes" stopped in 37ms
Here are the relevant (I think) XML files/snippets.
standalone.xml:
| <subsystem xmlns="urn:jboss:domain:datasources:1.0"> |
| <datasources> |
| <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="tr |
ue">
| <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url> |
| <driver>h2</driver> |
| <security> |
| <user-name>sa</user-name> |
| <password>sa</password> |
| </security> |
| </datasource> |
| <drivers> |
| <driver name="mysql-module" module="com.mysql"/> |
| <driver name="h2" module="com.h2database.h2"> |
| <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class> |
| </driver> |
| </drivers> |
| </datasources> |
| </subsystem> |
web.xml:
| <!-- Resource refs for database connections. --> |
| <resource-ref> |
| <description>Main Non-Tx DB Connection</description> |
| <res-ref-name>jdbc/mainPoolNoTx</res-ref-name> |
| <res-type>javax.sql.DataSource</res-type> |
| <res-auth>Container</res-auth> |
| </resource-ref> |
| <resource-ref> |
| <description>Main Tx DB Connection</description> |
| <res-ref-name>jdbc/mainPoolTx</res-ref-name> |
| <res-type>javax.sql.DataSource</res-type> |
| <res-auth>Container</res-auth> |
| </resource-ref> |
jboss-web.xml:
<jboss-web>
<resource-ref>
<res-ref-name>jdbc/mainPoolTx</res-ref-name> <!-- Logical name only. -->
<jndi-name>java:comp/env/jdbc/mainPoolTx</jndi-name> <!-- Real JNDI name. -->
</resource-ref>
<resource-ref>
<res-ref-name>jdbc/mainPoolNoTx</res-ref-name>
<jndi-name>java:comp/env/jdbc/mainPoolNoTx</jndi-name>
</resource-ref>
</jboss-web>
mysql-jboss7-ds.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: mysql-ds.xml,v 1.3.2.1 2004/12/01 11:46:00 schrouf Exp $ -->
<!-- A few simple datasource definitions in JBoss 7(.1.1-Final) format. -->
<datasources xmlns="http://www.jboss.org/ironjacamar/schema">
<!-- A non-transaction-safe data source. -->
<datasource
jndi-name="java:comp/env/jdbc/mainPoolNoTx"
pool-name="mainPoolNoTx">
<driver>mysql-module</driver>
<connection-url>jdbc:mysql://server.com</connection-url>
<security> <user-name>foo</user-name> <password>bar</password> </security>
<transaction-isolation>TRANSACTION_NONE</transaction-isolation> <!-- See http://docs.oracle.com/javase/6/docs/api/java/sql/Connection.html#field_detail -->
</datasource>
<!-- A transaction-safe data source. -->
<datasource
jndi-name="java:comp/env/jdbc/mainPoolTx"
pool-name="mainPoolTx">
<driver>mysql-module</driver>
<connection-url>jdbc:mysql://server.com<connection-url>
<security> <user-name>foo</user-name> <password>bar</password> </security>
<transaction-isolation>TRANSACTION_SERIALIZABLE</transaction-isolation> <!-- See http://docs.oracle.com/javase/6/docs/api/java/sql/Connection.html#field_detail -->
</datasource>
</datasources>
I can attach other files (logs, etc) if desired. Just let me know.