1 Reply Latest reply on Feb 25, 2005 1:18 PM by Adrian Brock

    Problem Oracle Data Source Configuration, --- Urgent Pls hel

    Karunakar reddy Newbie

      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:FMM
      05/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