CLOB.trim() causing Max cursors on SUNONE
47261May 17 2004 — edited May 27 2005In a web application we are developing we call the trim( ) method on an oracle.sql.CLOB. When we deploy the application to Oc4J everything works just fine. If on the other hand we deploy the same application on A SUN ONE server, we run into a max cursor error. Analysis of v$open_cursor showed that for each time the clob.trim() method call is called there is an open cursor with the following SQL_TEXT
begin dbms_lob.trim (:1, :2); end;
In OC4J there is only one of these cursors per session
Both app servers use exactly the same JDBC drivers.
Both app servers connect to the same database.
Any ideas would be much appreciated