From John.Shaw@correctionscorp.com Tue, 17 Jun 2003 07:07:48 -0700 From: "John Shaw" Date: Tue, 17 Jun 2003 07:07:48 -0700 Subject: Re: JDBC and MTS Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 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, my job is gone.b) The whole problem is that even after specifying SRVR=DEDICATED in the    connect string, the darned thing still connects as an MTS connection.c) What was the issue that you faced? That was my original question.On 2003.06.17 07:09, Regis Biassala wrote:> 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 servers if there's noway you can disable the application> connection pooling...> > > Regis> > -----Original Message-----> Sent: Tuesday, June 17, 2003 6:05 AM> To: Multiple recipients of list ORACLE-L> > > 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-----> Sent: Monday, June 16, 2003 11:25 PM> To: Multiple recipients of list ORACLE-L> > > I'm not a Java expert so please forgive me my ignorance. JDBC application> is facing very strange performance problems during connect. Every now and> then> everything appears to be hung and then, 10 minutes later, users proceed> normally but with the elevated blood pressure and serious lack of patience.> I was told that JDBC has it's own connection pooling mechanism and that it> will start it's own dedicated server connection. It seems though that the> string "SRVR=DEDICATED" has been ignored and that users are acquiring a> shared> server connection.> Does anybody in this group have any experience with JDBC and MTS? Version is> 8.1.7.1, 64 bit on HP-UX 11 with OPS. Dispatchers are cross-registered with> listeners on all 4 nodes for load balancing purposes. I found surprisingly> little material on the Metalink. No network collisions, no retransmits, no> timeouts can be seen from netstat -i and netstat -s. The NIC is 1GB Ethernet> and I would be very surprised if approximately 100 users could kill it with> a> JDBC application. They could use DBA as a human sacrifice, though.> > > > --> Mladen Gogala> Oracle DBA> --> Please see the official ORACLE-L FAQ: http://www.orafaq.net> --> Author: Mladen Gogala>   INET: [EMAIL PROTECTED]> > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com> San Diego, California        -- Mailing list and web hosting services> ---------------------------------------------------------------------> To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from).  You may> also send the HELP command for other information (like subscribing).> --> Please see the official ORACLE-L FAQ: http://www.orafaq.net> --> Author: Richard Ji>   INET: [EMAIL PROTECTED]> > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com> San Diego, California        -- Mailing list and web hosting services> ---------------------------------------------------------------------> To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from).  You may> also send the HELP command for other information (like subscribing).> *********************************************************************> This electronic transmission is strictly confidential and intended solely> for the addressee. It may contain information which is covered by legal,> professional or other privilege. If you are not the intended addressee,> you must not disclose, copy or take any action in reliance of this> transmission. If you have received this transmission in error,> please notify the sender as soon as possible.> > This footnote also confirms that this message has been swept> for computer viruses.> **********************************************************************> > --> Please see the official ORACLE-L FAQ: http://www.orafaq.net> --> Author: Regis Biassala>   INET: [EMAIL PROTECTED]> > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com> San Diego, California        -- Mailing list and web hosting services> ---------------------------------------------------------------------> To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from).  You may> also send the HELP command for other information (like subscribing).> -- Mladen GogalaOracle DBA-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mladen Gogala  INET: [EMAIL PROTECTED]Fat City Network Services    -- 858-538-5051 http://www.fatcity.comSan Diego, California        -- Mailing list and web hosting services---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).