JNDI Datasource Lookup in MDB Returning wrong Datasource

[m2et6n]

I am running JBoss 4.0.3 SP1 and I am having problems with the implementation of a message-driven bean.

I have the following data source entry in my application-ds.xml file:

<local-tx-datasource>
 <jndi-name>TAP_DATASOURCE</jndi-name>
 <connection-url>jdbc:oracle:thin:@cncux42:1522:dev1</connection-url>
 <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
 <user-name>tap</user-name>
 <password>tap_dev1</password>
</local-tx-datasource>

I am deploying the application as an EAR file containing the WAR and EJB jar files. Code running within the WAR web application has no problems performing the lookup and returning the correct datasource.

Code executed from within the Message-Driven bean however will not return the TAP_DATASOURCE datasource, but instead returns the DefaultDS, which is mapped to a hypersonic datasource that is loaded.

The code performing the lookup is as follows:

Object rc = initCtx.lookup( "java:/comp/env/" );
Context envCtx = (Context)rc;
rc = envCtx.lookup( "jdbc/TAP_DATASOURCE" );

For the WAR, my web.xml contains:

<resource-ref>
 <res-ref-name>jdbc/TAP_DATASOURCE</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>

<resource-ref>
 <res-ref-name>jdbc/DATATRON_DATASOURCE</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>

and my jboss-web.xml contains:

<resource-ref>
 <res-ref-name>jdbc/TAP_DATASOURCE</res-ref-name>
 <jndi-name>java:/TAP_DATASOURCE</jndi-name>
</resource-ref>

<resource-ref>
 <res-ref-name>jdbc/DATATRON_DATASOURCE</res-ref-name>
 <jndi-name>java:/DATATRON_DATASOURCE</jndi-name>
</resource-ref>

My ejb-jar.xml file for the MDB EJB jar file contains the following within the <message-driven> tag:

<resource-ref>
 <res-ref-name>jdbc/TAP</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
</resource-ref>

As for the jboss.xml for the MDB EJB jar file, I have tried a couple of configurations based on different things I have found on Google, but I get
the same results in each case.

The latest attempt I used the following in the <message-driven> tag:

<resource-ref>
 <res-ref-name>jdbc/TAP</res-ref-name>
 <jndi-name>TAP</jndi-name>
</resource-ref>

[bill.burke]

And this is an EJB3 question?

If so, use

<resource-ref>
...
<mapped-name>java:/TAP_DATASOURCE</mapped-name>

[m2et6n]

Got it working! Thanks.

Could you possibly clarify one last thing for me? It seems straightforward from what I've read, but I seem to be having some trouble with the proper classes being loaded from code in my MDB.

I initially added a JAR file to my EAR and listed it as a Java module in the application.xml file, along with the EJB module for the MDB, but it didn't seem to be recognizing it, so I had to place it in my EJB.JAR file.

What is the recommended method for packaging classes that the MDB requires?

Thanks again!

[m2et6n]

To verify, I can put the JAR files into the server / SERVERNAME / lib / folder and everything works, but I would prefer to deploy the JARS with the EAR file.