Re: Application and Database Connection pooling
Date: Sun, 21 Jun 2009 08:23:47 -0700 (PDT)
On Jun 15, 1:36 am, DeB <debashish.majum..._at_gmail.com> wrote:
> We have a J2EE app and are considering the connection pooling options
> from the Oracle 10g R2 and the J2EE app itself. I've come across posts
> which warn against using this feature on the application side and
> letting the connection pool to be managed from the Oracle end only by
> using the MTS feature.
> It that's the case, I would request everyone to let me know the
> reasons for doing the same. I apologize if I couldn't give you details
> or specifics about the architecture. The database will be a pure a
> OLTP one.
> Please suggest.
You have to not just consider the implications ... you really need to test and benchmark against what you initially determine to be viable options.
Even if you do connection pooling on the app side that doesn't force you into MTS. Received on Sun Jun 21 2009 - 10:23:47 CDT