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

[raja021084]

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

[raja021084]

Can anyone help me??urgent

[peterj]

Where are you doing the lookup? In a stand-alone client or in an app deployed to JBoss AS?

For an app deployed to JBoss AS, the lookup should be:

ctx.lookup("java:jdbc/ActiveVOS");

[raja021084]

Thank you Johnson.

ctx.lookup("java:jdbc/ActiveVOS");

Is there a way to avoid "java:" from the lookup string? The lookup been done by some third party jar. I dont have access to the source to change it.

It would be great if ctx.lookup("jdbc/ActiveVOS") works.

Any answer??

[peterj]

Adding the following entry to the *-ds.xml file, right after the <jndi-name> entry is fine, will remove the "java:" prefix from the name:

<use-java-contextType>false</use-java-context>