Re: [BUGS] BUG #2559: why jdbc-driver AbstractJdbc2ResultSetMetaData.

2006-08-04 Thread Kris Jurka



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#8

Kris Jurka


---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match


[BUGS] BUG #2559: why jdbc-driver AbstractJdbc2ResultSetMetaData. getTableName(int column) return ""

2006-08-02 Thread flash.xu

The following bug has been logged online:

Bug reference:  2559
Logged by:  flash.xu
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system:   fc5
Description:why jdbc-driver AbstractJdbc2ResultSetMetaData.
getTableName(int column)  return ""
Details: 

hello:
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.

I'm come from china,and sorry for my pool English.

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq