ParameterMetaData getPrecision() always zero?

From: Simon Temple <simon(dot)temple(at)amalto(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: ParameterMetaData getPrecision() always zero?
Date: 2010-01-28 09:58:51
Message-ID: 3CF1F297-BA57-4725-830E-DD282228A284@amalto.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Driver: postgresql-8.4-701.jdbc4
Server: 8.4
OS: Mac OSX

<snip>
ParameterMetaData m = stat.getParameterMetaData( );

if ( null != m ) {

int colWidth = m.getPrecision( parameterIndex );

// colWidth == 0 means 'not applicable'
if ( colWidth > 0 ) {
<snip>

I have the same behaviour with many different tables.

For varchar columns I would expect to get the maximum column width. So 8 for a varchar(8).

I always get zero as a result.

I get non zero values from H2 and Derby drivers.

Is this a bug or have I missed something?

TIA

Simon Temple

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Wolfgang Rinnert 2010-01-28 18:52:28 Re: java.net.SocketException: Network is unreachable
Previous Message Craig Ringer 2010-01-28 04:12:04 Re: Add XATMI C API