OracleJDBC DataSource error

[lengoclam]

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

[jwalters]

Is the database on a local or remote machine? If it's local you still need a listener to use thin driver, but you wouldn't for SQL*Plus. If you set up your tnsnames.ora file you can try tnsping to see if the network connectivity is setup right.

Cheers