JBoss-2.4.5RC1 + Multiple Data Sources

[jkramer]

Hi,

I Have several EJB applications I would like to simultaneously deploy in a single instance of JBoss. The problem I am experiencing is I cannot designate a separate data source for each application, meaning at best JBoss creates all the tables for all the applications in a single database or at worst one or more applications fail to load (specifically when more than one application uses the same name for an entity or session bean.) I would like to know if it is possible to create another JDBC connection in the jboss.jcml file and name it something other than DefaultDS, and have that referenced elsewhere as being specific to a particular application?

Thanks and Cheers,
~Jakob Kramer

[earlgrey]

> same name for an entity or session bean.) I would
> like to know if it is possible to create another JDBC
> connection in the jboss.jcml file and name it
> something other than DefaultDS, and have that
> referenced elsewhere as being specific to a
> particular application?

yes, this is possible: you create multiple datasource configurations in jboss.jcml, thus the ejb can look them up via their specific names.

lars

[cisbrh]

Just create as many datasource as you need. Then in your jaws.xml you can specify for each EJb what datasource to use.
Benjamin

[jkramer]

Do you have a code snippet for an example?