Re: [Geotools-gt2-users] Exception querying Oracle-Datastore with Date-Attributee

[Jody G. <jga...@re...>]

Bleck - Oracle support is poor at best (there is a reason this module 
moved to "unsupported" for 2.4). Do you know the actual SQL function we 
should use for date?

Jody
> Hello,
>
> I got the following Exception quering an Oracle-Datastrore using a Datecolumn in the 2.3.1 Release in Geoserver Version 1.5.
>
> I think the Problem is that Oracle does not provide the date('2007-01-01')
> Function.
>
> Using the Oraclefunction to_date('2007-01-01','yyyy-mm-dd') may solve this Problem.
>
> - Tim
>
> Caused by: org.geotools.data.DataSourceException: Error Performing SQL query: SELECT "GEOLOC" FROM "MYTABLE" WHERE "SCHLIESSUNG" >= date('2007-01-01')
>         at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:937)
>         at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:669)
>         at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:78)
>         at org.geotools.data.crs.ForceCoordinateSystemFeatureResults.reader(ForceCoordinateSystemFeatureResults.java:123)
>         at org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:414)
>         ... 36 more
> Caused by: java.sql.SQLException: ORA-00936: Ausdruck fehlt
>
>         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
>         at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
>         at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
>         at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
>         at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1037)
>         at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
>         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
>         at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
>         at org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:926)
>         ... 40 more
>