On 2003.06.17 01:04, Richard Ji wrote:
I used to seen problems with JDBC Thin with MTS on Linux and switching to
a dedicated connection seemed to fix the problem. But JDBC Thin and MTS
worked fine on my Solaris box. Not sure with HP-UX. Is the Java application
running on an Application Server?
Richard is right...If ur Java application uses it own connection
pooling...then do not use MTS...it slows down connections and more...We
faced the same issue here
Our configuration allows DBA to choose weather connection pooling should
handled by the app or the database...
Use dedicated
OK. Let me get some things straight:
a) I'm not a developer. I'm one of those vile creatures called DBAs.
I don't program. I troubleshoot other people's programs. Other people
program, I nag. When developers start writing bug-free software which
uses the database in the most optimal way,
Mladen - I'll add what I know, but it won't add much.
When the Java people say they are doing connection pooling, that almost
certainly means they are using an application server. This is the beast on
which to focus your attention. Start by finding out which species it is.
There are in my
Mladen,
I've found MTS to be a blessing and a curse at the same time no matter what
language (C, ASP, JAVA, etc...) is being used. The biggest problem with MTS is the
number of idle shared servers that you have at any point in time. When you connection
request is processed by the
We add:
1. Application (Java)
Using a JDBC Connection Pooling (CP)feature...
2. Database
Oracle in MTS, pooling or not pooling enabled
This was not good for us...so we kept the Java pooling side of the app and
Oracle configured to run in dedicated mode.
We'got a XML policy file which disables
Refer to Note:139775.1 - see if this helps out - basically it says to
configure the jdbc driver so that it has to use dedicated server - using MTS is
the problem.
[EMAIL PROTECTED] 6/17/2003 7:24:50 AM
OK. Let me get some things straight:a) I'm not a developer. I'm one of
those vile
b) I use server=dedicated, is srvr=dedicate a short hand version of
it?
-Original Message-
Sent: Tuesday, June 17, 2003 8:25 AM
To: Multiple recipients of list ORACLE-L
OK. Let me get some things straight:
a) I'm not a developer. I'm one of those vile creatures called DBAs.
I don't
I recall an old bug where MTS would sleep for a bit - don't recall the bug
anymore.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216)
781-4204 [EMAIL PROTECTED] 6/17/03 12:35:20 PM
b) I use server=dedicated, is
Subject: RE: JDBC and MTS
Sent by:
[EMAIL PROTECTED
I used to seen problems with JDBC Thin with MTS on Linux and switching to
a dedicated connection seemed to fix the problem. But JDBC Thin and MTS
worked fine on my Solaris box. Not sure with HP-UX. Is the Java application
running on an Application Server?
Richard Ji
-Original Message-
11 matches
Mail list logo