Originally posted by luo hao:
I im facing the same problem.
I use websphere4.0.
But now I can give some research result even I have not solved the problem yet.
1.In websphere4.0, I use connectin pool. If I use statement, then there
is not any problem. If I use preparedStatement, the I encounted the same
problem. In the v$open_cousor, there are many records even I have closed
2.In tomcat4.0-..., I do not use connection pool, then there
is not any problem. Even I do not close the statement and preparedstatement.