[jboss-user] [Datasource Configuration] - 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)
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4243089#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...