Weird!
This method was added in 1.4.1 to fix a problem with bound parameters in the
SQL queries. It converts the dates and times given into SQL Timestamp
objects, so that these can be bound to the queries (for security - it helps
stop SQL injection attacks).
A couple of things to check on each server:
Are the versions of postgres the same?
Are the dates the same?
Are the timezones the same?
It would be interesting if you put some debug in there to see what the
values are getting set to in the timestamp objects. My guess is they will be
correct, but somehow they are not getting passed correctly to postgres, or
postgres isn't handling them correctly.
I know when I wrote this method I had problems getting it to work until the
following line was added:
df.setCalendar(Calendar.getInstance(TimeZone.getTimeZone("UTC")));
So it might be a timezone issue.
Stuart
On 9/2/07 20:00, "Jose Blanco" <[EMAIL PROTECTED]> wrote:
> I found the problem.
>
> It seems like the routine toTimestamp in Harvest.java was screwing things
> up. By not using it, the sql completes successfully. But the strange thing
> is that it works fine in our dev environment. It seems like I'm missing
> something in our prod to get this routine to do its thing. Any thoughts?
>
> Thanks!
>
> -----Original Message-----
> From: Stuart Lewis [sdl] [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 09, 2007 4:10 AM
> To: Jose Blanco; [email protected]
> Subject: RE: [Dspace-tech] dspace-oai not returnning records
>
> Hi Jose,
>
> All configuration for the OAI-PMH interface is in
> [dspace]/config/oaicat.properties. However there is not much in there
> that normally needs changing and could stop it working.
>
> Have you got some URLs we could look at?
>
> 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
> _________________________________________________________________
>
>
> ________________________________
>
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jose
> Blanco
> Sent: 08 February 2007 22:10
> To: [email protected]
> Subject: [Dspace-tech] dspace-oai not returnning records
>
>
>
> I recently upgraded to 1.4.1 and now it seems like ListRecords is not
> working in production, but it is in my dev. It must be some config
> change I missed. Any one have something obvious they think I should
> check?
>
>
>
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech