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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech