Problem in Configuring JBoss Application Servers for Oracle
akshay_johari Jul 11, 2009 4:31 PMHi,
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)