Entity Bean and mulitple datasource

[Pinal N Patel]

Hello,
Is it possible to have multiple entity beans connecting to multiple datasources in one container?. If yes, Is it by listing the datasource name in bean specific JNDI ENC?
For eg: In one container,
Bean1 connects to DataSource1
Bean2 connects to DataSource2
I appreciate your help in advance.
Regards,
Pinal

[Lasse Koskela]

Yes, it is possible. Let's say you have a bean implementation called MyEntityBean. You would need to
1) Deploy one EJB with MyEntityBean as the implementation having a resource reference to "DataSource1" in its ejb-jar.xml configs
2) Deploy another EJB with the same implementation class but having a resource reference in ejb-jar.xml pointing to "DataSource2"

[Naveen Sharma]

can't we have 2 datasources in one ejb-xml file..
in this way there is no need to put them into 2 jars

regards
Naveen

[Pradeep bhatt]

can't we have 2 datasources in one ejb-xml file..

Yes, you can.