This has been addressed a few times before. Check the list archives on SourceForge:
http://sourceforge.net/mailarchive/forum.php?forum_name=dspace-tech Jim On Tue, Jul 17, 2007 at 11:14:29AM +0300, Hlias Stavrakis wrote: > Hi, i'm getting the following exception after 40 ingestions in dspace using > dsrun. > Can anyone help? > > java.sql.SQLException: ORA-01000: maximum open cursors exceeded > > > > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) > > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742) > > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) > > at > oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:954) > > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1167) > > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284) > > at > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3367) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) > > at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:519) > > at > org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:539) > > at org.dspace.browse.Browse.itemRemoved(Browse.java:439) > > at org.dspace.browse.Browse.itemChanged(Browse.java:465) > > at org.dspace.content.Item.update(Item.java:1500) > > at org.dspace.content.Item.create(Item.java:247) > > at org.dspace.content.WorkspaceItem.create(WorkspaceItem.java:173) > > at org.dspace.app.itemimport.ItemImport.addItem(ItemImport.java:629) > > at org.dspace.app.itemimport.ItemImport.addItems(ItemImport.java:506) > > at org.dspace.app.itemimport.ItemImport.main(ItemImport.java:415) > > java.sql.SQLException: ORA-01000: maximum open cursors exceeded > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as "HP CONFIDENTIAL". ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech