Hello Andrea, hello Jody, I habe found a problem in the OracleDatastore when I try to query a Date-Column. I got an Oracle-Exception. I take a look at the use SQL-Stament an saw that there is used the function date(...) inteatd of to_date() which is unknown in Oracle DBMS. It is not possible to create this Function in the Oracle DBMS because it is an protected keyword.
So I take a look at the Sourcecode and noticed that the Method org.geotools.filter.SQLEncoder.visit(LiteralExpression expression) has to be modified to work with Oracle. I think about creating an Extention of SQLEncoder for the OracleDatastore which pays attention to the specific Syntax of Oracle. When I looked at the JDBC1Datastore I noticed that there is an Method called getSqlBuilder(...). I think we have to override it in the OracleDataStore an put there the Extention of SQLEncoder to the SqlBuilder. Am I right? - Tim Tim Englich Dipl.-Ing. (FH) Geoinformatik Information Logistics IVU Traffic Technologies AG Bundesallee 88, D-12161 Berlin Telefon: +49.30.85 906-387, Telefax +49.30.85 906-499 mailto: [EMAIL PROTECTED], http: //www.ivu.de ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
