Re: [Dspace-tech] OAI-PMH and Oracle

Michael Judd Wed, 14 Mar 2007 15:46:37 -0800

Hi Rafa,
We're using Oracle here and have recently passed the OAIster validation tests.
When I compare our...

config/template/oaicat.properties
src/org/dspace/search/Harvest.java
src/org/dspace/app/oai/DSpaceOAICatalog.java
src/org/dspace/app/oai/OAIDCCrosswalk.java

...files to the current subversion trunk, the only difference worth mentioning is the patch I submitted a few days ago. Even without the patch you shouldn't be seeing an Oracle error.
Maybe you could try doing a diff to the current subversion trunk on the above files and check for typos or something. I noticed in your earlier email...

>>> AbstractCatalog.granularity=YYYY-MM--DDThh:mm:ssZ to

...which contains an extra hyphen after the MM. Maybe it's just something like that.
Good luck!

Regards,

Michael Judd

Nathan Campus, Griffith University.
Brisbane 4111. Australia.

[EMAIL PROTECTED]
07 3735 3801

[EMAIL PROTECTED] wrote: -----

To: "Rafa" <[EMAIL PROTECTED]>
From: "Stuart Lewis [sdl]" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
Date: 03/14/2007 07:57PM
cc: [email protected]
Subject: Re: [Dspace-tech] OAI-PMH and Oracle

Hi Rafa,

AbstractCatalog.granularity is used by the OAICAT toolkit which we use to generate the OAI-PMH responses. However it seems that it only affects the YYYY-MM-DD in the Identify response. It does not affect the datestamps in other verb responses.

The way I read it, the spec does not specify whether if you set the granularity to YYY-MM-DD all responses must be in to the same granularity. So it seems that either oaicat is wrong, OAIster is wrong, or the spec does not specify, in which case we are all right! :)

I have sent an email to the OAI-implementers list to get some guidance.

In the mean time, I'm afraid I've not got access to Oracle at present so I can't look into the ORA-01858 error.

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: Rafa [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2007 13:08
To: Stuart Lewis [sdl]
Cc: [email protected]
Subject: Re: [Dspace-tech] OAI-PMH and Oracle

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&g
> roup_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]>,
>> 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=D
>>> E 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=DE
>> V
>> 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

-------------------------------------------------------------------------
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

Re: [Dspace-tech] OAI-PMH and Oracle

Reply via email to