wood burning stoves 2.0*
The moose likes JDBC and the fly likes JSQLConnect.jar issue . Stored proc hangs to complete Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JSQLConnect.jar issue . Stored proc hangs to complete" Watch "JSQLConnect.jar issue . Stored proc hangs to complete" New topic
Author

JSQLConnect.jar issue . Stored proc hangs to complete

Dhiren Joshi
Ranch Hand

Joined: Dec 09, 2003
Posts: 463
I am making a very simple JSQL connect call from a Java application.
cstmt =con.prepareCall("{call msp_GetAllNames ?,?,?,?}");

cstmt.setLong(1,this.Number);
cstmt.setDate(2,this.Date);
cstmt.setString(3,this.ID);
cstmt.setInt(4,this.isNumber);

rs=cstmt.executeQuery();

The stored never seems to complete.
Any one gone through this issue.
Running the sp through SQL Query Analyzer works only does not work through Java .

Thanks
Dhiren
 
Don't get me started about those stupid light bulbs.
 
subject: JSQLConnect.jar issue . Stored proc hangs to complete
 
Similar Threads
How to call stored procedure through Hibernate?
How to improve the performance of jsf datatable?
List Updation
How can we call a stored procedure from java file
Max length of string returned by Resultset