Re: Using multiple data sources inside single Entity EJB

[Zahid Iqbal]

Well...Do provide a helper function e.g getConnection() inside (BMP) Entity EJB. Then use the specific data source based on the dynamic criteria, to create the connection either using the Connection Pool (in which case the Connection Pool for each database must exist/configured before hand) or by using Direct JDBC approach.   Thanks   Zahid. ----- Original Message ----- From: rupalim To: [EMAIL PROTECTED] Sent: Tuesday, April 02, 2002 9:30 AM hi i have a requirement like this.my application should  connect to different SID of oracle database.is there  any way by which my application should dynamically pick up the datasource name.entity bean will be one but there will be multiple SID to which it should connect dynamically. thanx rupalim