Re: [INTERFACES] JDBC ResultSetMetaData.getColumnType and getColumnTypeName work properly? - Mailing list pgsql-interfaces

From Peter T Mount
Subject Re: [INTERFACES] JDBC ResultSetMetaData.getColumnType and getColumnTypeName work properly?
Date
Msg-id Pine.LNX.4.04.9812281840340.2134-100000@maidast.retep.org.uk
Whole thread Raw
In response to Re: [INTERFACES] JDBC ResultSetMetaData.getColumnType and getColumnTypeName work properly?  ("Shankha S. Mitra" <ssm@antrim.com>)
List 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@antrim.com
> Principal Software Engineer                   ph: (+1) 831.430.4814
> Antrim Design Systems                        fax: (+1) 831.430.1904
> Scotts Valley, CA
> -------------------------------------------------------------------
>

--
       Peter T Mount peter@retep.org.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


pgsql-interfaces by date:

Previous
From: Warren Craig
Date:
Subject: unsubscribe
Next
From: Constantin Teodorescu
Date:
Subject: Help getting PostgreSQL data from Applix through ODBC