|
Can we
do this using CMP beans?
This is what exactly we are doing. we have method
called getConnection(), that sets the data source and get the
connection.
And in your case you can check ur user
rights and appropriately select the data source.
bye
Saminathan
----- Original Message -----
Sent: Tuesday, April 02, 2002 10:10
AM
Subject: Re: Using multiple data
sources inside single Entity EJB
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 -----
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
|
