Re: Application and Database Connection pooling
From: joel garry <joel-garry_at_home.com>
Date: Mon, 22 Jun 2009 09:44:31 -0700 (PDT)
Message-ID: <c0f29d3c-6bf5-4438-9ce0-7ad5382e23bf_at_d7g2000prl.googlegroups.com>
On Jun 14, 10:36 pm, DeB <debashish.majum..._at_gmail.com> wrote:
> Dear All,
>
> 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.
>
> --
> Thanks
> DeB
Date: Mon, 22 Jun 2009 09:44:31 -0700 (PDT)
Message-ID: <c0f29d3c-6bf5-4438-9ce0-7ad5382e23bf_at_d7g2000prl.googlegroups.com>
On Jun 14, 10:36 pm, DeB <debashish.majum..._at_gmail.com> wrote:
> Dear All,
>
> 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.
>
> --
> Thanks
> DeB
Check out this classic scenario:
http://www.jlcomp.demon.co.uk/kiddy_scripts.html#_Always_be_cautious_about_x$_and_v$
jg
-- _at_home.com is bogus. http://www.slurpee.com/Slurpeetainment/Default.aspxReceived on Mon Jun 22 2009 - 11:44:31 CDT