Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

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?

Thank you

asked Sep 9, 2015 by PhiW61
0 votes

Related Hot Questions

Government Jobs Opening