my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes getTables schema question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "getTables schema question" Watch "getTables schema question" New topic

getTables schema question

Paul Bergin

Joined: Sep 27, 2002
Posts: 2
hope you can help me out.
I have written a tool which can connect to different databases via JDBC or ODBC, it has been working perfectly till now.
The problem I am having is retrieving tables for a specific schema/view.
Up to now I have been using the userid (which the user connects to the db with) as the schema name,
DatabaseMetaData.getTables(catalog, schema, tableNamePattern, types)
but I now have client who uses the ODBC name to identify the schema, so my question is,
Which is more commonly used to identify a schema, userid or ODBC name.
If I was to get get a list of the schemas with
and compare user name and odbc name to the list of schemas, if both appeared in the scheam list, which would normally take priority?
I agree. Here's the link:
subject: getTables schema question
It's not a secret anymore!