Results 1 to 2 of 2
  1. 01-04-2011, 01:24 PM #1
    namalsera
    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)
    Reply With Quote Reply With Quote
  2. 01-04-2011, 03:53 PM #2
    Tolls
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    10,481
    Rep Power
    16

    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.
    Reply With Quote Reply With Quote
« BlueJ and SQL Server 2000 | Can I install 2 databases on the same PC? »

Similar Threads

  1. Passing DateTime in java to mysql Stored Procedure
    By ashin in forum SWT / JFace
    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. calling stored procedure through java
    By KTR in forum JDBC
    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

Bookmarks

Posting Permissions

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

Forum Rules