Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org Received: (qmail 96371 invoked from network); 3 Jun 2005 23:57:58 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 3 Jun 2005 23:57:58 -0000 Received: (qmail 28579 invoked by uid 500); 3 Jun 2005 23:57:42 -0000 Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 28567 invoked by uid 500); 3 Jun 2005 23:57:42 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 28550 invoked by uid 99); 3 Jun 2005 23:57:42 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from dexter.tse.gov.br (HELO dexter.tse.gov.br) (200.252.157.99) by apache.org (qpsmtpd/0.28) with ESMTP; Fri, 03 Jun 2005 16:57:42 -0700 Received: from dexter.tse.gov.br (dexter.tse.gov.br [127.0.0.1]) by nod32.tse.gov.br (Postfix) with ESMTP id CC0E3FD041 for ; Fri, 3 Jun 2005 20:57:36 -0300 (BRT) X-Virus-Scanner: This message was checked by NOD32 Antivirus system NOD32 for Linux Mail Server. For more information on NOD32 Antivirus System, please, visit our website: http://www.nod32.com/. Received: from sp1.tre-sp.gov.br (unknown [10.1.1.1]) by dexter.tse.gov.br (Postfix) with ESMTP id 4E081FD017 for ; Fri, 3 Jun 2005 20:57:36 -0300 (BRT) Received: from [10.1.6.75] ([10.1.6.75]) by sp1.tre-sp.gov.br with ESMTP (8.9.3 (PHNE_18546)/8.7.1) id UAA07615; Fri, 3 Jun 2005 20:57:35 -0300 (BRA) Message-ID: <42A0EF08.8090503@tre-sp.gov.br> Date: Fri, 03 Jun 2005 21:00:08 -0300 From: Robson dos Santos Franca User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: tomcat-user@jakarta.apache.org Subject: (Windows) Tomcat process is using 100% CPU when running a SQL command Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hello We're using Tomcat 5.5.9 + Sun Java 1.5.0_03 + Oracle 9i in our Intranet application. Everything looks fine... unless we run a SELECT statement into Tomcat. Without the 'ORDER BY' clause, no problem. With 'ORDER BY', Tomcat runs at 100%. JDBC library file: ojdbc14.jar JDBC URL : jdbc:oracle:oci8:@ ... Any ideas? Thanks in advance Robson Franca --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org