I've run my Java program in the DB2 server. It returns all values needed but in the end the error below occured :

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0601E Invalid statement handle or statement is closed. SQLSTATE=S1000

There are no data inserted into the table in the database.

Please tell me what is going on?

Maybe if you post the DB2 version and OS, along with the code that is causing the problem, you might get some constructive help.

Andy

Staying on the same level of details: your application has a bug that causes the statement handle to be invalidated. That's why DB2 is giving you this error.

Currently, I am using the Db2 ver 8.2
Server p series.
OS AIX 1.3.

Thank u very much

Thank u for ur answer.
How can I detect the bug?

Yoo hawe ollreadee deeteckted ze bahg. Nau yoo nied two ficks ze same.

Sorry....haha....

what I meant was how to get rid of the bug? Is there any application to do it? I am soo new in DB2....thanks....

It might be quite difficult to guess without seeing the code, don't you think? This kind of error generally happens when you close a cursor (explicitly or by a commit) and then try to fetch from it.

I want to paste the code but it's too long....

Then reduce the code to a few lines that still exhibit the problem. I guess once you are down to a few dozen lines, you'll find the problem yourself rather quickly.

The alternative is that you start to sprinkle your code with debug information and validate the statement handle at various places. That way, you can narrow down where the handle becomes invalid.