JDK Hang due to SQL Query

From: Adrian Ting <adrianting_at_post1.com>
Date: Sat, 30 Dec 2000 23:21:40 +0800
Message-ID: <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 Sat Dec 30 2000 - 16:21:40 CET

Original text of this message