BlackBox XA with Oracle
Hi all,
I tried to deploy a resource adapter from Sun BlackBoxXA with Oracle Jserver 8.1.7 and Jboss 2.4.4 but I’ve got a error when I started the server. Below, you will find part of my jboss.jcml, ra.xml from BlackBoxXA, and the error I've got. According, to the trace, the URL is not valid. It is strange because I use the same url for BlackboxTx and it works fine.But for BlackBoxXa, I’m really stuck. I tried to debug the code, it seems the url is not passed to the oracle.jdbc.pool.OracleDataSource.
Thanks
part of jboss.jcml
------------------
BlackBoxXADS
oracle.jdbc.xa.client.OracleXADataSource
jdbc:oracle:thin:@myhost.server.com:1521:CML20
test1
test1
XABlackBoxDS
JCA:service=RARDeployer
Black Box XA Adapter
XADataSourceName=java:/BlackBoxXADS
MinervaXACMFactory
# Pool type - uncomment to force, otherwise it is the default
#PoolConfiguration=per-factory
# Connection pooling properties - see
# org.opentools.minerva.pool.PoolParameters
MinSize=0
MaxSize=10
Blocking=true
GCEnabled=false
IdleTimeoutEnabled=false
InvalidateOnError=false
TrackLastUsed=false
GCIntervalMillis=120000
GCMinIdleMillis=1200000
IdleTimeoutMillis=1800000
MaxIdleTimeoutPercent=1.0
org.jboss.resource.security.ManyToOnePrincipalMapping
userName=test1
password=test1
ra.xml for BlackBoxXA
---------------------
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE connector PUBLIC '-//Sun Microsystems, Inc.//DTD Connector 1.0//EN' 'http://java.sun.com/dtd/connector_1_0.dtd'>
<display-name>BlackBoxXA</display-name>
<vendor-name>Java Software</vendor-name>
<spec-version>1.0</spec-version>
<eis-type>JDBC Database</eis-type>
1.0
<managedconnectionfactory-class>com.sun.connector.blackbox.JdbcManagedConnectionFactory</managedconnectionfactory-class>
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
<connectionfactory-impl-class>com.sun.connector.blackbox.JdbcDataSource</connectionfactory-impl-class>
<connection-interface>java.sql.Connection</connection-interface>
<connection-impl-class>com.sun.connector.blackbox.JdbcConnection</connection-impl-class>
<transaction-support>XATransaction</transaction-support>
<config-property>
<config-property-name>XADataSourceName</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>java:/DefaultDS</config-property-value>
<!-- <config-property-value>java:/MinervaXADS</config-property-value> -->
<!-- <config-property-value>jdbc/XACloudscape__xa</config-property-value> -->
</config-property>
<authentication-mechanism>
<authentication-mechanism-type>BasicPassword</authentication-mechanism-type>
<credential-interface>javax.resource.security.PasswordCredential</credential-interface>
</authentication-mechanism>
<reauthentication-support>false</reauthentication-support>
Error at start up
-----------------
[INFO,RARDeployer] Starting
[INFO,RARDeployer] Started
[INFO,MinervaNoTransCMFactory] Starting
[INFO,MinervaNoTransCMFactory] Connection manager factory 'MinervaNoTransCMFactory bound to 'java:/MinervaNoTransCMFacto
ry'
[INFO,MinervaNoTransCMFactory] Started
[INFO,MinervaSharedLocalCMFactory] Starting
[INFO,MinervaSharedLocalCMFactory] Connection manager factory 'MinervaSharedLocalCMFactory bound to 'java:/MinervaShared
LocalCMFactory'
[INFO,MinervaSharedLocalCMFactory] Started
[INFO,MinervaXACMFactory] Starting
[INFO,MinervaXACMFactory] Connection manager factory 'MinervaXACMFactory bound to 'java:/MinervaXACMFactory'
[INFO,MinervaXACMFactory] Started
[INFO,MinervaDS] Starting
[INFO,MinervaDS] Started
[INFO,BlackBoxXADS] Starting
[ERROR,BlackBoxXADS] Stopped
java.sql.SQLException: Invalid Oracle URL specified: OracleDataSource.makeURL
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:905)
at oracle.jdbc.pool.OracleDataSource.makeURL(OracleDataSource.java:422)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:105)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:88)
at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:68)
at org.jboss.jdbc.RawXADataSourceLoader.startService(RawXADataSourceLoader.java:170)
at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:967)
at $Proxy0.start(Unknown Source)
at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at org.jboss.Main.(Main.java:208)
at org.jboss.Main$1.run(Main.java:110)
at java.security.AccessController.doPrivileged(Native Method)
at org.jboss.Main.main(Main.java:106)
[ERROR,ConfigurationService] Unexpected error