2

Setting Statement Timeout within SQL Datasources

Would like the ability to include a `SET statement_timeout TO 60000;` to the beginning of an SQL data source so that the DB's they call don't have long running queries on OUR end (I know the call times out at 30 seconds on the Klipfolio end but that does nothing to the underlying database). ALL SQL editors/interfaces support this but you all currently don't.

Implementation Ideas

  • Account level setting for all SQL datasources that would inject the `SET statement_timeout TO 60000;` to all SQL datasource calls under the hood where the numeric is configurable
  • Support at the individual data source level to allow `SET statement_timeout TO 60000;'

Here is the one line of code you'd need to add to your Java application to achieve this:

https://github.com/hhru/postgres-jdbc/blob/master/postgresql-jdbc-8.3-603.src/org/postgresql/jdbc2/AbstractJdbc2Statement.java#L602

0 comments

Please sign in to leave a comment.