1 Reply Latest reply on Mar 15, 2011 5:15 PM by emmitt518

    Problem in Configuring JBoss Application Servers for Oracle

      Hi,

      I am facing some issue in JBoss 5.1.0.GA. I have more than two application nodes on it. Database is Oracle10gR2 in RAC Cluster. While starting the ear, I got the message "The network adapter could not establish the connection". Following is the RAC Cluster URL in Test-ds.xml


      JDBC:ORACLE:THIN:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=RC1-VIR)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=RC2-VIR)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MYRAC)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES = 180)(DELAY = 5))))


      If I remove the RAC Cluster String and connect with individual RAC, then I got no error but with the above string, it gives error. start the ear I have searched a lot but haven't found the reason. Can you please help in solving this. Thanks in advance

      Following is the error coming :



      16:16:45,920 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:225)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:195)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:633)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:267)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:679)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:381)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
      at com.niit.cliks.control.ejb.CmDBUtility.getCon(CmDBUtility.java:96)
      at com.niit.cliks.control.ejb.CmDBUtility.getConnection(CmDBUtility.java:119)
      at com.niit.cliks.control.ejb.CmAncestorBean.getConnection(CmAncestorBean.java:67)
      at com.niit.cliks.control.ejb.CmAncestorBean.makeDAO(CmAncestorBean.java:94)
      at com.niit.cliks.control.ejb.uz_e003EJB.retrieve(uz_e003EJB.java:109)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.jboss.invocation.Invocation.performCall(Invocation.java:386)
      at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:228)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:156)
      at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:173)
      at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)