2 Replies Latest reply on Jan 4, 2002 1:08 AM by guy_rouillier

    Need help with Oracle connection

    tufmor

      I have seen a lot of listings on this topic but have not yet been able to solve my problem. I would like to connect to a Oracle8i on a linux box from my JBoss on a win2000. I am
      running JBoss-2.4.4 width Tomcat 4.0.1.

      The error message I get is:

      [INFO,OracleDB] Starting
      [INFO,OracleDB] XA Connection pool OracleDB bound to java:/OracleDB
      [ERROR,OracleDB] Stopped
      java.lang.NullPointerException
      at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
      at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
      ...
      at org.jboss.Main.main(Main.java:106)
      [ERROR,ConfigurationService] Unexpected error
      java.lang.NullPointerException
      at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
      at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:412)
      ...
      at org.jboss.Main.main(Main.java:106)

      The configuration I use is this:

      <!-- ========================== jboss.jcml ========================== -->
      <!-- ======= Transactions ========= -->

      300

      <!-- Use this attribute if you need to use a specific Xid implementation
      Like JBoss recommends I have uncommented here -->
      oracle.jdbc.xa.OracleXid


      <!-- ======= JDBC ========= -->

      oracle.jdbc.driver.OracleDriver



      OracleDB

      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl

      jdbc:oracle:thin:@machine_name:1521:database_name
      username
      password


      <!-- ========================== jboss.jcml ========================== -->

      java:/OracleDB
      <type-mapping>Oracle8</type-mapping>
      false

      Could anyone please help me with this problem? Thx, in advance!
      tufmor

        • 1. Re: Need help with Oracle connection
          robspychala

          Try using OracleXADataSource as opposed to XADataSourceImpl (which as far as I know is a wrapper for JDBC drivers which do not have a XADataSource implementation). I verified that it works on Win2000 2.4.4 JBoss. Enclosed is my mbean config for Oracle.


          OracleProductionDB
          oracle.jdbc.xa.client.OracleXADataSource
          jdbc:oracle:thin:@69.69.69.69:1525:NAME
          xxx
          xxx
          2
          0
          300000
          true
          60000
          900000
          true
          true
          false
          true
          false
          1.0


          peas,

          r.S.

          • 2. Re: Need help with Oracle connection
            guy_rouillier

            I use the XADataSourceImpl without any problems. Leave the Oracle Xid commented out.