[jboss-user] [Datasource Configuration] - Getting error in connecting with Oracle database

Prasanna Sinha [http://community.jboss.org/people/pksinha] created the discussion "Getting error in connecting with Oracle database" To view the discussion, visit: http://community.jboss.org/message/623741#623741 -------------------------------------------------------------- Hi 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 -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/623741#623741] Start a new discussion in Datasource Configuration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]