Skip site navigation (1) Skip section navigation (2)

Re: ResultSetMetaData.getTableName() == null

From: Philip Yarra <philip(at)utiba(dot)com>
To: Alex Stienstra <alex(dot)stienstra(at)zonnet(dot)nl>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: ResultSetMetaData.getTableName() == null
Date: 2006-09-22 01:35:33
Message-ID: 45133DE5.4030100@utiba.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi Alex,

Alex Stienstra wrote:
> GetTableName() always returns null. Can someone tell me if this is 
> considered to be a problem and if so when it will be fixed.

Are you sure it's really null? According to the javadoc for 
ResultSetMetaData, getTableName() may return "" - see 
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/ResultSetMetaData.html#getTableName(int).

I did a quick test app, and the driver version I'm using 
(postgresql-8.1-404.jdbc3.jar) returns "". If you get different, tell me 
which driver version you're using and I'll try that.

I don't know why it returns "" - perhaps someone else can answer that. 
Mind you, Oracle 10g does the same. Sybase ASE 12.5 is the only DB I 
have access to where I get a non-empty table name.

Regards, Philip.

-- 
Philip Yarra
Senior Software Engineer, Utiba Pty Ltd
philip(at)utiba(dot)com

In response to

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2006-09-22 03:12:53
Subject: Re: ResultSetMetaData.getTableName() == null
Previous:From: Oliver JowettDate: 2006-09-21 21:41:18
Subject: Re: CachedRowSetXImpl() and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group