Hi, Unfortunately, it doesn´t work for me. Seems that it has no effect since I get the same ORA-01858 error. The strange thing is that the harvesting works well when I set the granularity of the system from YYYY-MM-DDTHH:MM:SSZ to YYYY-MM-DD. It seems that the problem is in the "time" part of the timestamp. What's the connection between the property AbstractCatalog.granularity (oaicat.properties file) and this error? I've been looking into the code in Harvest.java and other files, but I can´t see the exact place where is this property read.
Thanks, Rafa Stuart Lewis [sdl] escribió: > Hi Rafa, > > A patch has just been uploaded by Michael Judd which might solve your > problem, could you give it a go? > > https://sourceforge.net/tracker/?func=detail&atid=319984&aid=1678708&group_id=19984 > > Thanks, > > > Stuart > _________________________________________________________________ > > Datblygydd Cymwysiadau'r We Web Applications Developer > Gwasanaethau Gwybodaeth Information Services > Prifysgol Cymru Aberystwyth University of Wales Aberystwyth > > E-bost / E-mail: [EMAIL PROTECTED] > Ffon / Tel: (01970) 622860 > _________________________________________________________________ > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rafa > Sent: 12 March 2007 08:38 > To: [email protected] > Subject: Re: [Dspace-tech] DSpace-tech Digest, Vol 11, Issue 28 > > Hi, > > Dspace 1.4.1. > > Thanks > > > [EMAIL PROTECTED] escribió: > >> Send DSpace-tech mailing list submissions to >> [email protected] >> >> To subscribe or unsubscribe via the World Wide Web, visit >> https://lists.sourceforge.net/lists/listinfo/dspace-tech >> or, via email, send a message with subject or body 'help' to >> [EMAIL PROTECTED] >> >> You can reach the person managing the list at >> [EMAIL PROTECTED] >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of DSpace-tech digest..." >> >> >> Today's Topics: >> >> 1. Re: OAI-PMH and Oracle (Stuart Lewis [sdl]) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Sat, 10 Mar 2007 21:16:51 +0000 >> From: "Stuart Lewis [sdl]" <[EMAIL PROTECTED]> >> Subject: Re: [Dspace-tech] OAI-PMH and Oracle >> To: Rafa <[EMAIL PROTECTED]>, <[email protected]> >> Message-ID: <[EMAIL PROTECTED]> >> Content-Type: text/plain; charset="ISO-8859-1" >> >> Hi Rafa, >> >> Which version of DSpace do you use? The reason I ask is that the code >> which generates the relevant SQL query for your OAI-PMH request >> changed dramatically between 1.3.* and 1.4, and I don't know what >> tests were run on the 1.4 version (there was a small bug which slipped >> through with the postgres version of date handling in OAI-PMH which >> got fixed in 1.4.1, so a similar small bug may have slipped through the net >> with Oracle). >> >> If you can tell me, then we can look into finding the problem. My >> guess would be the method in Harvest.java which converts datestamps for the >> SQL. >> >> Thanks, >> >> >> Stuart >> _________________________________________________________________ >> >> Datblygydd Cymwysiadau'r We Web Applications Developer >> Gwasanaethau Gwybodaeth Information Services >> Prifysgol Cymru Aberystwyth University of Wales Aberystwyth >> >> E-bost / E-mail: [EMAIL PROTECTED] >> Ffon / Tel: (01970) 622860 >> _________________________________________________________________ >> >> On 6/3/07 08:29, "Rafa" <[EMAIL PROTECTED]> wrote: >> >> >> >>> Hi, >>> >>> testing dspace-oai my dspace does something strange. It works with >>> some particular verbs such as Identify, ListSets or Listmetada, but >>> not with GetRecord or ListRecords. When I try these two I get an >>> Oracle error >>> (ORA-01858 - a non-numeric character was found where a numeric was >>> expected). But, if I modify the granularity in >>> [dspace]/config/oaicat.properties (via >>> [dspace]/config/templates/oaicat.properties) from >>> AbstractCatalog.granularity=YYYY-MM--DDThh:mm:ssZ to >>> AbstractCatalog.granularity=YYYY-MM-DD it works well! What's the >>> problem then? Just when I try to make my dspace pass the oaister >>> register tests, it informs that the granularity isn?t correct: >>> >>> 'Datestamp in GetRecord response (2007-02-21T10:17:00Z) is not >>> consistent with the days granularity specified in the Identify response' >>> >>> >>> >>> Any idea? TIA >>> >>> >>> Rafa Carreres >>> University of Alicante >>> Spain >>> >>> >>> >>> --------------------------------------------------------------------- >>> ---- Take Surveys. Earn Cash. Influence the Future of IT Join >>> SourceForge.net's Techsay panel and you'll get the chance to share >>> your opinions on IT & business topics through brief surveys-and earn >>> cash >>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DE >>> VDEV _______________________________________________ >>> DSpace-tech mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/dspace-tech >>> >>> >> >> >> ------------------------------ >> >> ---------------------------------------------------------------------- >> --- Take Surveys. Earn Cash. Influence the Future of IT Join >> SourceForge.net's Techsay panel and you'll get the chance to share >> your opinions on IT & business topics through brief surveys-and earn >> cash >> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEV >> DEV >> >> ------------------------------ >> >> _______________________________________________ >> DSpace-tech mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/dspace-tech >> >> >> End of DSpace-tech Digest, Vol 11, Issue 28 >> ******************************************* >> >> > > > -- Rafael Carreres Paredes. | [EMAIL PROTECTED] | [EMAIL PROTECTED] Área UNIX. | http://www.ua.es/es/servicios/si/ Servicio de Informática. | +34-965903400 [ext] 2925 Universidad de Alicante. | +34-965903499 Ctra. San Vicente s/n. Apdo.99, 03080 Alicante. Spain. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
