[Geoserver-users] WFS on oracle spatial, filter encoding with Date

GeoServer GeoServer User
1

Hi everybody,

I am trying to request my geoserver WFS service which is connected to an oracle spatial layer.
I use Geoserver 1.3.4.

The request :

<?xml version="1.0" encoding="iso-8859-1"?>

<GetFeature outputFormat="GML2" xmlns:gml="http://www.opengis.net/gml&quot;&gt;

<Query typeName="topp:RCP_POSITION">

<Filter>

<PropertyIsEqualTo><PropertyName>POS_CFR_COD</PropertyName><Literal>FRA000919772</Literal></PropertyIsEqualTo>

</Filter>

</Query></GetFeature>

Works without problem, but the following request :

<?xml version="1.0" encoding="iso-8859-1"?>

<GetFeature outputFormat="GML2" xmlns:gml="http://www.opengis.net/gml&quot;&gt;

<Query typeName="topp:RCP_POSITION">

<Filter>

<And>

<PropertyIsEqualTo><PropertyName>POS_CFR_COD</PropertyName><Literal>FRA000924318</Literal></PropertyIsEqualTo>

<PropertyIsGreaterThanOrEqualTo><PropertyName>POS_DATE</PropertyName><Literal>2005-01-01T00:00:00.0</Literal></PropertyIsGreaterThanOrEqualTo>

</And>

</Filter>

</Query></GetFeature>

Answers :

<?xml version="1.0" ?>

<ServiceExceptionReport

   version="1.2.0"

   xmlns="http://www.opengis.net/ogc&quot;

   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;

   xsi:schemaLocation="http://www.opengis.net/ogc http://rhisib18:8080/geoserver/schemas//wfs/1.0.0/OGC-exception.xsd&quot;&gt;

   <ServiceException>

      null error:Translator error </ServiceException>

</ServiceExceptionReport>

My 'schema.xml' file for the request WFS layer contains :

...
<xs:element type = "xs:string" minOccurs = "1" name = "POS_CFR_COD" nillable = "false" maxOccurs = "1" />

<xs:element type = "xs:dateTime" minOccurs = "1" name = "POS_DATE" nillable = "false" maxOccurs = "1" />

<xs:element type = "xs:dec...

To make geoserver understand and deliver Dates and Times in the right format, I patched my server as recommended to fix one known bug (http://jira.codehaus.org/browse/GEOS-311).
But even if the date answer format has changed to something like 'YYYY-MM-DDTHH:MI:SS' nothing has changed for my request with Date Filter.

I really need that Date Filter option for my WFS service.
Please, do anyone know anything about it ?

Thanks,

Thomas

PS : Unfortunately, my web server is not publicly available.