Re: JDK Hang due to SQL Query

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" <adrianting_at_post1.com> wrote in message news:3a4dff07$1_at_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.
>
>
Received on Mon Jan 01 2001 - 15:48:02 CET