Statement.cancel() doesn't seem to work

From: JN <jim(dot)newsham(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Statement.cancel() doesn't seem to work
Date: 2010-04-06 01:56:05
Message-ID: 123b6e3e-7744-4bd6-a470-59e98e1b9141@r27g2000yqn.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


Hi, I'm trying to cancel a long-running statement (takes about 400
seconds) by calling PreparedStatement.cancel() from another thread,
but it's not working. Specifically, the call to
PreparedStatement.cancel() completes normally, but the executing
statement seems to complete normally (i.e., it still takes the same
amount of time to complete, and it does not throw any exception). The
sql being executed is a delete ("delete from qos_data where
report_time < ?"). Is PreparedStatement.cancel() not implemented?

Thanks,
Jim

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Craig Ringer 2010-04-06 04:09:42 Re: An I/O error occured while sending to the backend.
Previous Message Breno BF 2010-04-06 01:41:59 An I/O error occured while sending to the backend.