OracleDataStore.getTypeNames() returns non accessible tables
------------------------------------------------------------
Key: GEOT-719
URL: http://jira.codehaus.org/browse/GEOT-719
Project: GeoTools
Type: Bug
Components: oraclespatial
Versions: 2.2.M0
Reporter: Paolo Rizzi
Assigned to: Sean Geoghegan
Fix For: 2.2.M1
When I issue a getTypeNames() on a OracleDataStore connectyed to my Oracle
instance
I got back more than 1300 table names, most of which are system tables, so they
should
not be considered proper FeatureTypes.
Also if I try to do something on most of these tables, like a getSchema(), I
got an Oracle error:
ORA-00942: table or view does not exist
because these tables are not accessible with their plane names, bot only with a
prefix such as "MDSYS."
I'm not an Oracle expert but if a issue a:
SELECT * from USER_CATALOG
I got back a small list of tables, with all my proper FeatureTypes, plus a few
other system tables
with a "$" in their name.
So, instead of letting getTypeNames() get it's list from
Connection.getMetaData(),
why don't we use the USER_CATALOG table instead???
--
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
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
