1 Reply Latest reply on Oct 19, 2001 12:17 AM by Jay Walters

    OracleJDBC DataSource error

    Le Ngoc Lam Newbie

      I do with JBoss-2.4.1a_Tomcat-3.2.3.I tried to mapp Oracle DataSource by change on <Jboss-home>/config/default and <Jboss-home>/config/tomcat file jboss.jcml:


      org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,oracle.jdbc.driver.OracleDriver



      and


      OracleDB
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl[JBoss 2.4]
      jdbc:oracle:thin:@192.168.20.150:1521:ora8
      news
      news


      in my class path contents classes12.zip, and /lib/ext/has file classes12.zip.But when I using run or run_with_tomcat, it always generates error:

      [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.
      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
      [Configuration] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java
      [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:162
      [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:152
      [Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Confi
      6)
      [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:162
      [Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:152
      [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)


      If I use SQLPlus, it run ok. So if i try a test JDBC connection it will generate errors
      java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

      Anyone suggest?
      Lam