Fantastic news. I'll look to get the geometryless module into supported status around this - my only blocker at the moment is the lack of the functionality currently wrapped in sql-datastore (under 2.4 ./unsupported/community-schemas/sql-datastore) in JDBC. Gabriel did this work and I extended it to provide a little bit of dialect-flag driven handling of different date literal handling. My hope is that both of these extensions will be rendered superfluous by the new prepared statement handling design and dialect handling. Certainly I only need the dialect handling for Oracle, so I'd strongly suggest a good set of unit tests around date, time, timezones.
WARNING: There is a flag that Oracle can run under to determine the datatype of timestamps returned by JDBC - you need to handle both potential settings of this flag. [ -Doracle.jdbc.J2EE13Compliant=true] There is also a set of extensions under jdbc-regfunc which allow specific database functions to be exposed. IMHO These capabilities would be of general interest - there's many a potential JDBC datastore where you will want the ability to select specific columns, or do some joins across lookup tables. We've been put off proposing them as fixes to JDBC pending Jody's view that H2 work will supercede it. Gabriel is familiar with the code, so would be the best person to comment specifically, but if people want us to try to roll it in and create patches and proposal then we can schedule that - but IMHO it would be best if it were considered up front and the capabilities supported without the need for a patch. Rob A On Fri, Aug 29, 2008 at 2:52 AM, Jody Garnett <[EMAIL PROTECTED]> wrote: > That is great news Andrea :-) > > This makes me very happy - and congratulations to OpenGeo for getting > this much needed work written up as a contract. I always love to see > people paid to do the important work. >> This is eventually going to grow, we should probably create a >> module group around the new jdbc base class, something like: >> - jdbc-ng >> - jdbc-core (base classes and base tests) >> - jdbc-h2 (h2 datastore) >> - jdbc-mysql (experimental mysql replacement) >> - jdbc-oracle (oracle replacement) >> >> Suggestions, opinions? >> > Just a quick comment on the above; the module gt-data currently contains > a few of the super > classes for the h2 module; looks like they should be folded into > jdbc-core and the gt-data module removed. > > Christian Mueller has reported a problem using gt-mysql and gt-h2 at the > same time. Apparently there is a collision on the package names (perhaps > a mysql experiment already developed inside gt-h2?) Do you know if this > is resolved (or even on Justin's radar as a problem?). > > So with that in mind how does the following sounds: > - ensure that that package names do not conflict during the transition > - perhaps we can have them both respond to the same connection > parameters; with the addition of an "experiment=true" to choose between > them? > - Can I ask (at least for the new DataStore) that the constructor be > limited to package visible > > When it is time to retire the old we can remove the old implementation; > anyone using DataStoreFinder and connection parameters will be no be > effected. > Cheers, > I imagine we can talk about events and shared test cases when the time > comes. > > Jody > > > ------------------------------------------------------------------------- > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/geotools-devel > ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
