How to set timeout for INSERT query in postgres with MyBatis (Java)

Question

In Mybatis there is an attribute timeout for mapper files but that throws Exception.

Cause: org.postgresql.util.PSQLException: Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented.
uncategorized SQLException for SQL []; SQL state [0A000]; error code [0]; Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented.; nested exception is org.postgresql.util.PSQLException: Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented.
........

Craig Ringer · Accepted Answer · 2014-01-05 01:02:40Z

1

PostgreSQL doesn't currently support query timeouts at the server level. So PgJDBC has a hard time implementing them client-side, though I rather thought current PgJDBC versions emulated it using statement_timeout.

Anyway, if updating to the latest PgJDBC (you failed to specify your version) doesn't help, what you need to do is SET statement_timeout before your query, then reset it after the query. Just execute:

SET statement_timeout = '5s';

or whatever before your query. If you're running it within an already open transaction you can use SET LOCAL to make the setting transaction scoped.

answered Jan 5, 2014 at 1:02

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Amit Maniar Over a year ago

Craig, I am using Postgrs 9.2 and using mapped xml for insert queries as <insert id="someId" parameterType="List">INSERT INTO Something () </insert>

Craig Ringer Over a year ago

@user1450574 Well, then you're going to have to use a more flexible framework, or (if the latest PgJDBC does not help) propose a patch to PgJDBC to do what you want.

Collectives™ on Stack Overflow

How to set timeout for INSERT query in postgres with MyBatis (Java)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related