Hi Keith, Any chance you could install this patch, and try again:
http://sourceforge.net/tracker/index.php?func=detail&aid=1659868&group_id=19 984&atid=319984 The patch gives better database debugging, as it replaces the '?' in the log file with the actual values given. We can then see the actual queries being run, and you can try them by hand to see what is being returned. Thanks, Stuart _________________________________________________________________ Gwasanaethau Gwybodaeth Information Services Prifysgol Cymru Aberystwyth University of Wales Aberystwyth E-bost / E-mail: [EMAIL PROTECTED] Ffon / Tel: (01970) 622860 _________________________________________________________________ On 6/6/07 20:20, "Keith Jones" <[EMAIL PROTECTED]> wrote: > > Thanks for the additional input. I turned on debug and here is what > output I am getting in the log file. > > 2007-06-06 14:47:48,393 INFO org.dspace.app.oai.DSpaceOAICatalog @ > anonymous:no > _context:oai_request:verb=listIdentifiers,from=0001-01-01T00:00:00Z,until=9999 > -1 > 2-31T23:59:59Z,set=null,metadataPrefix=oai_dc > 2007-06-06 14:47:49,008 DEBUG org.dspace.search.Harvest @ > anonymous::harvest SQL > :SELECT handle.handle, handle.resource_id, item.withdrawn, > item.last_modified FR > OM handle, item WHERE handle.resource_type_id=2 AND > handle.resource_id=item.item > _id AND item.last_modified >= ? AND item.last_modified <= ? ORDER BY > handle.r > esource_id > 2007-06-06 14:47:49,009 DEBUG org.dspace.storage.rdbms.DatabaseManager @ > Running > query "SELECT handle.handle, handle.resource_id, item.withdrawn, > item.last_modi > fied FROM handle, item WHERE handle.resource_type_id=2 AND > handle.resource_id=it > em.item_id AND item.last_modified >= ? AND item.last_modified <= ? > ORDER BY h > andle.resource_id" > 2007-06-06 14:47:49,782 INFO org.dspace.app.oai.DSpaceOAICatalog @ > anonymous:no > _context:oai_error:no_items_match > > > > On Wed, 6 Jun 2007, Stuart Lewis [sdl] wrote: > >> Hi Jodi / Keith, >> >>> However this request returns error code="badArgument". >>> http://dspace.udel.edu:8080/dspace-oai/request?verb=ListIdentifiers >> >> The 'badArgument' occurs because you need to specify which format you want >> the metadata in. >> >> So the following works: >> >> http://dspace.udel.edu:8080/dspace-oai/request?verb=ListIdentifiers&metadata >> Prefix=oai_dc >> >> However.... This still suffers from the problem of no records being returned >> when no dates are specified. >> >> As you have noticed, if you add a 'from' records are returned. (Not so if >> you just add a 'to'). >> >> What should be happening, is OAICat passes a 'null' for 'to' and 'from' to >> org.dspace.search.Harvest.java If it receives null values, it should not do >> any date filtering on the select query. Something must be going wrong here. >> To debug this, we need to see what queries are being run. >> >> Can you: >> >> 1) Upgrade your logging output to DEBUG (change 'INFO' to 'DEBUG' in >> [dspace]/conf/log4j.properties an then restart tomcat). >> >> 2) Watch you [dspace]/log/dspace.log file as you call the ListIdentifiers >> URL which is returning an empty result set. >> >> The debug output should show the output that OAICat is passing to >> Harvest.java, and should show the corresponding query that Harvest.java >> calls. >> >> If you can send these to the list, we can look into the problem further. >> >> 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 >> _________________________________________________________________ >> >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by DB2 Express >> Download DB2 Express C - the FREE version of DB2 express and take >> control of your XML. No limits. Just data. Click to get it now. >> http://sourceforge.net/powerbar/db2/ >> _______________________________________________ >> DSpace-tech mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/dspace-tech >> ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
