Hi Janna,
These are indeed bugs that need to be resolved. We've created tracker items
for both issues:
https://fedora-commons.org/jira/browse/FCREPO-481
https://fedora-commons.org/jira/browse/FCREPO-482<https://fedora-commons.org/jira/browse/FCREPO-481>
It looks like we should be able to squeeze a fix for FCREPO-482 into the 3.2
release as there is no good work-around for that issue.
Thanks for reporting these.
Bill
On Wed, Apr 15, 2009 at 7:14 PM, Janna Wemekamp <[email protected]>wrote:
> G'day,
>
> (1) Fedora's search functions fail with the following error if the pid
> column isn't requested as part of the result set:
>
> javax.ws.rs.WebApplicationException:
> fedora.server.errors.StorageDeviceException: Error with sql database. The
> column name pid was not found in this ResultSet.
>
> This is true of the 'search' web interface and the REST API.
>
> Eg.
>
> http://localhost:8080/fedora/objects?title=true&identifier=true&terms=&query=pid~demo%3A*&maxResults=20
>
>
> http://localhost:8080/fedora/search?title=true&identifier=true&terms=&query=pid~demo%3A*&maxResults=20
>
> (2) The REST API's 'findObjects' method will not return the 'format'
> column.
>
> Eg.
>
> http://localhost:8080/fedora/objects?format=xml&maxResults=9999999&pid=true&title=true&identifier=true&creator=true&subject=true&description=true&publisher=true&contributor=true&date=true&type=true&format=true&source=true&language=true&relation=true&coverage=true&rights=true&query=pid%3Duuid%3A2d9c3eaa-1f30-11de-a002-37af095b5cfc
> and
>
> http://localhost:8080/fedora/objects?format=html&maxResults=9999999&pid=true&title=true&identifier=true&creator=true&subject=true&description=true&publisher=true&contributor=true&date=true&type=true&format=true&source=true&language=true&relation=true&coverage=true&rights=true&query=pid%3Duuid%3A2d9c3eaa-1f30-11de-a002-37af095b5cfc
>
> do not return the 'format' column even though it has values in the
> database.
>
> Removing the 'format=xml' parameter returns something of type 'text/true'
> which looks like xml but isn't treated as such by the browser (FF3) and
> can't be parsed as xml. However it does contain the format values!
>
> This bug is a performance nuisance since the only way to retrieve ALL the
> DC values (via the REST API) is to use the 'getDatastreamDissemination'
> method. According to some quick tests, this is roughly 3 times slower than a
> direct query on the database using 'findObjects'.
>
>
> Janna
>
>
> ------------------------------------------------------------------------------
> Stay on top of everything new and different, both inside and
> around Java (TM) technology - register by April 22, and save
> $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
> 300 plus technical and hands-on sessions. Register today.
> Use priority code J9JMT32. http://p.sf.net/sfu/p
> _______________________________________________
> Fedora-commons-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
>
>
------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Fedora-commons-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
