Hi,
I am using Sybase and Java 1.4. The program is executing stored procedure which returns resultset.
Now when I try to execute the stored proc from RapidSQL it is returning me result, but when executed from Java program it gives empty resultset.
It is not giving any exception or error. I tried checking resultset size in Java and it is returning zero.Here is the code snippet,
m_objCallableStmt = p_objConn.prepareCall(P_GET_PRC_CHG_RPT);
m_objCallableStmt.setDate(1, dbDate);
m_objCallableStmt.setDouble(2, m_dblThrhdVal);
m_objRS = m_objCallableStmt.executeQuery();
int cnt =0;
while(m_objRS.next()){
cnt++;
}
log.debug("Cont of resultset is :"+cnt);
Please let me know what is causing this issue here.
Thanks in advance.