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

[Tim E. <Tim...@gm...>]

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
-- 
"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail