Return-Path: Delivered-To: apmail-jakarta-tomcat-dev-archive@apache.org Received: (qmail 9182 invoked from network); 28 Apr 2003 15:41:34 -0000 Received: from exchange.sun.com (192.18.33.10) by daedalus.apache.org with SMTP; 28 Apr 2003 15:41:34 -0000 Received: (qmail 16866 invoked by uid 97); 28 Apr 2003 15:43:35 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-dev@nagoya.betaversion.org Received: (qmail 16859 invoked from network); 28 Apr 2003 15:43:34 -0000 Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12) by nagoya.betaversion.org with SMTP; 28 Apr 2003 15:43:34 -0000 Received: (qmail 8275 invoked by uid 500); 28 Apr 2003 15:41:22 -0000 Mailing-List: contact tomcat-dev-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Developers List" Reply-To: "Tomcat Developers List" Delivered-To: mailing list tomcat-dev@jakarta.apache.org Received: (qmail 8264 invoked from network); 28 Apr 2003 15:41:21 -0000 Received: from web8107.mail.in.yahoo.com (203.199.70.121) by daedalus.apache.org with SMTP; 28 Apr 2003 15:41:21 -0000 Message-ID: <20030428154121.29827.qmail@web8107.mail.in.yahoo.com> Received: from [128.107.253.38] by web8107.mail.in.yahoo.com via HTTP; Mon, 28 Apr 2003 16:41:21 BST Date: Mon, 28 Apr 2003 16:41:21 +0100 (BST) From: =?iso-8859-1?q?Vikas?= Subject: JDBC and tomcat To: tomcat-dev@jakarta.apache.org MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-1777345488-1051544481=:26109" Content-Transfer-Encoding: 8bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N --0-1777345488-1051544481=:26109 Content-Type: multipart/alternative; boundary="0-429376563-1051544481=:26109" --0-429376563-1051544481=:26109 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi Community I am posting this message previously also and to tomcat-user group but not help. I am making call to stored procedure on oracle using CallableStatement.After executing the statement when I am trying to return the result set using statement.getObject(1) it takes long time to return.This was on Tomcat server I tried same thing by making test bean and running it as standalone class.The time difference was almost around 100 secs Hi can anybody pls suggest me what can be the problem Catch all the cricket action. Download Yahoo! Score tracker --0-429376563-1051544481=:26109 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit

Hi Community I am posting this message previously also and to tomcat-user group but not help. I am making call to stored procedure on oracle using
CallableStatement.After executing the statement when I am trying to return the result
set using statement.getObject(1) it takes long time to return.This was
on Tomcat server I tried same thing by making test bean and running it
as standalone class.The time difference was almost around 100 secs

 

Hi can anybody pls suggest me what can be the problem

 

Catch all the cricket action. Download Yahoo! Score tracker --0-429376563-1051544481=:26109-- --0-1777345488-1051544481=:26109 Content-Type: message/rfc822 Content-Transfer-Encoding: 8bit X-Apparently-To: viksd2kin@yahoo.co.in via web8102.mail.in.yahoo.com; 24 Apr 2003 09:42:30 +0500 (IST) Return-Path: Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12) by mta104.mail.in.yahoo.com with SMTP; 24 Apr 2003 09:42:28 +0500 (IST) Received: (qmail 34141 invoked by uid 500); 24 Apr 2003 04:12:11 -0000 Mailing-List: contact tomcat-dev-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Developers List" Reply-To: "Tomcat Developers List" Delivered-To: mailing list tomcat-dev@jakarta.apache.org Received: (qmail 34120 invoked from network); 24 Apr 2003 04:12:10 -0000 Received: from web8105.mail.in.yahoo.com (HELO web8105.in.yahoo.com) (203.199.70.105) by daedalus.apache.org with SMTP; 24 Apr 2003 04:12:10 -0000 Received: from [128.107.253.38] by web8105.mail.in.yahoo.com via HTTP; Thu, 24 Apr 2003 05:12:17 BST Date: Thu, 24 Apr 2003 05:12:17 +0100 (BST) From: =?iso-8859-1?q?Vikas?= Subject: JDBC and tomcat To: tomcat-dev@jakarta.apache.org In-Reply-To: <1050991125.52034.ezmlm@jakarta.apache.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-1459201585-1051157537=:14816" Content-Transfer-Encoding: 8bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Content-Length: 1575 --0-1459201585-1051157537=:14816 Content-Type: multipart/alternative; boundary="0-1156687234-1051157537=:14816" --0-1156687234-1051157537=:14816 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi Community I am posting this message previously also and to tomcat-user group but not help. I am making call to stored procedure on oracle using CallableStatement.After executing the statement when I am trying to return the result set using statement.getObject(1) it takes long time to return.This was on Tomcat server I tried same thing by making test bean and running it as standalone class.The time difference was almost around 100 secs Is the time difference due to the fact that i am using weberver or i am missing something. I have profiled the functionality and I have attached the result both while running it on tomcat and while runing it standalone.There is significant difference in call to oracle.jdbc.ttc.....for getObject() method Could you pls tell me if this is due to tomcat or something else. ****** Viks ****** Catch all the cricket action. Download Yahoo! Score tracker --0-1156687234-1051157537=:14816 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit

Hi Community I am posting this message previously also and to tomcat-user group but not help. I am making call to stored procedure on oracle using
CallableStatement.After executing the statement when I am trying to return the result
set using statement.getObject(1) it takes long time to return.This was
on Tomcat server I tried same thing by making test bean and running it
as standalone class.The time difference was almost around 100 secs Is
the time difference due to the fact that i am using weberver or i am
missing something.
I have profiled the functionality and I have attached the result both while running it on tomcat and while runing it standalone.There is significant difference in call to oracle.jdbc.ttc.....for getObject() method Could you pls tell me if this is due to tomcat or something else.



******
Viks
******

Catch all the cricket action. Download Yahoo! Score tracker --0-1156687234-1051157537=:14816-- --0-1459201585-1051157537=:14816 Content-Type: text/plain; name="Tomcat.txt" Content-Description: Tomcat.txt Content-Disposition: inline; filename="Tomcat.txt" 93.2% - 63567 ms - 0 inv. java.sql.CallableStatement.getObject 93.2% - 63567 ms - 0 inv. oracle.jdbc.driver.OracleCallableStatement.getObject 93.2% - 63567 ms - 0 inv. oracle.jdbc.driver.OracleStatement.getObjectValue 93.2% - 63567 ms - 0 inv. oracle.jdbc.driver.OracleStatement.getObjectValue 93.2% - 63567 ms - 0 inv. oracle.jdbc.driver.OracleStatement.getCursorValue 93.2% - 63567 ms - 0 inv. oracle.jdbc.driver.OracleStatement. 93.2% - 63567 ms - 0 inv. oracle.jdbc.ttc7.TTC7Protocol.fetch 93.2% - 63567 ms - 0 inv. oracle.jdbc.ttc7.TTC7Protocol.doOall7 93.2% - 63567 ms - 0 inv. oracle.jdbc.ttc7.Oall7.receive 93.2% - 63557 ms - 239 inv. oracle.jdbc.ttc7.TTIrxd.unmarshal 0.0% - 6 ms - 240 inv. oracle.jdbc.ttc7.MAREngine.unmarshalSB1 0.0% - 1 ms - 1 inv. oracle.jdbc.ttc7.TTIoer.unmarshal 0.0% - 0 ms - 1 inv. oracle.jdbc.ttc7.TTIoer.init 0.0% - 0 ms - 1 inv. oracle.jdbc.driver.OracleStatement.getResultSet --0-1459201585-1051157537=:14816 Content-Type: text/plain; name="Stanalone.txt" Content-Description: Stanalone.txt Content-Disposition: inline; filename="Stanalone.txt" 5.7% - 8926 ms - 0 inv. java.sql.DriverManager.getConnection 3.8% - 5936 ms - 1 inv. java.sql.CallableStatement.getObject 3.8% - 5936 ms - 1 inv. oracle.jdbc.driver.OracleCallableStatement.getObject 3.8% - 5936 ms - 1 inv. oracle.jdbc.driver.OracleStatement.getObjectValue 3.8% - 5936 ms - 1 inv. oracle.jdbc.driver.OracleStatement.getObjectValue 3.8% - 5936 ms - 1 inv. oracle.jdbc.driver.OracleStatement.getCursorValue 3.8% - 5935 ms - 1 inv. oracle.jdbc.driver.OracleStatement. 3.5% - 5445 ms - 1 inv. oracle.jdbc.ttc7.TTC7Protocol.fetch 3.5% - 5445 ms - 1 inv. oracle.jdbc.ttc7.TTC7Protocol.doOall7 3.5% - 5425 ms - 1 inv. oracle.jdbc.ttc7.Oall7.receive 3.4% - 5400 ms - 13 inv. oracle.jdbc.ttc7.MAREngine.unmarshalSB1 3.4% - 5400 ms - 13 inv. oracle.jdbc.ttc7.MAREngine.unmarshalUB1 3.4% - 5400 ms - 13 inv. java.io.InputStream.read 3.4% - 5400 ms - 13 inv. oracle.net.ns.NetInputStream.read 3.4% - 5400 ms - 13 inv. oracle.net.ns.NetInputStream.read 3.4% - 5400 ms - 13 inv. oracle.net.ns.NetInputStream.read 3.4% - 5399 ms - 1 inv. oracle.net.ns.NetInputStream.getNextPacket 3.4% - 5399 ms - 1 inv. oracle.net.ns.Packet.receive 3.4% - 5399 ms - 3 inv. java.io.InputStream.read 0.0% - 0 ms - 1 inv. oracle.net.ns.Packet.createBuffer 0.0% - 0 ms - 1 inv. oracle.net.ns.NetOutputStream.flush 0.0% - 0 ms - 1 inv. oracle.net.ns.NetInputStream.processPacket 0.0% - 0 ms - 13 inv. oracle.net.ns.DataPacket.getDataFromBuffer --0-1459201585-1051157537=:14816 Content-Type: text/plain; charset=us-ascii --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-dev-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-dev-help@jakarta.apache.org --0-1459201585-1051157537=:14816-- --0-1777345488-1051544481=:26109 Content-Type: text/plain; charset=us-ascii --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-dev-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-dev-help@jakarta.apache.org --0-1777345488-1051544481=:26109--