Oracle Max Cursors Open

[kundur]

Hi,

I have a database intensive application that is causing Maximum Open Cursors exception when run in JBoss server (version 3.2.2). However the same application runs fine on a Weblogic app server. I am using a Oracle type-4 JDBC driver (tried versions Oracle 8.1.6, 8.1.7 and 9i and did not help). I checked my application and made sure that there are no unclosed Connections or PreparedStatements.

I downloaded the JBoss source code and was trying to find the source code that does the Connection Pooling, PreparedStatement caching but could not locate it.

I am wondering if anyone has run into similar problems.

Thanks

Kundur

[raghuram007]

Hi Kundur,

This is Raghuram. We are also facing the exactly the same problem that you had specified. Did you find any solution to this problem.....

Please let me know if you got any solution. My EmailID is [e-mail].

Thanks
Raghuram

[tad_shimada]

Hello Raghuram,

Check the info at http://www.orafaq.com/error/ora-01000.htm if you are still looking for the solution.

- TS

[kundur]

I replaced my get DB connection mechanism. I no longer use DataSource based connection. Instead I create new Connection. I am not using any ConnectionPooling. After this I no longer get the open cursor problem.