Hi Sanjay,
Deciding on if you really require EJBs depends on many other things, discussed
recently (and many times before) on the list (you can search the archives at
http://archives.java.sun.com/ejb-interest.html).
If you do choose to go in for EJBs, go for Session or BMP Entities depending on
the conext/requirement.
Coming to creating Connection Pools, it depends on the application server you
are using. Most application servers provide API to create pools dynamically.
Here is a link that shows you how in WebLogic 6.1
http://edocs.bea.com/wls/docs61/jdbc/programming.html#1023890
Hope that helps.
-Kiran.
Sanjay Saluja wrote:
> Hi All,
>
> We need to build a project that needs to multiple databases which are
> specified through the user interface.(i.e. a user can dynamically provide a
> database at runtime).
>
> Can we use EJB in scuh scenario. Do we gain advantage because instance
> pooling or database connection pooling might need to be done away with.
> What about a session bean being used in this case. if so how do we
> efficiently handle database connections.
>
> Is there any third party utility (pref. java based and free) that can pool
> connection to multiple databases selected dynamically such as Poolman.
>
> Thanks
> Sanjay
>
> ===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
