File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle SQL Execution Time

 
Wilson Tsing Yi
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Author and ninkuma
Marshal
Pie
Posts: 64173
83
IntelliJ IDE Java jQuery Mac Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
Ranch Hand
Posts: 823
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic