Re: JDBC and MTS

2003-06-17 Thread Mladen Gogala
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?

RE: JDBC and MTS

2003-06-17 Thread Regis Biassala
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

Re: JDBC and MTS

2003-06-17 Thread Mladen Gogala
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,

RE: JDBC and MTS

2003-06-17 Thread DENNIS WILLIAMS
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

RE: JDBC and MTS

2003-06-17 Thread Goulet, Dick
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

RE: JDBC and MTS

2003-06-17 Thread Regis Biassala
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

Re: JDBC and MTS

2003-06-17 Thread John Shaw
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

RE: JDBC and MTS

2003-06-17 Thread Richard Ji
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

RE: JDBC and MTS

2003-06-17 Thread Jeffrey Beckstrom
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

RE: JDBC and MTS

2003-06-17 Thread alan . aschenbrenner
Subject: RE: JDBC and MTS Sent by: [EMAIL PROTECTED

RE: JDBC and MTS

2003-06-16 Thread Richard Ji
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-