Omitting a table schema name does not work because of
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.