[jboss-user] [Datasource Configuration] - Problem in Configuring JBoss Application Servers for Oracle

[akshay_johari]

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)


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4243089#4243089

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4243089