Christian Müller ha scritto: Hum, no subject? I added one.
> Since I need the db2 plugin I tested the following: > 1) Duplicate all classes from org.geotools.data.mysql, renaming MySql* > to DB2*. > 2) Adapting the classes and tests for DB2 Spatial Extender > 3) Copy DB2SqlEncoder from David > Now I am tried to run the tests. 90% of them result in failures or > errors. Some first investigations > resulted in the 2 following bugs. > GEOT-1991 > GEOT-1992 You did not chose a component, are they supposed to be issues for H2 module or the existing db2 one? > There are some other issues like the method wirteLiteral(..) which has > no handling for Date, Timestamp and so on. I'd suggest you avoid getting crazy with these and say in the dialect that you use prepared statemetns, the jdbc driver will do the rest. (of course you'll have to override a few more methods, see the oracle dialect for some examples). > The next issue is that there is no DB2PrepeardFilterToSQL class. These > encodings are rather complex, e.g using > a line wkb param needs the following sql expression > db2gse.st_linefromwkb(CAST(? as BLOB(2G),srid) Well, you can just override the method that encodes the literals with a special case when it's a geometry. I don't see the issue? > Conclusion: > I think there is something to do. The question is if I should > investigate further to migrate Davids db2 module in the > new structure (which has the advantage of the test suite) or should I > stop ?. I don't see any reason to stop if you have time > A matter of fact is that at the moment my customer has some problems > using the db2 module with geoserver, GEOT-1992 > is one of the reasons. > Whats your opinion ? To fix the sql encoder in the existing db2 module, the new one needs some more love before you can have a customer use it (not production ready in my opinion). Cheers Andrea ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
