0 Replies Latest reply on Jun 28, 2002 1:05 AM by shikha

    Database pool connection producing an error

    shikha Newbie

      Hi,
      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