Problem Oracle Data Source Configuration, --- Urgent Pls hel
Hi All,
my Oracle-ds.xml file configuration is as follows
<?xml version="1.0" encoding="UTF-8"?>
<local-tx-datasource>
<jndi-name>PROM</jndi-name>
<connection-url>jdbc:oracle:thin:@3.209.121.46:1521:FMM</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>fmm</user-name>
fmm
<idle-timeout-minutes>15</idle-timeout-minutes>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
And I kept Classes12.zip ../default/deploy/lib.
to get the database connection following is my code.
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:PROM");
conn = ds.getConnection();
When i am starting the server i am getting following error. in console
05/02/21;20:31:21;496; DEBUG; ) - internalRegisterPool: registering pool with interval 900000 old interval: 9223372036854775807
05/02/21;20:31:21;496; DEBUG; ) - internalRegisterPool: about to notify thread: old next: 1108998531496, new next: 1108998531496
05/02/21;20:31:21;496; DEBUG; ) - Using properties: {user=fmm, password=--hidden--}
05/02/21;20:31:21;496; DEBUG; ) - Checking driver for URL: jdbc:oracle:thin:@3.209.121.46:1521:FMM
05/02/21;20:31:21;496; DEBUG; ) - Driver not yet registered for url: jdbc:oracle:thin:@3.209.121.46:1521:FMM
05/02/21;20:31:21;512; DEBUG; ) - Driver already registered for url: jdbc:oracle:thin:@3.209.121.46:1521:FMM05/02/21;20:31:21;730; WARN ; ) - Throwable while attempting to get a new connection: null
05/02/21;20:31:21;730; DEBUG; ) - org.jboss.util.NestedThrowable.parentTraceEnabled=true
05/02/21;20:31:21;730; DEBUG; ) - org.jboss.util.NestedThrowable.nestedTraceEnabled=false
05/02/21;20:31:21;730; DEBUG; ) - org.jboss.util.NestedThrowable.detectDuplicateNesting=true
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))))
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:161)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:508)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:207)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:534)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:396)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:299)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:448)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:838)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
Pls help me in this regard
Regards
Karunakar
