Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSQLConnect.jar issue . Stored proc hangs to complete

 
Dhiren Joshi
Ranch Hand
Posts: 463
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic