Re: What is causing 'canceling statement due to user

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: What is causing 'canceling statement due to user
Date: 2006-10-27 08:13:17
Message-ID: 1161936796.32342.155.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> JDBC *can* cancel a running statement. You just need to call cancel()
> from another thread.
>
> http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html#cancel()
>
> Works great in my SQL front end.

Are you sure ? Ever tried to cancel a long running statement and see if
it is still running in the DB after you cancelled it on the JDBC side ?

Cheers,
Csaba.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J S B 2006-10-27 08:30:47 Function returning setof more than 1 table
Previous Message Coder At Heart 2006-10-27 07:26:51 Re: Reducing pg_dump & pg_restore times