Page 1 of 1
Timeout for TQuery and TStoredProc component
Posted: Mon 08 Mar 2010 09:29
by roznicki
Do you plan to add timeout for query or stored procedures in next release? There is timeout for connection but it would by fine to decide how long query or stored procedure should be executed. Similiar feature is in JDBC drivers and it is working perfectly with Oracle (I haven't tested it with other databases).
Posted: Tue 09 Mar 2010 09:14
by Challenger
We have no such plans because OCI does not support such parameter. We can implement it for Direct mode only.
Posted: Tue 09 Mar 2010 09:47
by roznicki
Timeout for query and stored procedures in direct mode would be cool feature.
For OCI connection you can create a Timer and issue an OCIBreak() on timeout. OCIBreak() is thread safe and signal safe.
Please think about this feature in future releases.