Bug in Date format for WFS over Oracle 10g datastore
----------------------------------------------------
Key: GEOS-1742
URL: http://jira.codehaus.org/browse/GEOS-1742
Project: GeoServer
Issue Type: Bug
Components: Oracle
Affects Versions: 1.6.0
Environment: Windows 2000, jdk 1.5.x, Tomcat 5.5.25
Reporter: Patrick O'brian
Assignee: Andrea Aime
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: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">
<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>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira