From: "Kevin B" Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.tools References: <3a4dff07$1@news.starhub.net.sg> Subject: Re: JDK Hang due to SQL Query Lines: 40 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: Date: Mon, 01 Jan 2001 14:48:02 GMT NNTP-Posting-Host: 24.25.11.203 X-Complaints-To: abuse@rr.com X-Trace: typhoon.southeast.rr.com 978360482 24.25.11.203 (Mon, 01 Jan 2001 09:48:02 EST) NNTP-Posting-Date: Mon, 01 Jan 2001 09:48:02 EST Organization: Road Runner - NC If your delete statement is deleting large numbers of rows, this will cause your delete statement execution time to be long and possible timeout. When deleting large numbers of rows in Oracle, you should perform commits on a regular basis or in intervals. This will assist you with completion of deleting large volumes of data. Try performing commits after every 500 rows. Kevin "Adrian Ting" wrote in message news:3a4dff07$1@news.starhub.net.sg... > Hi, i am facing a major problem in my current development. > > When I send a SQL query (through servlets) to Oracle8i via the Oracle thin > driver, it always seem to hang my JDK with one set of SQL statement -- > particularly > > DELETE FROM table_name WHERE table_id='xxx' > > This statement has been tested through both a regular > statement.executeUpdate() as well as a preparedstatement.executeUpdate() and > yields similar results. However, this does not occur for all tables, > particularly only tables with quite a number of fields. > > My development configuration: > Apache Webserver 1.3.14 > Apache JServ 1.1.2-2 > JDK1.3 > JSDK2.0 > Oracle8i v.8.1.6 > > Anybody has faced similar problem before and has a solution? Heard its a bug > in JDK1.3 about statements with the 'WHERE' condition. At my wits end now. > >