Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-22 Thread christian . mueller
Some clarifications. DB2 makes also makes an access plan, but for one statement, you have different access plans for different distribution statistics. A simple example having a table with some indexes. If the table is populated with 50 rows, no index will be used, if it is populated with 1

Re: [Geotools-devel] Nominate Matthew Birks for GeoTools commit access

2010-06-22 Thread v...@csiro
+1 -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Nominate-Matthew-Birks-for-GeoTools-commit-access-tp5211671p5211688.html Sent from the geotools-devel mailing list archive at Nabble.com. -- Th

Re: [Geotools-devel] [ExternalEmail] Nominate Matthew Birks for GeoTools commit access

2010-06-22 Thread Ben Caradoc-Davies
+1 On 23/06/10 11:45, rini.angre...@csiro.au wrote: > I nominate my colleague Matthew Birks for GeoTools commit access. > He will only commit with module maintainers approvals. > He has already fixed one bug in app-schema, that I reviewed and committed: > http://jira.codehaus.org/browse/GEOS-3807

[Geotools-devel] Nominate Matthew Birks for GeoTools commit access

2010-06-22 Thread Rini.Angreani
I nominate my colleague Matthew Birks for GeoTools commit access. He will only commit with module maintainers approvals. He has already fixed one bug in app-schema, that I reviewed and committed: http://jira.codehaus.org/browse/GEOS-3807

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-22 Thread Andrea Aime
christian.muel...@nvoe.at ha scritto: > Puuh, a long mail, I will try to keep it short. > > 1) Each db engine has its own optimizer, DB2 as an example has a cost > based optimizer (not rule based) using indices based on distribution > statistics. Creating an and index for a char(1) field havi

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-22 Thread christian . mueller
Puuh, a long mail, I will try to keep it short. 1) Each db engine has its own optimizer, DB2 as an example has a cost based optimizer (not rule based) using indices based on distribution statistics. Creating an and index for a char(1) field having values "Y" and "N" will have no sense, DB

Re: [Geotools-devel] 2.7-M1 available for download

2010-06-22 Thread Jody Garnett
Okay corrected project file ready to go (includes process module so source code will compile). Jody On 22/06/2010, at 4:37 PM, Jody Garnett wrote: > On 22/06/2010, at 10:28 AM, Jody Garnett wrote: > >> - I think demo depends on process; and process is not in the build since it >> is an unsuppo

[Geotools-devel] [jira] Created: (GEOT-3156) Filtering multi-valued properties of nested features doesn't work

2010-06-22 Thread Rini Angreani (JIRA)
Filtering multi-valued properties of nested features doesn't work - Key: GEOT-3156 URL: http://jira.codehaus.org/browse/GEOT-3156 Project: GeoTools Issue Type: Bug R

Re: [Geotools-devel] [Geoserver-devel] H2 version upgrade

2010-06-22 Thread Andrea Aime
Gabriel Roldan ha scritto: > Hi all and sorry for cross-posting. > > I'd like to propose upgrading the version of h2database in the trunk > poms (both geoserver and geotools) to a newer version than the one > currently used. > > Situation is we've inadvertently been shipping geoserver with two

[Geotools-devel] H2 version upgrade

2010-06-22 Thread Gabriel Roldan
Hi all and sorry for cross-posting. I'd like to propose upgrading the version of h2database in the trunk poms (both geoserver and geotools) to a newer version than the one currently used. Situation is we've inadvertently been shipping geoserver with two h2 jars, h2-1.1.104.jar and h2-1.1.119.j

[Geotools-devel] [jira] Created: (GEOT-3155) 'geography' spatial column type not supported in SQL Server 2008

2010-06-22 Thread Shaun Forbes (JIRA)
'geography' spatial column type not supported in SQL Server 2008 Key: GEOT-3155 URL: http://jira.codehaus.org/browse/GEOT-3155 Project: GeoTools Issue Type: Bug Compo

Re: [Geotools-devel] Parametric SQL views, this time for good

2010-06-22 Thread Andrea Aime
christian.muel...@nvoe.at ha scritto: > Some thoughts from my side. > > 1) Using a regexp to avoid sql injection is a nice idea. But I think > most developers are not familiar with regexps and thus, the regexp > mostly used will be ".*" opening the door for all kind of sql > injection attacks.

Re: [Geotools-devel] 2.7-M1 available for download

2010-06-22 Thread Andrea Aime
Jody Garnett ha scritto: > On 22/06/2010, at 10:28 AM, Jody Garnett wrote: > >> - I think demo depends on process; and process is not in the build since it >> is an unsupported module - so I expect the source download could not be >> built if you were offline > > Confirmed this issue on a fresh

Re: [Geotools-devel] 2.7-M1 available for download

2010-06-22 Thread Jody Garnett
On 22/06/2010, at 10:28 AM, Jody Garnett wrote: > - I think demo depends on process; and process is not in the build since it > is an unsupported module - so I expect the source download could not be built > if you were offline Confirmed this issue on a fresh box; I will include process in the

Re: [Geotools-devel] postgis st_asbinary(shape)

2010-06-22 Thread Andrea Aime
v...@csiro ha scritto: > I was thinking somewhere along the line of: > > String sql = "select id, st_asbinary(shape) as shape from geology.table "; > ResultSet p = postgis.createStatement().executeQuery(sql); > PreparedStatement s = oracle.prepareStatement("update table set

Re: [Geotools-devel] Updating DBCP to version 1.3

2010-06-22 Thread Andrea Aime
Jody Garnett ha scritto: > +1 for upgrading. > > Are we going to have trouble with the difference between 1.3 and 1.4; > or do we need a java5 and java 6 profile (auto enabled) to contribute > the appropriate dependency? I suggest we don't, there is enough difference between a java 5 and java 6 b