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: Pine.LNX.4.04.9812281928130.2134-100000@maidast.retep.org.uk (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group