1 Reply Latest reply on Feb 10, 2003 12:01 PM by rstack

    Oracle XA and invalid driver error

    rstack

      Using XaTxConnectionManager and Oracle 8i (8.1.7) I an getting the following error message:

      2003-02-10 10:08:29,415 WARN [org.jboss.system.ServiceController] Problem starting service jboss.j2ee:jndiName=CustomerHomeRemote,service=EJB
      org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (java.sql.SQLException: Unable to get Connection: javax.resource.ResourceException: Unable to create DB XAConnection: java.sql.SQLException: ORA-06401: NETCMN: invalid driver designator)

      This looks like an Oracle error message probally from the JDBC driver in classes12.zip.

      Anyone have an idea what the problem could be?

        • 1. Re: Oracle XA and invalid driver error
          rstack

          I solved the problem. In the oracle-xa-service.xml file, I changed:

          <config-property name="XADataSourceProperties"
          type="java.lang.String">URL=jdbc:oracle:oci8:@localhost:1521:mydatabase</config-property>

          TO:

          <config-property name="XADataSourceProperties"
          type="java.lang.String">URL=jdbc:oracle:thin:@localhost:1521:mydatabase</config-property>

          Everything is working well. I never could get the LocalTxConnectionManager to work. However XA is the way to go.