Java – How to have multiple datasources with the same JNDI name in JBoss

databasejavajbossjndi

So, I have a situation where I will be deploying multiple ear files, each of which I need to configure with a different database (potentially).

Right now I have a *-ds.xml file that is deployed in JBoss, with a JNDI name that all my portlets and servlets use to look up the database connection. If I deploy more than one ear file with a *-ds.xml file that points to a different database, but with the same JNDI name, the deployment barfs. Shouldn't JNDI be more modular to prevent naming collision when deploying different application to isolate them.

It will take quite some time to change my lookup in the code, so is there a way to deploy that will work? The only other idea I had would be to set a JNDI property as the value for the datasource name to look up, and then look up that JNDI property first and retrieve the datasource based on the retrieved "key." This seems kind of hackish to me…

Best Answer

You can have the different data source defined on the application server with different name (on the server namespace) and then map it to a resource-ref name (this time component namespace, so each application can have its own one) via the deployment xml file.

For JBoss prior as7: https://community.jboss.org/wiki/HowDoICreateAResourceRef for as7: https://community.jboss.org/message/629666

Related Solutions

JNDI Name binding in JBOSS 5.1.0 Beta

I fixed the problem after searching. I had to add namespace information to my ejb-jar.xml file.

I changed it from:

<ejb-jar> 
    <enterprise-beans>
    </enterprise-beans> 
</ejb-jar>

to:

   1. <?xml version="1.0" encoding="UTF-8"?>  
   2. <ejb-jar version="3.0"   
   3.     xmlns="http://java.sun.com/xml/ns/javaee"  
   4.     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"   
   5.     xsi:schemaLocation="http://java.sun.com/xml/ns/javaee   
   6.     http://java.sun.com/xml/ns/javaee/ejb-jar_3_0.xsd">  
   7. </ejb-jar>

I found the answer here: http://www.jboss.org/index.html?module=bb&op=viewtopic&t=157022

Java – Spring, configure the DataSource through JNDI having remote JBoss Server

I have made few changes and Its now working fine.

A JNDI Template must be initialized with the JNP properties. And URL to JBoss server has to be in that properties.

configContext.xml

<bean id="wcJndiTemplate" class="org.springframework.jndi.JndiTemplate">
    <property name="environment">
        <props>
            <prop key="java.naming.factory.initial">org.jnp.interfaces.NamingContextFactory</prop>
            <prop key="java.naming.provider.url">jnp://jndi.myURL.me:1099</prop>
            <prop key="java.naming.factory.url.pkgs">org.jboss.naming:org.jnp.interfaces</prop>
            <prop key="jnp.disableDiscovery">true</prop>
        </props>
    </property>
</bean>

<bean id="wcDataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
    <property name="jndiName" value="jdbc/wc-mysql"/>
    <property name="resourceRef" value="false"/>
    <property name="jndiTemplate" ref="wcJndiTemplate" />
</bean>

But after doing that changes I was facing an exception

java.lang.ClassNotFoundException: org.jnp.interfaces.NamingContextFactory

So I found a link mentioning to include a dependency of jbossall-client.jar in the POM to resolve the issue. So the pom changes are

<dependency>
    <groupId>jboss</groupId>
    <artifactId>jbossall-client</artifactId>
    <version>4.2.2.GA</version>
</dependency>

Every thing seems to be working fine.

Thanks.

Best Answer

Related Solutions

JNDI Name binding in JBOSS 5.1.0 Beta

Java – Spring, configure the DataSource through JNDI having remote JBoss Server

Related Topic