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/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
