XA Datasource -- apparently can't find driver
matt.drees May 23, 2011 11:54 AMHi all,
I'm trying to evaluate if my project (currently targeting AS6) can be switched over to AS7. So I'll probably be posting more of these questions as I try to adapt the project.
I'm trying to set up an XA Oracle datasource. I've set up a "com.oracle.ojdbc" module containing the oracle driver, and am trying to use it in my DS config. The log output (below) makes me think the driver is being discovered and registered correctly. However, the log output also seems to indicate that the datasource can't find the driver.
Relevant standalone.xml snippet:
<subsystem xmlns="urn:jboss:domain:datasources:1.0"> <datasources> <xa-datasource jndi-name="java:jdbc/primaryCcpDatasource" pool-name="primaryCcpDatasourcePool" enabled="true" use-java-context="true"> <xa-datasource-property name="URL"> jdbc:oracle:thin:@ (DESCRIPTION = ...boring... ) </xa-datasource-property> <xa-datasource-property name="User"> ccp </xa-datasource-property> <xa-datasource-property name="Password"> password </xa-datasource-property> <xa-datasource-class> oracle.jdbc.xa.client.OracleXADataSource </xa-datasource-class> <driver> oracle.jdbc.OracleDriver#11.2 </driver> <xa-pool> <min-pool-size> 1 </min-pool-size> <max-pool-size> 5 </max-pool-size> <prefill> true </prefill> <use-strict-min> false </use-strict-min> <is-same-rm-override> false </is-same-rm-override> <no-tx-separate-pools/> <pad-xid> false </pad-xid> <wrap-xa-resource> false </wrap-xa-resource> </xa-pool> <validation> <validate-on-match> false </validate-on-match> <background-validation> true </background-validation> <useFastFail> false </useFastFail> </validation> </xa-datasource> <drivers> <driver name="oracle" module="com.oracle.ojdbc6"> <xa-datasource-class> oracle.jdbc.xa.client.OracleXADataSource </xa-datasource-class> </driver> <driver name="h2" module="com.h2database.h2"> <xa-datasource-class> org.h2.jdbcx.JdbcDataSource </xa-datasource-class> </driver> </drivers> </datasources> </subsystem>
My oracle jdbc driver module looks like this:
matt-dreess-macbook-pro:jboss-7.0.0.Beta4-SNAPSHOT mattdrees$ find modules/com/oracle/ojdbc6 modules/com/oracle/ojdbc6 modules/com/oracle/ojdbc6/main modules/com/oracle/ojdbc6/main/module.xml modules/com/oracle/ojdbc6/main/ojdbc6_g-11.2.0.1.0.jar modules/com/oracle/ojdbc6/main/ojdbc6_g-11.2.0.1.0.jar.index matt-dreess-macbook-pro:jboss-7.0.0.Beta4-SNAPSHOT mattdrees$ matt-dreess-macbook-pro:jboss-7.0.0.Beta4-SNAPSHOT mattdrees$ cat modules/com/oracle/ojdbc6/main/module.xml <module xmlns="urn:jboss:module:1.0" name="com.oracle.ojdbc6"> <resources> <resource-root path="ojdbc6_g-11.2.0.1.0.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> </dependencies> </module>
Log output:
matt-dreess-macbook-pro:jboss-7.0.0.Beta4-SNAPSHOT mattdrees$ bin/standalone.sh ========================================================================= JBoss Bootstrap Environment JBOSS_HOME: /Users/mattdrees/Scratch/jboss-7.0.0.Beta4-SNAPSHOT JAVA: /System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home/bin/java JAVA_OPTS: -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 ========================================================================= 11:32:25,483 INFO [org.jboss.modules] JBoss Modules version 1.0.0.CR2 11:32:25,885 INFO [org.jboss.msc] JBoss MSC version 1.0.0.Beta8 11:32:25,951 INFO [org.jboss.as] JBoss AS 7.0.0.Beta4-SNAPSHOT "(TBD)" starting 11:32:27,078 INFO [org.jboss.as.server] Activating core services 11:32:27,283 INFO [org.jboss.as] creating native management service using network interface (default) port (9999) 11:32:27,291 INFO [org.jboss.as] creating http management service using network interface (default) port (9990) securePort (-1) 11:32:27,314 INFO [org.jboss.as.arquillian] Activating Arquillian Subsystem 11:32:27,335 INFO [org.jboss.as.ee] Activating EE subsystem 11:32:27,438 INFO [org.jboss.as.naming] Activating Naming Subsystem 11:32:27,457 INFO [org.jboss.as.clustering.infinispan.subsystem] Activating Infinispan subsystem. 11:32:27,536 INFO [org.jboss.as.security] Activating Security Subsystem 11:32:28,065 INFO [org.jboss.as.connector.subsystems.datasources] Deploying JDBC-compliant driver class oracle.jdbc.OracleDriver (version 11.2) 11:32:28,077 INFO [org.jboss.as.connector.subsystems.datasources] Deploying JDBC-compliant driver class org.h2.Driver (version 1.2) 11:32:28,080 INFO [org.jboss.as.osgi] Activating OSGi Subsystem 11:32:28,599 INFO [org.jboss.as.webservices] Activating WebServices Extension 11:32:28,857 INFO [org.jboss.as.naming] Starting Naming Service 11:32:28,861 INFO [org.jboss.as.logging] Removing bootstrap log handlers 11:32:28,963 INFO [org.jboss.as.jmx.JMXConnectorService] (MSC service thread 1-4) Starting remote JMX connector 11:32:28,986 INFO [org.jboss.remoting] (MSC service thread 1-1) JBoss Remoting version 3.1.0.Beta2 11:32:29,038 WARN [org.jboss.osgi.framework.internal.URLHandlerPlugin] (MSC service thread 1-3) Unable to set the URLStreamHandlerFactory 11:32:29,040 WARN [org.jboss.osgi.framework.internal.URLHandlerPlugin] (MSC service thread 1-3) Unable to set the ContentHandlerFactory 11:32:29,072 INFO [org.apache.coyote.http11.Http11Protocol] (MSC service thread 1-1) Starting Coyote HTTP/1.1 on http--127.0.0.1-8080 11:32:29,248 INFO [org.hornetq.core.server.impl.HornetQServerImpl] (MSC service thread 1-1) live server is starting.. 11:32:29,436 INFO [org.jboss.as.connector] (MSC service thread 1-3) Starting JCA Subsystem (JBoss IronJacamar 1.0.0.Beta6) 11:32:29,583 INFO [org.hornetq.core.remoting.impl.netty.NettyAcceptor] (MSC service thread 1-1) Started Netty Acceptor version 3.2.1.Final-r2319 localhost:5455 for CORE protocol 11:32:29,589 INFO [org.hornetq.core.remoting.impl.netty.NettyAcceptor] (MSC service thread 1-1) Started Netty Acceptor version 3.2.1.Final-r2319 localhost:5445 for CORE protocol 11:32:29,591 INFO [org.hornetq.core.server.impl.HornetQServerImpl] (MSC service thread 1-1) HornetQ Server version 2.1.2.Final (Colmeia, 120) started 11:32:29,726 INFO [org.jboss.as.server] (MSC service thread 1-3) Service status report New missing/unsatisfied dependencies: service jboss.jdbc-driver."oracle.jdbc.OracleDriver#11.2" (missing) required by [service jboss.data-source.java:/java:jdbc/primaryCcpDatasource] 11:32:29,726 ERROR [org.jboss.as] (MSC service thread 1-3) JBoss AS 7.0.0.Beta4-SNAPSHOT "(TBD)" started (with errors) in 4758ms - Started 106 of 163 services (3 services failed or missing dependencies, 54 services are passive or on-demand)
Does my configuration look correct?
Thanks for your time!