[Geotools-devel] JDBC-NG: making primary key lookup more flexible

2009-12-03 Thread Andrea Aime
Hi, recently I've had a few requests to make primary key lookup more flexible in JDBC-NG datastores, and finally I've got someone that could be interested in sponsoring some improvements (provided they stay inside a small budget). The current code uses a set of heuristics to find out what a pk is

Re: [Geotools-devel] JDBC-NG: making primary key lookup more flexible

2009-12-03 Thread Justin Deoliveira
I wonder if we really need an interface? Could we just roll support for a primary key metadata table into the regular lookup chain? What sorts of alternative strategies might be used? Not against the idea, I like the design but like to avoid adding abstractions unless its necessary. A few

Re: [Geotools-devel] JDBC-NG: making primary key lookup more flexible

2009-12-03 Thread Christian Müller
A big +1 for interface or base class,I think a base class would be fine. @Justin, asfaik , DB2 does not allow underlines in table names. I am not a friend of such default assumptions. @Andrea, look at http://jira.codehaus.org/browse/GEOT-2015, it would be a good idea to have an additional

Re: [Geotools-devel] JDBC-NG: making primary key lookup more flexible

2009-12-03 Thread Andrea Aime
Christian Müller ha scritto: A big +1 for interface or base class,I think a base class would be fine. @Justin, asfaik , DB2 does not allow underlines in table names. I am not a friend of such default assumptions. DB2 does not allow for underscore? Odd? @Andrea, look at

Re: [Geotools-devel] JDBC-NG: making primary key lookup more flexible

2009-12-03 Thread Justin Deoliveira
Andrea Aime wrote: Justin Deoliveira ha scritto: I wonder if we really need an interface? Could we just roll support for a primary key metadata table into the regular lookup chain? What sorts of alternative strategies might be used? I'm not sure actually, but someone might not want to

[Geotools-devel] [jira] Created: (GEOT-2877) Implement all test cases for MySQL, SQLServer, and SQLite

2009-12-03 Thread Justin Deoliveira (JIRA)
Implement all test cases for MySQL, SQLServer, and SQLite - Key: GEOT-2877 URL: http://jira.codehaus.org/browse/GEOT-2877 Project: GeoTools Issue Type: Task Reporter:

Re: [Geotools-devel] JDBC-NG: making primary key lookup more flexible

2009-12-03 Thread Christian Müller
Yep, I am First, I meant DB2 does not allow an underscore as the first character of a table name. Sorry. Second, I talked only about meta information. About Sequences: The method public String getSequenceForColumn(String schemaName, String tableName, String columnName, Connection cx)

Re: [Geotools-devel] JDBC-NG: making primary key lookup more flexible

2009-12-03 Thread Andrea Aime
Christian Müller ha scritto: Yep, I am First, I meant DB2 does not allow an underscore as the first character of a table name. Sorry. Second, I talked only about meta information. About Sequences: The method public String getSequenceForColumn(String schemaName, String tableName,

Re: [Geotools-devel] JDBC-NG: making primary key lookup more flexible

2009-12-03 Thread Christian Müller
Yep, Deal :-) Andrea Aime writes: Christian Müller ha scritto: Yep, I am First, I meant DB2 does not allow an underscore as the first character of a table name. Sorry. Second, I talked only about meta information. About Sequences: The method public String

Re: [Geotools-devel] ND Coverage-api on unsupported

2009-12-03 Thread Jody Garnett
A coverage (such as provided by the NetCDF format) that has more then row/col/band information. Often used to capture raster information that changes over time, or changes over height (forming a volume of voxels). Does that mean that changes of time form chronxels? In anycase you get the idea,

Re: [Geotools-devel] ND Coverage-api on unsupported

2009-12-03 Thread Chris Holmes
See also http://docs.codehaus.org/display/GEOTOOLS/Multidimensional+Grid+Motivation+and+Scope Jody Garnett wrote: A coverage (such as provided by the NetCDF format) that has more then row/col/band information. Often used to capture raster information that changes over time, or changes over

Re: [Geotools-devel] ND Coverage-api on unsupported

2009-12-03 Thread Michael Bedward
+1 for Nixel :-) Thanks very much for that link Chris. I'd love to see this work go forward. From a purely selfish point of view my own projects rely on this type of grid data. Michael -- Join us December 9, 2009 for

Re: [Geotools-devel] ND Coverage-api on unsupported

2009-12-03 Thread Andrea Aime
Jody Garnett ha scritto: A coverage (such as provided by the NetCDF format) that has more then row/col/band information. Often used to capture raster information that changes over time, or changes over height (forming a volume of voxels). Does that mean that changes of time form chronxels?

Re: [Geotools-devel] ND Coverage-api on unsupported

2009-12-03 Thread Simone Giannecchini
Ciao Michael, sorry for the late answer, what Jody provided you with is a nice description of what we are trying to achieve. One clarification though, as you can see from slide number 19 here: http://www.slideshare.net/geosolutions/geosolutions-foss4g-2009-redux what we are trying to achieve

Re: [Geotools-devel] ND Coverage-api on unsupported

2009-12-03 Thread Simone Giannecchini
Ciao Michael, of course your input would be valuable. What should we do in order to ease your job on this and get feedback from you? Documentation/Examples/? I would also like to see, in time of course, feedback from the other dev and psc who are/might be interested (ciao gabriel :-) ). Simone.