[Geoserver-users] Date format for Oracle 10g wfs

GeoServer GeoServer User
1

Hi all,

I’m using a GS1.6.0RC3 over tomcat 5.5.25 and jdk 1.5.
I’m trying this update request to an Oracle 10g featuretype with a DATE column.
The problem is that it’s not updating the column properly.
I’ve tried all the xsd:Date formats I known.
This is the xml to update my featuretype:

<wfs:Transaction service=“WFS” version=“1.0.0”
xmlns:topp=“http://www.openplans.org/topp”
xmlns:ogc=“http://www.opengis.net/ogc”
xmlns:wfs=“http://www.opengis.net/wfs”>
<wfs:Update typeName=“topp:GS_TEST”>
wfs:Property
wfs:NameD_FROM</wfs:Name>
wfs:Value2008-02-12</wfs:Value>
</wfs:Property>
ogc:Filter
<ogc:FeatureId fid=“GS_TEST.4”/>
</ogc:Filter>
</wfs:Update>
</wfs:Transaction>

The answer to my request is:
<wfs:WFS_TransactionResponse version=“1.0.0” xsi:schemaLocation=“http://www.opengis.net/wfs http://localhost:8080/geoserver6/schemas/wfs/1.0.0/WFS-transaction.xsd”>
wfs:InsertResult
<ogc:FeatureId fid=“none”/>
</wfs:InsertResult>
wfs:TransactionResult
wfs:Status
wfs:FAILED/
</wfs:Status>
wfs:Message
org.geotools.data.DataSourceException: SQL Exception writing geometry columnORA-01861: el literal no coincide con la cadena de formato
</wfs:Message>
</wfs:TransactionResult>
</wfs:WFS_TransactionResponse>

Is it a bug or do I failed the format for date column (I’ve tried lots of formats)??

Thank you in advance.

Regards,

Paddy

2

Patrick O'Brian ha scritto:

Hi all,

I'm using a GS1.6.0RC3 over tomcat 5.5.25 and jdk 1.5.
I'm trying this update request to an Oracle 10g featuretype with a DATE column.
The problem is that it's not updating the column properly.
I've tried all the xsd:Date formats I known.
This is the xml to update my featuretype:

<wfs:Transaction service="WFS" version="1.0.0"
  xmlns:topp="http://www.openplans.org/topp&quot;
  xmlns:ogc="http://www.opengis.net/ogc&quot;
  xmlns:wfs="http://www.opengis.net/wfs&quot;&gt;
  <wfs:Update typeName="topp:GS_TEST">
    <wfs:Property>
      <wfs:Name>D_FROM</wfs:Name>
      <wfs:Value>2008-02-12</wfs:Value>
    </wfs:Property>
    <ogc:Filter>
      <ogc:FeatureId fid="GS_TEST.4"/>
    </ogc:Filter>
  </wfs:Update>
</wfs:Transaction>

The answer to my request is:
<wfs:WFS_TransactionResponse version="1.0.0" xsi:schemaLocation="http://www.opengis.net/wfs http://localhost:8080/geoserver6/schemas/wfs/1.0.0/WFS-transaction.xsd&quot;&gt;
    <wfs:InsertResult>
        <ogc:FeatureId fid="none"/>
    </wfs:InsertResult>
    <wfs:TransactionResult>
        <wfs:Status>
           <wfs:FAILED/>
        </wfs:Status>
        <wfs:Message>
           org.geotools.data.DataSourceException: SQL Exception writing geometry columnORA-01861: el literal no coincide con la cadena de formato
         </wfs:Message>
     </wfs:TransactionResult>
</wfs:WFS_TransactionResponse>

Is it a bug or do I failed the format for date column (I've tried lots of formats)??

It's a bug in the oracle datastore. Can you create a bug report (or, in
jira jargon, an issue) here?
http://jira.codehaus.org/browse/GEOS

Cheers
Andrea