Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: JDK Hang due to SQL Query
In article <3a4dff07$1_at_news.starhub.net.sg>,
"Adrian Ting" <adrianting_at_post1.com> wrote:
> 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.
>
>
This does sound like an potential performance problem on a large delete. If you do determine that this is not a performance issue, and you can trace the "hang" to a JDK problem, wrap the delete statement within a stored procedure. This will avoid the reference to where in the java.sql.Statement.
CREATE OR REPLACE PROCEDURE
FOO
( tid integer )
as
begin
delete from table_name where table_id = tid;
end;
Hope this helps...
-Brian
Sent via Deja.com
http://www.deja.com/
Received on Tue Jan 16 2001 - 22:39:44 CST