How to specify DataSource when using multiple datasources..

kevin_duffey Oct 31, 2001 7:39 PM

Hi there,

We are using multiple data sources in our application. We work with a couple of different databases in one location. When using CMP, how do you specify what datasource to use? We want to pull queries using CMP from one datasource, and then stick them in another database using a different datasource. In some cases the same one entity bean is used in two (or more) different tables, so that the entity may need to specify what datasource it needs to be used with. How is this done?

Thank you.

1. Re: How to specify DataSource when using multiple datasource

schaefera Nov 1, 2001 3:53 PM (in response to kevin_duffey)

I think you cannot do this with CMP. What you can do is that you create two different CMP-EJBs using the classes but specify two Entity-Beans using two different datasources. Now you can use a SLSB and copy the data from one EB to the other.

Have fun - Andy
Actions
2. Re: How to specify DataSource when using multiple datasource

davidjencks Nov 1, 2001 11:20 PM (in response to kevin_duffey)

Note that this will not give you correct transactional semantics unless you have an xa capable driver and you are using its xa capabilities. (i.e, you are using the real XADataSource class rather than jboss's fake XADataSourceImpl in XADataSourceLoader configuration).
Actions

Go to original post