Thread: Interrupt execution
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
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
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 > >
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?
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? > >
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 . > >
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) > > >