Graham: I notice that the default for db.statementpool is true, should we have this set to false. What is the danger in leaving it at true?
Thanks! Jose -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Graham Triggs Sent: Tuesday, December 11, 2007 12:49 PM To: Rodrigo Castro Artigas Cc: [email protected] Subject: Re: [Dspace-tech] ORA-01000: nUmero mAximo de cursoresabiertos excedido Hi, Ensure that you have disable the prepared statement cache in your dspace.cfg: db.statementpool = false G On Tue, 2007-12-11 at 14:26 -0300, Rodrigo Castro Artigas wrote: > HI, I AM run process import and have the followind message: > > java.sql.SQLException: ORA-01000: número máximo de cursores abiertos > excedido > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.j > ava:21 > 6) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement. > java:966) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatemen > t.java > :1170) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepa > redSta > tement.java:3339) > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepare > dState > ment.java:3423) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Dele > gating > PreparedStatement.java:101) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Dele > gating > PreparedStatement.java:101) > at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.j > ava:51 > 9) > at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.j > ava:53 > 9) > at org.dspace.browse.Browse.itemRemoved(Browse.java:439) > at org.dspace.content.Collection.delete(Collection.java:952) > at org.dspace.content.Community.removeCollection(Community.java:751) > at > org.dspace.app.webui.servlet.admin.EditCommunitiesServlet.doDSPost(Edi > tCommu > nitiesServlet.java:275) > at > org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServle > t.java > :147) > at > org.dspace.app.webui.servlet.DSpaceServlet.doPost(DSpaceServlet.java:105) > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > > The solution with change configuration Dspace or Oracle?????????? > > Atte., > Rodrigo > > > ---------------------------------------------------------------------- > --- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for just about anything > Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech This email has been scanned by Postini. For more information please visit http://www.postini.com ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
