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. 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. For DB2, if the db schema is missing, the schema is the name of the current user in uppercase. I could enforce this fact in the db2 data store implementation, but would it help ?. ------------------------------------------------------------------------------ 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
