Re: max execution time of query

S Arvind wrote:
> Is there any possibility to mention max time a query can execute from
> DBCP side? our DB is Postgres and Container is tomcat 6. we dont want to
> give the timeout in postgres for all query but need to set in
> application side based on differnet needs? Is it possible?
>
> Is there anyother way to specify the query execution time out while
> establishing connection with the help of DBCP in tomcat?
>
> Example, if a query executed from web application then it should not
> execute more then 22mins. If it execute more then that means query shold
> be cancelled from postgres(important) and java should get exception on
> this event. Is it possible?

You can set statement_timeout per session.

http://www.postgresql.org/docs/8.3/static/runtime-config-client.html

Not sure what happens on the java side when the exec time is hit but the
query is cancelled in postgres.

--
Postgresql & php tutorials
http://www.designmagick.com/