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.java:21 > 6) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement. > java:966) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java > :1170) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSta > tement.java:3339) > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState > ment.java:3423) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating > PreparedStatement.java:101) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating > PreparedStatement.java:101) > at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:51 > 9) > at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java: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(EditCommu > nitiesServlet.java:275) > at > org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.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 > DSpace-tech@lists.sourceforge.net > 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech