How to use multiple DataSources in a JBoos AP ?

Hi there... folks... i am in a big dilema i need to use two databases from my project.
One in Oracle the other in MySQl. and the problem is that the Oracle's ones should have the user and roles. Please anyone there could give me good advices in how to manage this in my jboss seam web project ?

thanks...

JBoos AP? I guess you mean JBoss AS.

i am in a big dilema i need to use two databases from my project.
One in Oracle the other in MySQl.

You will have to create 2 datasources. Maybe this previous discussion will help

After creating your two *-ds.xml files, then:

a) Configure a DatabaseServerLoginModule in login-config.xml to reference the Oracle database.

b) For a web app I would say to configure web.xml and jboss-web.xml to use the login module from step a). But I am not sure where that configuration would go in Seam.

c) Configure Hibernate to use the MySQL database.

At least, I hope it is that simple and that Seam doesn't require some additional/alternate configuration.

Thanks for the help...

Peter Johnson wrote:After creating your two *-ds.xml files, then:

a) Configure a DatabaseServerLoginModule in login-config.xml to reference the Oracle database.

b) For a web app I would say to configure web.xml and jboss-web.xml to use the login module from step a). But I am not sure where that configuration would go in Seam.

c) Configure Hibernate to use the MySQL database.

At least, I hope it is that simple and that Seam doesn't require some additional/alternate configuration.