+1 for Derby where it is possible. It is integrated in SDK 6 and, to my surprise, even WebSphere 7 offers a Derby XA Data Source (doing 2 phase commits).
I think the long term support will be better too. Where we need a spatial extension, we could stay at H2 until there is a better solution. Justin Deoliveira writes: > Andrea Aime wrote: >> andrea antonello ha scritto: >>> [...] >>>> Opinions? I noticed GeoToolkit also ditched >>>> HSQL, but in favour of the Derby version that's >>>> shipping with the JDK. >>>> >>>> Opinions, preferences? >>>> >>>> I for one prefer H2, mostly because we're already >>>> using it extensively in GeoServer and GeoWebCache, >>>> and we have a JDBC datastore based on it. But that's >>>> just me, what do others prefer? >>> Hi Andrea, >>> same here for H2, we also use it a lot in JGrass and are going to >>> remove hsql. Derby would be cool since it is integrated but I don't >>> think there is a spatial effort on that? Is there? >> >> Nope, there is none. Actually the spatial effort on H2 is languishing >> as well, the author won't implement R-tree indexes for the moment and >> thus the datastore is stuck into doing full scans in memory everytime >> a spatial operator is used. > The current "plan" is to use geohash to spatialize H2. I did some > experimentation and its relatively easy to implement, although not as > effective as an R-Tree, but good in a lot of cases. > >> >> The best embedded spatial db today seems to be Spatialite, too bad >> it is native code, so it requires recompiling on various platforms, and >> there are also issues with its java bindings under OSX (or so I heard). > I more or less fixed these OSX issues. But the jdbc driver has a few > issues, I have submitted a patch which has been rolled in and its now > useable, but has some issues surrounding primary keys which i am working > on another patch for. It's on my TODO list to get it to releasable. >> >> Cheers >> Andrea >> > > > -- > Justin Deoliveira > OpenGeo - http://opengeo.org > Enterprise support for open source geospatial. > > ------------------------------------------------------------------------------ > Crystal Reports - New Free Runtime and 30 Day Trial > Check out the new simplified licensing option that enables unlimited > royalty-free distribution of the report engine for externally facing > server and web deployment. > http://p.sf.net/sfu/businessobjects > _______________________________________________ > Geotools-devel mailing list > Geotools-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
