CSW / ISOMetadataStore (SQL): GetRecords request fails

[MrSnyder]

I am experiencing issues requesting records from a CSW with ISOMetadataStore (SQL). Tables have been created (see #531), but no records have been inserted yet.

Request:

http://localhost:8080/deegree-webservices/services/csw?service=CSW&request=GetRecords&version=2.0.2&typenames=gmd:MD_Metadata&outputformat=text/xml&resultType=results

Response:

<?xml version='1.0' encoding='UTF-8'?>
<ows:ExceptionReport xmlns:ows="http://www.opengis.net/ows" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/ows http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd" version="1.2.0">
  <ows:Exception exceptionCode="InvalidParameterValue">
    <ows:ExceptionText>Error while performing "results" on the metadata: "null".</ows:ExceptionText>
  </ows:Exception>
</ows:ExceptionReport>

Not 100% sure if my request is correct, but it works on demo.deegree.org:

Request:

http://demo.deegree.org:80/csw-workspace/services?service=CSW&request=GetRecords&version=2.0.2&typenames=gmd:MD_Metadata&outputformat=text/xml&resultType=results

Environment:

• deegree 3.4-pre17
• Ubuntu 14.04 LTS (AMD64)
• PostgreSQL 9.3 / PostGIS 2.1 (packaged)
• OpenJDK 7 (packaged)

As far as I understand what you have done (created tables but did not insert any records), it seems reasonable, that there are no records within the response. But you are right, there should be simply an empty getrecordsresponse instead of an exception.
SInce deegree is only implementing OGC CSW and not compliant, this might be indeed an issue with deegree's CSW implementation.

[MrSnyder]

It seems that the problem is indeed related to the SQL-ISOMetadataStore. The request works after I change my configuration to use a Memory-ISOMetadataStore.