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: Pine.LNX.4.04.9812281928130.2134-100000@maidast.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
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
ARRAY.

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf

In response to

Browse pgsql-interfaces by date

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