Thanks. I have access to the Statement object that issued the original query. I used the latest JDBC driver for PostgreSQl7.3 and JDK1.4 and I used threads to achieve it. Thanks once again.
prahalad On Thu, 11 Dec 2003, Kris Jurka wrote: > > > On Tue, 9 Dec 2003, H A Prahalad wrote: > > > > > Hello, > > I want to know whether PostgreSQL support cancel() [cancel > > JDBCStatement]. I want to abort a long running query issued/executed by a > > java application using JDBC driver to connect to the database. Thanks. > > > > The JDBC driver does support Statement.cancel(), but the tricky part is > that you need to have access to the Statement object that issued the > original query. You can't just open a new connection and cancel another > query. > > Kris Jurka > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
