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

Re: [INTERFACES] JDBC ResultSetMetaData.getColumnType and getColumnTypeName work properly?

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: "Shankha S(dot) Mitra" <ssm(at)antrim(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] JDBC ResultSetMetaData.getColumnType and getColumnTypeName work properly?
Date: 1998-12-28 19:32:34
Message-ID: (view raw or whole thread)
Lists: pgsql-interfaces
On Mon, 28 Dec 1998, Shankha S. Mitra wrote:

> Aah, that explains it.  I'm using JDK 1.2 beta4 (which I guess _is_ now
> JDK 2.0).  THe JDBC in JDK 2.0 does have ARRAY, etc.
> Thanks for the reply.
> Shankha
> Peter T. Mount writes:
>  > Yes, there is no constant of Types.ARRAY in JDBC (see below). The
>  > implementation sets the type to OTHER if it doesn't recognise it.
>  > 
>  > > Also getColumnTypeName() returns _int4; is that correct?
>  > 
>  > no, it should return String - will check.

I think the int4 is what it's translating the postgresql type as. I've not
tried Arrays with JDBC yet, but I think we can fix this when we implement

       Peter T Mount peter(at)retep(dot)org(dot)uk
      Main Homepage:
PostgreSQL JDBC Faq:
 Java PDF Generator:

In response to

pgsql-interfaces by date

Next:From: Stan BrownDate: 1998-12-28 20:48:05
Subject: Can;t connect to db with pgaccess
Previous:From: Constantin TeodorescuDate: 1998-12-28 19:05:38
Subject: Help getting PostgreSQL data from Applix through ODBC

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