1 Reply Latest reply on Jun 28, 2002 2:46 AM by Alexandre Nichet

    BlackBox XA with Oracle

    Alexandre Nichet Newbie

      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

        • 1. Re: BlackBox XA with Oracle
          Alexandre Nichet Newbie

          Hi all,

          I finally found the right configuration after tracing the code. I provide it, just in case somebody need it.

          jboss.jcml
          ----------

          BlackBoxXADS

          oracle.jdbc.xa.client.OracleXADataSource


          URL=jdbc:oracle:thin:@myhost.domain.com:1521:CML20
          User=test1
          Password=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:/BlackBoxXADS</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>