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

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -