Hi, one of our clients experienced this problem. The new OAICAT version* does not solve this problem*. In attachment, you could see a patch to apply over the dspace-oai source:
$ cd [DSPACE-SOURCE] $ patch -p0 < [PATH-TO]/patch-dspace-oai-oracle-db.diff It is a workaround, but it works. I think, as OAICAT does not solve this problem, this patch could be applied to the new DSpace version ( https://jira.duraspace.org/browse/DS-1195). PS - You will need to package (mvn) and update (ant) your DSpace. On 18 June 2012 12:29, Domingo Iglesias <[email protected]> wrote: > Hi > > I'm migrating our dspace installation from 1.6.2 to 1.8.2. The test > environment is tomcat and oracle based. > When testing oai, I have found that date handling does not work [to > me]. For instance, a request such > > http://repository_hostname/oai/request?verb=ListRecords&set=hdl_123456789_3521&metadataPrefix=oai_dc > reports the following lines in dspace.log > > 2012-06-18 10:45:38,969 DEBUG org.dspace.app.oai.PluginCrosswalk @ > Initialized schemaLabel=ore with schemaLocation = > "http://www.w3.org/2005/Atom > http://tweety.lanl.gov/public/schemas/2008-06/atom-tron.sch"; > 2012-06-18 10:45:38,976 INFO org.dspace.app.oai.DSpaceOAICatalog @ > > anonymous:no_context:oai_request:verb=listRecords,from=0001-01-01T00\colon;00\colon;00Z,until=9999-12-31T23\colon;59\colon;59Z,set=hdl_123456789_3521,metadataPrefix=oai_dc > 2012-06-18 10:45:39,515 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "select * from HANDLE where handle = ? " with > parameters: 123456789/3521 > 2012-06-18 10:45:39,728 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "select * from COLLECTION where COLLECTION_ID = ? " > with parameters: 341 > 2012-06-18 10:45:39,734 DEBUG org.dspace.content.Collection @ > anonymous::find_collection:collection_id=341 > 2012-06-18 10:45:39,749 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "select * from ITEM where ITEM_ID = ? " with > parameters: 4403 > 2012-06-18 10:45:39,753 DEBUG org.dspace.content.Item @ > anonymous::find_item:item_id=4403 > 2012-06-18 10:45:39,754 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "SELECT * FROM Handle WHERE resource_type_id = ? AND > resource_id = ?" with parameters: 2,4403 > 2012-06-18 10:45:39,767 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "select * from EPERSONGROUP where EPERSON_GROUP_ID = ? > " with parameters: 443 > 2012-06-18 10:45:39,769 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "select * from EPERSONGROUP where EPERSON_GROUP_ID = ? > " with parameters: 442 > 2012-06-18 10:45:39,770 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "select * from EPERSONGROUP where EPERSON_GROUP_ID = ? > " with parameters: 444 > 2012-06-18 10:45:39,772 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "SELECT * FROM Handle WHERE resource_type_id = ? AND > resource_id = ?" with parameters: 3,341 > 2012-06-18 10:45:39,773 DEBUG org.dspace.handle.HandleManager @ > Resolved handle 123456789/3521 to collection 341 > 2012-06-18 10:45:39,775 DEBUG org.dspace.search.Harvest @ > anonymous::harvest SQL:SELECT DISTINCT handle.handle, > handle.resource_id, item.withdrawn, item.last_modified FROM handle, > item, collection2item WHERE handle.resource_type_id=2 AND > handle.resource_id=item.item_id AND collection2item.collection_id= ? > AND collection2item.item_id=handle.resource_id AND item.last_modified > >= ? AND item.last_modified <= ? ORDER BY handle.resource_id > 2012-06-18 10:45:39,775 DEBUG org.dspace.storage.rdbms.DatabaseManager > @ Running query "SELECT DISTINCT handle.handle, handle.resource_id, > item.withdrawn, item.last_modified FROM handle, item, collection2item > WHERE handle.resource_type_id=2 AND handle.resource_id=item.item_id > AND collection2item.collection_id= ? AND > collection2item.item_id=handle.resource_id AND item.last_modified >= > ? AND item.last_modified <= ? ORDER BY handle.resource_id" with > parameters: 341,0001-01-01 01:00:00.0,10000-01-01 00:59:59.999 > 2012-06-18 10:45:39,777 WARN org.dspace.app.oai.DSpaceOAICatalog @ > anonymous::database_error: > java.sql.SQLException: Year out of range. > at > oracle.jdbc.driver.DateCommonBinder.setOracleCYMD(OraclePreparedStatement.java:19241) > at > oracle.jdbc.driver.TimestampBinder.bind(OraclePreparedStatement.java:19520) > at > oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:3137) > at > oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2355) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3579) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628) > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) > at > org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:284) > at org.dspace.search.Harvest.harvest(Harvest.java:195) > at > org.dspace.app.oai.DSpaceOAICatalog.doRecordHarvest(DSpaceOAICatalog.java:564) > at > org.dspace.app.oai.DSpaceOAICatalog.listRecords(DSpaceOAICatalog.java:445) > at > ORG.oclc.oai.server.verb.ListRecords.construct(ListRecords.java:180) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at ORG.oclc.oai.server.OAIHandler.getResult(OAIHandler.java:383) > at ORG.oclc.oai.server.OAIHandler.doGet(OAIHandler.java:292) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) > at > org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877) > at > org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594) > at > org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675) > at java.lang.Thread.run(Thread.java:662) > > > Do you know if there is any patch or workaround for that? > > Thanks in advance > > > > --- > Domingo Iglesias > Universitat de Barcelona > Area de Tecnologies > > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech >
patch-dspace-oai-oracle-db.diff
Description: Binary data
------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
