Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
how is oracles jdbc query timeout implemented
how is oracles jdbc query timeout implemented ¬†using -'java,oracle,jdbc,timeout'
I was curious as to how the Oralce JDBC thin client implement query timeout.
This can be set by calling java.sql.Statement's setQueryTimeout(int seconds)
Is this implemented in the driver itself on the client side? ¬†Is a
new thread spawned and joined? ¬†Or does the JDBC driver simply
send a parameter to Oracle, and then it enforces the timeout?
After the timeout is reached, which resources on the client and
database are released, and which hang around? ¬†Does Oracle continue
to run the query even though the client abandoned it or is it
terminated? ¬†Is there still a cursor object on the client side?
Sep 9, 2015
to add a comment.
Related Hot Questions
Government Jobs Opening