Re: JDBC metadata for columns doesn't include table name
Posted by: Mark Matthews
Date: November 10, 2005 02:50AM

Fred Romelfanger wrote:
> I have the following code that I was having
> problems with
>
> ResultSet rs = md.getColumns(null, null,
> null, null);
> while(rs.next()) {
> final String tableName =
> rs.getString("TABLE_NAME");
> if(tableName == null) {
> System.out.println("column with no
> table name");
> continue;
> }
>
> getTables() works fine and returns the table name,
> but trying to get all of the columns and
> then matching them up with the tables isn't
> working out becuase none of the columns appear
> to have table names. The jdbc documentation
> indicates that getColumns() should return
> the table name.
>
> Any ideas other than getting the columns
> individually by table name?
>
> This code works fine with the Sybase JDBC driver.


Looks like a bug. I'll file a bug and get this fixed.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote


Subject
Written By
Posted
Re: JDBC metadata for columns doesn't include table name
November 10, 2005 02:50AM


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.