Re: [Geotools-devel] Moving EPSG factories from HSQL to H2

2009-06-09 Thread Andrea Aime
Justin Deoliveira ha scritto: >> 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

Re: [Geotools-devel] Moving EPSG factories from HSQL to H2

2009-06-09 Thread Andrea Aime
Christian Müller ha scritto: > > +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 a

Re: [Geotools-devel] Moving EPSG factories from HSQL to H2

2009-06-09 Thread Christian Müller
+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 solutio

Re: [Geotools-devel] Moving EPSG factories from HSQL to H2

2009-06-09 Thread Justin Deoliveira
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

Re: [Geotools-devel] Moving EPSG factories from HSQL to H2

2009-06-09 Thread Andrea Aime
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,

Re: [Geotools-devel] Moving EPSG factories from HSQL to H2

2009-06-09 Thread andrea antonello
[...] > 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 o

[Geotools-devel] Moving EPSG factories from HSQL to H2

2009-06-09 Thread Andrea Aime
Hi, yesterday I tried to apply Emily's patch that would upgrade our EPSG database to version 6.18: http://jira.codehaus.org/browse/GEOT-2493 Unfortunately I found a few show stoppers, the EPSG database started using the degree symbol extensively in axis directions, that symbol cannot be represente