oracle SQL Execution Time

[Wilson Tsing Yi]

Dear Expert,

May I know how to limit the SQL execution time when after connection has obtained in a java program ?

Thanks

wilson

[Bear Bibeault]

"GDWilson",

We're pleased to have you here with us here on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
Forum Bartender

[Julian Kennedy]

Hi Wilson,

If I understand your question (and I'm not sure I do) then you can set the query timeout provided by java.sql.Statement. A SQLException is thrown if the timeout period expires.

void setQueryTimeout(int seconds) throws SQLException;

A word of caution, however: Once you've submitted your query to the database via JDBC you have no control over how long it actually takes to execute. Just because you time out the query at the Java end doesn't mean that it will stop running on the database.

My advice is to make sure you write efficient SQL queries and try to run them independently on the DB before running them through Java so you can be confident that they won't run for ages. If you run them first on the DB directly you can kill them more easily if they're wrong.

Hope this helps.

Regards

Jules