Originally posted by luo hao:
Hello
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
every preparedStatement.
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.
-----------------<br />Flavio Rabelo<br />SJPC 1.4<br />Brazil<br />-----------------
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Consider Paul's rocket mass heater. |