Re: BUG #2559: why jdbc-driver AbstractJdbc2ResultSetMetaData.

On Tue, 1 Aug 2006, flash.xu wrote:

> Bug reference:      2559
> PostgreSQL version: 8.1.4
> Description:        why jdbc-driver AbstractJdbc2ResultSetMetaData.
> getTableName(int column)  return ""
> Details:
>
> I'm using jdbc3 8.1 to build my java project.But when I use
> ResultSetMetaData class to get table'name,the result is ""!
> I check the jdbc8 8.1's source code,and found the
> AbstractJdbc2ResultSetMetaData. getTableName(int column)  return "".
> Instead, the method of "getBaseTableName()" return the real table'name.
> Similar,the method of"getColumnName()"return the column'lable,but the method
> of"getColumnName()" return the real column'name.
> please show why?thanks.
> My project has been used Oracle and Mysql.It's my first to use  PostgreSQL.
>

Please see the thread "Wrong column names in ResultSetMetaData"

http://archives.postgresql.org/pgsql-jdbc/2004-08/threads.php#00008

Kris Jurka