4 Replies Latest reply on May 4, 2010 1:46 PM by Peter Johnson

    JBoss 5.1 : JNDI lookup on Local Tx Datasource is not working

    raja murugesan Newbie

      Hi All,

       

      This is the content of *-ds.xml

      <datasources>
        <local-tx-datasource>
          <jndi-name>jdbc/ActiveVOS</jndi-name>
          <connection-url>jdbc:oracle:thin:@10.113.114.193:1521:orc11g</connection-url>
          <driver-class>oracle.jdbc.OracleDriver</driver-class>
          <user-name>raja_vector</user-name>
          <password>raja_vector</password>
          <min-pool-size/>
          <max-pool-size/>
          <idle-timeout-minutes/>
        </local-tx-datasource>
      </datasources>

       

      When i do lookup using the JNDI name "jdbc/ActiveVOS" getting the below exception.

      ctx = new InitialContext(table);
      ctx.lookup("jdbc/ActiveVOS");

       

       

      Caused by: org.jboss.util.NestedSQLException: Unable to get managed connection for jdbc/ActiveVOS; - nested throwable: (javax.resource.ResourceException: Unable to get m
      aged connection for jdbc/ActiveVOS)
              at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
              at org.activebpel.rt.bpel.server.engine.storage.sql.AeDelegatingDataSource.getConnection(AeDelegatingDataSource.java:40)
              at org.activebpel.rt.bpel.server.engine.storage.sql.AeMonitoredDataSource.getConnection(AeMonitoredDataSource.java:41)
              at org.activebpel.rt.bpel.server.engine.storage.sql.AeDataSource.getNewConnection(AeDataSource.java:132)
              at org.activebpel.rt.bpel.server.engine.storage.sql.AeDataSource.getConnection(AeDataSource.java:311)
              at org.activebpel.rt.bpel.server.engine.storage.sql.AeJNDIDataSource.getConnection(AeJNDIDataSource.java:122)
              at org.activebpel.rt.bpel.server.engine.storage.sql.AeSQLObject.getConnection(AeSQLObject.java:40)
              ... 94 more
      Caused by: javax.resource.ResourceException: Unable to get managed connection for jdbc/ActiveVOS
              at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
              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)
              ... 100 more

       

       

      Could anyone please help me to get out of this.

       

      Thanks & Regards

      Raja