aspose file tools*
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: JSQLConnect.jar issue . Stored proc hangs to complete