catalog versus schema
Posted by:
tonu
Date: January 31, 2007 05:58AM
I found: "...since MySQL does not support the concept of a database catalog..."
in system tables are columns catalog, but in all tables I looked was null.
=> catalogs are not supported yet
calling method getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types):
- if i write for catalog null => resultset return tables which are in the current schema, not all tables which are from this schema visible
- if i write for CATALOG another schema name then default, it returns only tables from that shema (there is only curious that to catalog name i write name of schema)
- if i write name of schema to parameter schemaPattern, it seems to be ignored
Do I understand it right that in getTables are parameters schema and catalog exchanged?
Subject
Written By
Posted
catalog versus schema
January 31, 2007 05:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.