|
Well....Nope it's not possible in
CMP since the specific EJB container is responsible to use the connection pool
as specified in the (App Server specific) deployment descriptor (and one can
just specify a single connection pool).
Thanks
Zahid.
----- Original Message -----
Sent: Tuesday, April 02, 2002 12:07
PM
Subject: Re: Using multiple data sources
inside single Entity EJB
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
|
