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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JSQLConnect.jar issue . Stored proc hangs to complete