Re: How cancel query through JDBC?

From: Don Seiler <don.seiler_at_cellcom.com>
Date: Thu, 31 Jul 2003 13:37:52 -0500
Message-Id: <pan.2003.07.31.18.37.23.636586@cellcom.com>

I've been reading about people using java.util.Timer to implement something like this. I'm a bit lost on this area and haven't found any examples to help me out.

Has anyone else done something like this?

Don.

On Thu, 31 Jul 2003 11:41:07 -0500, Don Seiler wrote:

> I have pretty much the exact same question. Although the problem is that
> I have update queries that are waiting indefinitely on tables or rows that are locked by
> another application. I tried java.sql.Statement.setQueryTimeout(x) but it
> didn't timeout. I've now read that setQueryTimeout won't detect a problem
> in my instance.
>
> I need a way to automatically have my update query be automatically timed
> out instead of waiting forever.
Received on Thu Jul 31 2003 - 13:37:52 CDT