Thread: Interrupt execution

Interrupt execution

From
Varun Kacholia
Date:
 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


Latest JDBC Documentation

From
Varun Kacholia
Date:
Hi ,
  Can someone tell where to  find the documentation for the latest
  JDBC sources?

thanks

On Sun, Jun 23, 2002 at 07:56:23PM -0700, Barry Lind wrote:
> Varun,
>
> The latest sources support this via the cancel() method.
>
> thanks,
> --Barry
>
> 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
Satisfaction is the end of success




Re: Interrupt execution

From
Dave Cramer
Date:
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@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>






Re: Interrupt execution

From
Varun Kacholia
Date:
 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@postgresql.org 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?




Re: Interrupt execution

From
Dave Cramer
Date:
This is part of the servlet api, and to tell you the truth, I don't know
the answer. Did you try some of the servlet lists?

Dave
On Mon, 2002-06-24 at 05:51, Varun Kacholia wrote:
>  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@postgresql.org 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?
>
>





Re: Interrupt execution

From
Barry Lind
Date:
Varun,

The latest sources support this via the cancel() method.

thanks,
--Barry

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 .
>
>





Re: Interrupt execution

From
"Tim Lucia"
Date:
The doGet/doPost method should get an IOException.

Tim Lucia

> -----Original Message-----
> From: Dave Cramer [mailto:Dave@micro-automation.net]
> Sent: Monday, June 24, 2002 5:54 AM
> To: Varun Kacholia
> Cc: pgsql-jdbc@postgresql.org
> Subject: Re: [JDBC] Interrupt execution
>
>
> This is part of the servlet api, and to tell you the truth, I
> don't know
> the answer. Did you try some of the servlet lists?
>
> Dave
> On Mon, 2002-06-24 at 05:51, Varun Kacholia wrote:
> >  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@postgresql.org 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 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>
>
>