Results 1 to 2 of 2
  1. #1
    namalsera is offline Member
    Join Date
    Jan 2011
    Posts
    3
    Rep Power
    0

    Default java call stored procedure

    I am calling a Oracle (10g) stored procedure from my java program and some time it gets hang.
    Is there any way to define a time out so that it will pass the controll to the program. (Stored procedure is developed by 3rd party)

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    19

    Default

    There is a setQueryTimeout on Statement.
    I've not used it ,so can't say if it works or not, but you can test it out.

    Failing that maybe fire this off in its own thread?

    ETA: If you don't care about any return values then launching in its own thread might be the solution.

Similar Threads

  1. Replies: 1
    Last Post: 09-10-2010, 03:47 PM
  2. Debug mySql stored procedure
    By ulix83 in forum NetBeans
    Replies: 0
    Last Post: 10-29-2009, 11:48 AM
  3. How to call Oracle stored procedure from Java?
    By parag_narkhede in forum New To Java
    Replies: 4
    Last Post: 10-07-2009, 07:50 AM
  4. Replies: 2
    Last Post: 01-30-2009, 12:53 PM
  5. stored procedure
    By sankarigopi in forum JDBC
    Replies: 1
    Last Post: 11-13-2008, 04:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •