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

Re: Missing fields in getColumns() result

From: Christian Schröder <cs(at)deriva(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Missing fields in getColumns() result
Date: 2007-12-23 23:15:44
Message-ID: (view raw or whole thread)
Lists: pgsql-jdbc
Hi list,
by now I have found two threads in the archive about this issue:

I have also seen the following entry in the "Todo" section on the driver
homepage: "[JDBC3] The JDBC 3 DatabaseMetaData methods sometimes return
additional information. Currently we only return JDBC 2 data for these

So the problem doesn't seem to be solved yet. I have implemented a patch
that specifically adds the "SOURCE_DATA_TYPE" field to the result of
"getColumns()". The other missing fields are added, but always have a
"null" value. I had to do changes to both the
AbstractJdbc2DatabaseMetaData and the AbstractJdbc3DatabaseMetaData
class, but I hope that I didn't break the JDBC 2 code. The test cases 
completed without errors.

It would be great if you could have a look at my proposed patch and
decide if you will include it into the CVS repository.


Deriva GmbH                         Tel.: +49 551 489500-42
Financial IT and Consulting         Fax:  +49 551 489500-91
Hans-Böckler-Straße 2        
D-37079 Göttingen

Deriva CA Certificate:

Attachment: diff
Description: text/plain (14.1 KB)

In response to


pgsql-jdbc by date

Next:From: Andrew LazarusDate: 2007-12-26 03:49:24
Subject: Re: concat returns null
Previous:From: Oliver JowettDate: 2007-12-22 21:28:41
Subject: Re: TypeInfoCache

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