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

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

pgsql-interfaces by date

Next:From: Constantin TeodorescuDate: 1998-12-28 19:05:38
Subject: Help getting PostgreSQL data from Applix through ODBC
Previous:From: Warren CraigDate: 1998-12-28 17:18:40
Subject: unsubscribe

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