Re: JDK Hang due to SQL Query

Did you try the "select"?
Is it working fine?

 (1) check the index for the where conditions  (2) check the constraints of the table. Cascading and parent constraints, etc...

"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 Tue Jan 16 2001 - 23:51:24 CST