Re: Query timeout in dbcp

2009-06-02 Thread Mark Thomas
S Arvind wrote: > Hi Martin & Chris, > Thing i actually need is, if a query executed from web application then it > shold not execute more then 22mins. If it execute more then that means query > shold be cancelled from postgres and java should get exception on this > event. Is it possible? If a)

Re: Query timeout in dbcp

2009-06-02 Thread S Arvind
Hi Martin & Chris, Thing i actually need is, if a query executed from web application then it shold not execute more then 22mins. If it execute more then that means query shold be cancelled from postgres and java should get exception on this event. Is it possible? Thanks, Arvind S * "Many of li

Re: Query timeout in dbcp

2009-06-01 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Arvind, On 6/1/2009 3:26 PM, S Arvind wrote: > Is there any possibility to mention max time a query can execute from DBCP > side? What do you want to happen after the timeout? The connection execute* method throws an exception? That is going to be ve

RE: Query timeout in dbcp

2009-06-01 Thread Martin Gainty
ujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: arvindw...@gmail.com > Date: Tue, 2 Jun 2009 00:56:53 +0530 > Subject: Query timeout in dbcp > To: users@tomcat.apache.org > > Is there any possibility to mention max tim

Re: Query timeout in dbcp

2009-06-01 Thread S Arvind
Is there anyother way to specify the query execution time out while establishing connection with the help of DBCP in tomcat? -Arvind S On Tue, Jun 2, 2009 at 12:56 AM, S Arvind wrote: > Is there any possibility to mention max time a query can execute from DBCP > side? our DB is Postgres and Cont

Query timeout in dbcp

2009-06-01 Thread S Arvind
Is there any possibility to mention max time a query can execute from DBCP side? our DB is Postgres and Container is tomcat 6. i dont want to give the timeout in postgres but need to set in application side based on differnet needs? Is it possible? -Arvind S "Many of lifes failure are people wh