2 Replies Latest reply on Apr 1, 2002 7:03 PM by Harry LeBlanc

    Problem setting an Oracle Pool

    Atif Umar Newbie

      hi all ,
      i guess this is not a big problem but i am unable to solve it on my own
      i am setting up an oracle pool FOR Jboss 2.4.0
      I have followed the instruction given on the docs at

      http://jboss.org/documentation/HTML/ch04s09.html

      and the changes that i have made in jboss.jcml are


      oracle.jdbc.driver.OracleDriver



      OracleDB
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:oracle:thin:@172.24.6.57:1521:bvdata
      wlcs
      wlcs



      i have lso made the other two changes ie adding classes12.zip in li/ext and adding that line in jboss.properties

      but when i start jboss i get these messages regarding the oraclepool

      [Configuration] Drivers set to oracle.jdbc.driver.OracleDriver in DefaultDomain:service=JdbcProvider
      [Configuration] PoolName set to OracleDB in DefaultDomain:service=XADataSource,name=OracleDB
      [Configuration] DataSourceClass set to org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl in DefaultDomain:service=XADataSource,name=OracleDB
      [Configuration] URL set to jdbc:oracle:thin:@172.24.6.57:1521:bvdata in DefaultDomain:service=XADataSource,name=OracleDB
      [Configuration] JDBCUser set to wlcs in DefaultDomain:service=XADataSource,name=OracleDB
      [Configuration] Password set to wlcs in DefaultDomain:service=XADataSource,name=OracleDB

      and

      [JdbcProvider] Starting
      [JdbcProvider] Started
      [XADataSourceLoader] Starting
      [OracleDB] XA Connection pool OracleDB bound to java:/OracleDB
      [XADataSourceLoader] Stopped
      java.lang.NullPointerException
      at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:178)
      at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:407)
      at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
      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:836)
      at $Proxy0.start(Unknown Source)
      at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
      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:210)
      at org.jboss.Main$1.run(Main.java:116)
      at java.security.AccessController.doPrivileged(Native Method)
      at org.jboss.Main.main(Main.java:112)
      [Configuration] java.lang.NullPointerException
      [Configuration] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:178)
      [Configuration] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:407)
      [Configuration] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
      [Configuration] at java.lang.reflect.Method.invoke(Native Method)
      [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      [Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
      [Configuration] at $Proxy0.start(Unknown Source)
      [Configuration] at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
      [Configuration] at java.lang.reflect.Method.invoke(Native Method)
      [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
      [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
      [Configuration] at org.jboss.Main.(Main.java:210)
      [Configuration] at org.jboss.Main$1.run(Main.java:116)
      [Configuration] at java.security.AccessController.doPrivileged(Native Method)
      [Configuration] at org.jboss.Main.main(Main.java:112)

      i am unable to make out anything of this please hepl me out
      thanks in advance
      Atif

        • 1. Re: Problem setting an Oracle Pool
          Atif Umar Newbie

          hi ,
          its me again i wanted to add something
          in the documentation its the name of the datsource class is given as

          org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl

          but when i put this then i get the error

          java.lang.ClassNotFoundException: org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl
          at javax.management.loading.MLet.findClass(MLet.java:800)
          at java.lang.ClassLoader.loadClass(ClassLoader.java:297)
          at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
          at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
          at java.lang.Class.forName0(Native Method)
          at java.lang.Class.forName(Class.java:120)
          at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:344)
          at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
          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:836)
          at $Proxy0.start(Unknown Source)
          at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
          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:210)
          at org.jboss.Main$1.run(Main.java:116)
          at java.security.AccessController.doPrivileged(Native Method)
          at org.jboss.Main.main(Main.java:112)
          [Configuration] java.lang.ClassNotFoundException: org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl
          [Configuration] at javax.management.loading.MLet.findClass(MLet.java:800)
          [Configuration] at java.lang.ClassLoader.loadClass(ClassLoader.java:297)
          [Configuration] at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
          [Configuration] at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
          [Configuration] at java.lang.Class.forName0(Native Method)
          [Configuration] at java.lang.Class.forName(Class.java:120)
          [Configuration] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:344)
          [Configuration] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
          [Configuration] at java.lang.reflect.Method.invoke(Native Method)
          [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
          [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
          [Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
          [Configuration] at $Proxy0.start(Unknown Source)
          [Configuration] at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
          [Configuration] at java.lang.reflect.Method.invoke(Native Method)
          [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
          [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
          [Configuration] at org.jboss.Main.(Main.java:210)
          [Configuration] at org.jboss.Main$1.run(Main.java:116)
          [Configuration] at java.security.AccessController.doPrivileged(Native Method)
          [Configuration] at org.jboss.Main.main(Main.java:11

          so instead i have used the datasourceclass as

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

          and on using this class i am getting the error mentioned in my previous post

          do i have to add same datasourceclass as mentioned in the docs , if yes then where do i finde the jar as its not there in the jboss2.4.0 zip

          thanks

          Atif

          • 2. Re: Problem setting an Oracle Pool
            Harry LeBlanc Newbie

            I too have the same problem. Here's the relevant portion of my jboss.jcml:

            TestDB
            org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
            jdbc:oracle:thin:@localhost:1521:TestDB
            DEKWEB
            DEKBRANDS


            I'm running Oracle 8.1.7 on Redhat Linux 7.1, with the latest Oracle driver (classes12.zip).
            It really shouldn't be this hard to get jboss talking to oracle. I must be missing something really obvious, but it looks good to me. The oracle classes12.zip is in the classpath.
            Thanks!
            Harry