table schema handling does not work
-----------------------------------
Key: GEOT-1208
URL: http://jira.codehaus.org/browse/GEOT-1208
Project: GeoTools
Issue Type: Bug
Components: data db2
Reporter: Christian Mueller
Omitting a table schema name does not work because of
DB2SpatialCatalog.loadCatalog
builds an SQL Statement
String queryGeom = "SELECT table_schema, table_name, column_name, "
+ " type_name, srs_id" + " FROM db2gse.st_geometry_columns"
+ " WHERE table_schema = '" + schemaName + "' ";
If no Name is given the where Condition resolves to "where
table_schema='null'". I think using the userid would fix this.
The next problem is using lower case letters in the schema name because DB2
stores the names as uppercase. Automatically converting
would resolve this problem.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
