deegree / deegree3

Official deegree repository providing geospatial core libraries, data access and advanced OGC web service implementations
https://www.deegree.org
GNU Lesser General Public License v2.1
146 stars 99 forks source link

CSW / ISOMetadataStore (SQL): Transaction request fails #534

Open MrSnyder opened 9 years ago

MrSnyder commented 9 years ago

I am experiencing issues inserting records into a CSW with ISOMetadataStore (SQL). Tables have been created (see #531).

I am using cURL and the insert example from the CSW demo [1]:

wget --post-file=csw_transaction.xml --header="Content-Type: application/xml" -O /tmp/complex_insert.xml http://localhost:8080/deegree-webservices/services/csw

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="NoApplicableCode">
    <ows:ExceptionText>Error while performing "results" on the metadata: "Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented.".</ows:ExceptionText>
  </ows:Exception>
</ows:ExceptionReport>

Environment:

[1] https://raw.githubusercontent.com/deegree/deegree3/master/deegree-workspaces/deegree-workspace-csw/src/main/webapp/WEB-INF/workspace/manager/requests/csw/examples/Transaction/xml/complex_insert.xml

MrSnyder commented 9 years ago

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