Christian Müller ha scritto: > After creating a feature store (I tested for DB2), geoserver is showing the > possible feature candidates. > It seems that the geotools method > > SQLDialect: > public boolean includeTable(String schemaName, String tableName, Connection > cx) > > is never called.
It definitely is. Otherwise I would see "geometry_columns" as a table to import every time I connect to a PostGIS database. To make sure I've put GS in debug mode and tried listing the tables in a postgis database to create a new layer, the method was called a lot of times. > Additionally, this makes problems for db2 stores without a db schema name, > because all existing views and tables are listed (about 500 in my case, > without the schema name, so duplicate entries are possible). > > Creating a feature based on the candidates results in a sql exception > afterwards, because the schema name is not encoded in the sql string. > > The question is: Is a jdbc-ng data store capable of handling multiple > schemas. I think not. It might well not be. We don't have any test for a schema less situation. I consider this a bug and it should be solved, though at the moment I have no time to work on it. But I'll be happy to review patches . Cheers Andrea -- Andrea Aime OpenGeo - http://opengeo.org Expert service straight from the developers. ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
