Meaningless Drivel is fun!*
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JSQLConnect.jar issue . Stored proc hangs to complete
 
Similar Threads
How can we call a stored procedure from java file
Max length of string returned by Resultset
How to call stored procedure through Hibernate?
List Updation
How to improve the performance of jsf datatable?