Hi All,

I've a java application on client side which is using JDBC. The server has DB2 v 7.2 , windows2000/NT .

Problem is that whenever the SQL Select statement is invoked from the application where the result number of rows is too high, it fails and gives

CLI0601E Invalid statement handle or statement is closed. SQLSTATE=S1000] [IBM][JDBC Driver]

The same SQL statement from the same code works fine when the result number of rows are not extremely high.

When I searched on this error , I found this can be caused by the mismatch in JDBC and db2java.zip. But we are not using applet .

If someone has any clue about this problem, please let me know.

Thanks.