Re: [Dspace-tech] maximum open cursors exceeded Exception in dsrun tool
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
[Dspace-tech] (no subject)
Dear members of the community, Today we have officially launched the new foundation, with the support and help of the HP Press Relations team and MIT Library Press ( they did a fantastic job!). To coincide with the Foundation announcement we have redesigned and launched a new DSpace.org website. The purpose of redesigning the website was to achieve the following: -Give the website broader appeal from those outside or new to the community -move it to an opensource platform, called Joomla, so the community can actually add content once they are registered users ( like news/ events/weblinks). -Be able to incorporate forums, blogs ect if these become useful to the community. The website is in no way intended to replace or duplicate the content on the wiki. The wiki is the key place for all the developers and interactive users to find the most complete sources of information. The website is just a lightweight more organized slice of what the community at large is doing. I would welcome any feedback you have, please remember this is a work in progress, and it was produced in the true- start up fashion- on a shoe string budget with a few people putting in very long hours. In particular I would like to thank Margaret Waters for all her hard work on this. If anyone in the community knows Joomla- or is interested in becoming a content producer on any section of the website- let me know and we can set you up with access to do so- in the true open source way! regards, Michele Kimpton Exec Director, DSpace Foundation - 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
[Dspace-tech] Job Announcement - java / perl programmer
*** Job Announcement *** Washington Research Library Consortium Digital Library Systems Developer (Programmer/Analyst) The Washington Research Library Consortium is a nonprofit technology organization providing innovative information services to academic libraries in the Washington, DC, metropolitan area. We are seeking a skilled developer to work on current and next-generation digital library systems. The programmer/analyst will provide software application design, development, documentation, implementation and maintenance in support of the WRLC ALADIN system, an integrated set of information services provided by commercial, open-source and custom applications. Required Qualifications: - Bachelor's degree in computer science or related technical discipline (additional relevant professional work experience may be substituted). - Three or more years of professional experience in the development, integration and maintenance of database-driven Web applications (a Master's or higher degree may be substituted for some work experience). - Development experience on Unix or Unix-like systems. - Development experience with an object-oriented programming language such as Java or C++. - Development experience with scripting languages such as Perl or PHP. - Familiarity with relational database design and SQL. - Demonstrated ability to craft creative solutions to problems and work independently. - Strong inter-personal and communication skills. Desired Qualifications: - Experience with open-source digital repository software such as DSpace. - Demonstrated skill in server-based Java programming. - Familiarity with XML and XML-based technologies (e.g. DOM, XSLT, XPath). - Experience designing and implementing Web services (e.g. SOAP, REST). - Experience with Web 2.0 technologies such as RDF, AJAX. - Experience or interest in digital library technologies and standards such as library management systems, MARC, Dublin Core, Z39.50 or SRU/W. - Experience developing Web applications with Apache open-source tools (httpd, Tomcat, Ant, Cocoon, Axis, Xalan, etc.). Salary: $60,000 - $75,000 depending on experience For additional information and application instructions see: http://www.wrlc.org/jobs/proganal.shtml - 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