postgresql - SetQueryTimeout(int) jdbc3 -
i trying establish connection postgres db.
ps = con.preparestatement("select * procesar(?, ?, ?, ?, ?, ?, ?, ?, ?)"); ps.setquerytimeout(timeout);
but have following error: method org.postgresql.jdbc3.jdbc3preparedstatement.setquerytimeout(int) not yet implemented.
aparently, it's driver issue. use jdbc3. question if there way set timeout db query? cannot update driver.
yes, running following query:
set [local] statement_timeout = '1s';
local means setting applied inside transaction, otherwise need reset after query done.
Comments
Post a Comment