Database pool connection producing an error
chika Jun 28, 2002 1:05 AMHi,
I'm using JBoss2.4.3.While trying to connect to Oracle 8i ,I'm getting the following exception.Please suggest ,what could be the problem.
[ERROR,Default] oracle.net.TNSAddress.SOException
[ERROR,Default] at oracle.net.TNSAddress.ServiceAlias.initFromNVPair(ServiceAlias.java:70)
[ERROR,Default]
[ERROR,Default] at oracle.net.TNSAddress.ServiceAlias.initFromString(ServiceAlias.java:56)
[ERROR,Default]
[ERROR,Default] at oracle.net.resolver.AddrResolution.resolveAddrTree(AddrResolution.java:29
9)
[ERROR,Default]
[ERROR,Default] at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:
163)
[ERROR,Default]
[ERROR,Default] at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:381)
[ERROR,Default]
[ERROR,Default] at oracle.net.ns.NSProtocol.connect(NSProtocol.java:149)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.ttc7.TTC7Protocol.connect(TTC7Protocol.java:1085)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:179)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:142)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:2
14)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:193)
[ERROR,Default]
[ERROR,Default] at java.sql.DriverManager.getConnection(DriverManager.java:517)
[ERROR,Default]
[ERROR,Default] at java.sql.DriverManager.getConnection(DriverManager.java:177)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown S
ource)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown S
ource)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.XAConnectionFactory.createObject(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.ObjectPool.createNewObject(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.ObjectPool.initialize(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.XAPoolDataSource.initialize(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:40
3)
[ERROR,Default]
[ERROR,Default] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
[ERROR,Default]
[ERROR,Default] at java.lang.reflect.Method.invoke(Native Method)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[ERROR,Default]
[ERROR,Default] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Configur
ationService.java:967)
[ERROR,Default]
[ERROR,Default] at $Proxy0.start(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
[ERROR,Default]
[ERROR,Default] at java.lang.reflect.Method.invoke(Native Method)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[ERROR,Default]
[ERROR,Default] at org.jboss.Main.(Main.java:208)
[ERROR,Default]
[ERROR,Default] at org.jboss.Main$1.run(Main.java:110)
[ERROR,Default]
[ERROR,Default] at java.security.AccessController.doPrivileged(Native Method)
[ERROR,Default]
[ERROR,Default] at org.jboss.Main.main(Main.java:106)
[ERROR,Default]
[ERROR,Default] oracle.net.TNSAddress.SOException
[ERROR,Default] at oracle.net.TNSAddress.ServiceAlias.initFromNVPair(ServiceAlias.java:70)
[ERROR,Default]
[ERROR,Default] at oracle.net.TNSAddress.ServiceAlias.initFromString(ServiceAlias.java:56)
[ERROR,Default]
[ERROR,Default] at oracle.net.resolver.AddrResolution.resolveAddrTree(AddrResolution.java:29
9)
[ERROR,Default]
[ERROR,Default] at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:
163)
[ERROR,Default]
[ERROR,Default] at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:381)
[ERROR,Default]
[ERROR,Default] at oracle.net.ns.NSProtocol.connect(NSProtocol.java:149)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.ttc7.TTC7Protocol.connect(TTC7Protocol.java:1085)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:179)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:142)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:2
14)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:193)
[ERROR,Default]
[ERROR,Default] at java.sql.DriverManager.getConnection(DriverManager.java:517)
[ERROR,Default]
[ERROR,Default] at java.sql.DriverManager.getConnection(DriverManager.java:177)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown S
ource)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown S
ource)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.XAConnectionFactory.createObject(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.ObjectPool.createNewObject(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.ObjectPool.initialize(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.XAPoolDataSource.initialize(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:40
3)
[ERROR,Default]
[ERROR,Default] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
[ERROR,Default]
[ERROR,Default] at java.lang.reflect.Method.invoke(Native Method)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[ERROR,Default]
[ERROR,Default] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Configur
ationService.java:967)
[ERROR,Default]
[ERROR,Default] at $Proxy0.start(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
[ERROR,Default]
[ERROR,Default] at java.lang.reflect.Method.invoke(Native Method)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[ERROR,Default]
[ERROR,Default] at org.jboss.Main.(Main.java:208)
[ERROR,Default]
[ERROR,Default] at org.jboss.Main$1.run(Main.java:110)
[ERROR,Default]
[ERROR,Default] at java.security.AccessController.doPrivileged(Native Method)
[ERROR,Default]
[ERROR,Default] at org.jboss.Main.main(Main.java:106)
[ERROR,Default]
[INFO,oracleDS] XA Connection pool oracleDS bound to java:/oracleDS
[ERROR,Default] oracle.net.TNSAddress.SOException
[ERROR,Default] at oracle.net.TNSAddress.ServiceAlias.initFromNVPair(ServiceAlias.java:70)
[ERROR,Default]
[ERROR,Default] at oracle.net.TNSAddress.ServiceAlias.initFromString(ServiceAlias.java:56)
[ERROR,Default]
[ERROR,Default] at oracle.net.resolver.AddrResolution.resolveAddrTree(AddrResolution.java:29
9)
[ERROR,Default]
[ERROR,Default] at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:
163)
[ERROR,Default]
[ERROR,Default] at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:381)
[ERROR,Default]
[ERROR,Default] at oracle.net.ns.NSProtocol.connect(NSProtocol.java:149)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.ttc7.TTC7Protocol.connect(TTC7Protocol.java:1085)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:179)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:142)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:2
14)
[ERROR,Default]
[ERROR,Default] at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:193)
[ERROR,Default]
[ERROR,Default] at java.sql.DriverManager.getConnection(DriverManager.java:517)
[ERROR,Default]
[ERROR,Default] at java.sql.DriverManager.getConnection(DriverManager.java:177)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown S
ource)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(Unknown S
ource)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.XAConnectionFactory.createObject(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.ObjectPool.createNewObject(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.ObjectPool.getObject(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.ObjectPool.getObject(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:41
2)
[ERROR,Default]
[ERROR,Default] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:103)
[ERROR,Default]
[ERROR,Default] at java.lang.reflect.Method.invoke(Native Method)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[ERROR,Default]
[ERROR,Default] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(Configur
ationService.java:967)
[ERROR,Default]
[ERROR,Default] at $Proxy0.start(Unknown Source)
[ERROR,Default]
[ERROR,Default] at org.jboss.util.ServiceControl.start(ServiceControl.java:79)
[ERROR,Default]
[ERROR,Default] at java.lang.reflect.Method.invoke(Native Method)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[ERROR,Default]
[ERROR,Default] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[ERROR,Default]
[ERROR,Default] at org.jboss.Main.(Main.java:208)
[ERROR,Default]
[ERROR,Default] at org.jboss.Main$1.run(Main.java:110)
[ERROR,Default]
[ERROR,Default] at java.security.AccessController.doPrivileged(Native Method)
[ERROR,Default]
[ERROR,Default] at org.jboss.Main.main(Main.java:106)
Rgds,
Parul