Re: Interrupt execution

 hi ,
  I cannot comprehend how to use this cancel statement?
  i mean how does the java thread get to know that user has canceled
  (stopped)the request and it is time to execute statement.cancel?
  Is there a function/routine which is called everytime user 
  hits stop(i am using servlets),so that the call can be made therein?
  thanks

 On Mon, Jun 24, 2002 at 05:36:41AM -0400, Dave Cramer wrote:
> There is a cancel method in the statement api
> 
> Dave
> On Sun, 2002-06-23 at 05:34, Varun Kacholia wrote:
> >  hi,
> >   I using pgsql jdbc drivers to execute a particular query (web-based).
> >   Many a times it happens that the query might take time and the
> >   user hits "stop" .. in this case the pgsql-query still keeps running.
> >   Is there any way to stop it if the user "stops" transaction?
> >   Any patches/fixes/solutions for this?
> >   I think this will save a lot of hasseles dealing with crank users :) .
> >   thanks a lot for any help
> >   BTW i am using pgsql-7.2 .
> > -- 
> > ------
> > Varun
> > It is easier to write an incorrect program than understand a correct one
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
> > message can get through to the mailing list cleanly
> > 
> > 
> 
> 
> 

-- 
------
Varun
Why do the people who know the least know it the loudest?




---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html