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 18:46:11
Message-ID: Pine.LNX.4.04.9812281840340.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.

Ah, just checked my JDK2 html docs, and yes, ARRAY does exist. Figures
that the SUN produced paperback of all the API's doesn't show it :-(

Anyhow, at this precise moment, I'm downloading Cygwin B20.1 so I have
GNU-Make available. That way I can tie in the Makefile ready for working
on the JDBC2 version of the driver.

> 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.
> >
> > > Shankha Mitra
> > >
> > >
> > > As an aside, I decided to print out the values of all the JDBC types and
> > > I get:
> > > ARRAY=2003
> >
> > In JDBC2 2003 equates to the new value Types.REF (atleast in my copy of
> > the documentation), and there is no ARRAY type.
> >
> > What JDK are you using? Looking at these values, 2000 and higher are
> > introduced in 1.2 so they will not yet be supported.
> >
> > Currently JDK2 (formerly 1.20 is not supported. I'm about to start work on
> > this today - having to revert to Win95 to do it though :-( )
> >
>
> --
> -------------------------------------------------------------------
> Shankha S. Mitra shankha(at)antrim(dot)com
> Principal Software Engineer ph: (+1) 831.430.4814
> Antrim Design Systems fax: (+1) 831.430.1904
> Scotts Valley, CA
> -------------------------------------------------------------------
>

--
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 Constantin Teodorescu 1998-12-28 19:05:38 Help getting PostgreSQL data from Applix through ODBC
Previous Message Warren Craig 1998-12-28 17:18:40 unsubscribe