Getting error in connecting with Oracle database
pksinha Aug 30, 2011 8:21 AMHi All
I am working on ATG project and I need to connect with oracle database which is in remote server. I am able to ping and able to connect using sqldeveloper, but while running run.bat I am getting following error:
I am using Jdk1.6 and jboss-eap 4.3.
ORA-12519, TNS:no appropriate service handler found
)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:584)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:531)
at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:74)
at java.lang.Thread.run(Thread.java:662)
The content of ds file that I am using is as follows:
<datasources>
<no-tx-datasource>
<jndi-name>atgcore_ds</jndi-name>
<connection-url>jdbc:oracle:thin:@10.6.16.127:1521:CWKDBS</connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<user-name>chadwicks_core_sap</user-name>
<password>admin</password>
<min-pool-size>30</min-pool-size>
<max-pool-size>250</max-pool-size>
</no-tx-datasource>
<no-tx-datasource>
<jndi-name>atgcataloga_ds</jndi-name>
<connection-url>jdbc:oracle:thin:@10.6.16.127:1521:CWKDBS</connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<user-name>chadwicks_cata_sap</user-name>
<password>admin</password>
<min-pool-size>10</min-pool-size>
<max-pool-size>100</max-pool-size>
</no-tx-datasource>
<no-tx-datasource>
<jndi-name>atgcatalogb_ds</jndi-name>
<connection-url>jdbc:oracle:thin:@10.6.16.127:1521:CWKDBS</connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<user-name>chadwicks_catb_sap</user-name>
<password>admin</password>
<min-pool-size>10</min-pool-size>
<max-pool-size>100</max-pool-size>
</no-tx-datasource>
</datasources>
Please help me to resolve this issue.
Thanks
Prasanna