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