Java - Oracle Open Cursors Problem

Hi,

I am getting the following error in my application:ORA-01000: maximum open cursors exceeded. Actually I'm using connection pool mechanism ( nothing but a Vector with the connection objects maintained ). The same connection is being used for processing the messages in the sequence. If I process more than 100 messages ( approximately 4 queries per message), 2 messages are not stored into DB for each set of 100. I'm closing the Statement object in finally block. No ResultSet object is used. In the init.ora I have set Open_Cursors as 500. Please help me to solve this issue.

Thanks in advance.

Regards,

R.Rajapriya.

[662 byte] By [Rajapriya.Ra] at [2007-10-3 3:10:44]