Is there a way to set query timeout on JDBC staments?

[javadevmtl]

Hi using vertx 3.9.x

I have a stored procedure that blocks vertx and we get the the blocked thread checker warning.

Is there a setting we can set to kill the JDBC connection or the query before?

Looking at Hikari pool setting I don't see anything specific to query timeout.

So is it possible to call the setQueryTimout?

[javadevmtl]

Hi any thoughts on this?

[Thomas SEGISMONT]

Hi,

The JDBC Client does not let you retrieve the PreparedStatement and execute methods.

However you may be able to use Hikari's connectionInitSql property to set a session level query timeout (if your DB supports it).

--
You received this message because you are subscribed to the Google Groups "vert.x" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vertx+un...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/vertx/3a002015-6f4b-4e4c-b657-47146da74c31n%40googlegroups.com.

[colin....@canopytax.com]

I am also on 3.9.x and with io.vertx.ext.sql.SQLConnection we call connection.setOptions(new SQLOptions().setQueryTimeout(30)); to time out queries after 30 seconds. Not sure if this applies to your situation though.

[javadevmtl]

Hi, thanks I'll check it out!