How to configure mulitple datasource files on JBoss 4.3 application server ?

[Anoop Nair]

Hi All,

I am using JBoss-eap-4.3.0.GA_CP06.

I have multiple applications deployed in the same instance of Jboss server. Each application connects to a different database.
I want to have separate datasource file for the each application.

Is this possible ? If yes, then where do I configure it.

[uttam kumar]

For each datasource deploy seperate *-ds.xml file and use the corresponding JNDI in your application to access the datasource.

[Anoop Nair]

I tried putting different data source files with the names *-ds.xml . But the application doesnt work with it.
But when I put all the datasources in a single file it works.

[uttam kumar]

What is the error that you are getting? Please post all the *-ds.xml files along with their contents.

[Anoop Nair]

I am getting the below error when server starts up

javax.naming.NameNotFoundException: APP2_DS not bound
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3854)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4348)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:732)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:297)
at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.apache.catalina.core.StandardContext.init(StandardContext.java:5263)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)

Below are my DS files:
DS1

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
   <local-tx-datasource>
      <jndi-name>APP1_DS</jndi-name>
	  <use-java-context>true</use-java-context>
      <connection-url>jdbc:oracle:thin:@IP:PORT:SID</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>myapp_user</user-name>
      <password>myapp_pwd</password>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>20</max-pool-size>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      <track-statements/>
	  <security-domain xsi:type="securityMetaData" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
      <prepared-statement-cache-size>32</prepared-statement-cache-size>
      <metadata>
         <type-mapping>Oracle10g</type-mapping>
      </metadata>
      <depends>jboss:service=Hypersonic,database=localDB</depends>
   </local-tx-datasource>   
</datasources>

DS2

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
   <local-tx-datasource>
      <jndi-name>APP2_DS</jndi-name>
	  <use-java-context>true</use-java-context>
      <connection-url>jdbc:oracle:thin:@IP:PORT:SID</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>myapp_user</user-name>
      <password>myapp_pwd</password>
      <min-pool-size>5</min-pool-size>
      <max-pool-size>20</max-pool-size>
      <idle-timeout-minutes>15</idle-timeout-minutes>
      <track-statements/>
	  <security-domain xsi:type="securityMetaData" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
      <prepared-statement-cache-size>32</prepared-statement-cache-size>
      <metadata>
         <type-mapping>Oracle10g</type-mapping>
      </metadata>
      <depends>jboss:service=Hypersonic,database=localDB</depends>
   </local-tx-datasource>   
</datasources>

But if i put both in a single file it works fine.

[uttam kumar]

<depends>jboss:service=Hypersonic,database=localDB</depends>

I dont think its necessary.

Moreover, you can have multiple <local-tx-datasource> mapped to different JNDIs in a single *-ds.xml file. Since you are using Oracle database, you can name the file as oracle-ds.xml and put both the datasources in the same file. It will not affect anything.

[Anoop Nair]

Anoop Nair wrote:I tried putting different data source files with the names *-ds.xml . But the application doesnt work with it.
But when I put all the datasources in a single file it works.

Thats what I am doing currently. Both applications are being developed by different teams and are deployed in different directories. So the requirement is that the datasource file should be present alongwith the application deployed (each in its own directory).

[my myjob]

Hi I am meeting the same problem now, did you get any solutions on this issue?

[William P O'Sullivan]

What does the URLs element look like in jboss-service.xml?

      <attribute name="URLs">
         deploy/,datasources/
      </attribute>

In this case all our xxx-ds.xml definitions are in the datasources folder.

If you want multiple folders, then add them to the URLs attribute.

WP

[Peter Johnson]

"my myjob", please see you private messages regarding an important administrative matter.

[Siitesh Hind]

security-domain xsi:type="securityMetaData" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
depends jboss:service=Hypersonic,database=localDB </depends

Wondering why do you need these 2 entries.

It works just fine on JBoss 5.1.0 GA.

Rgds,

Seetesh