Date: Mon, 28 Dec 1998 08:51:24 -0800
Message-Id: <199812281651.IAA20929@ssm-office.antrim.com>
From: "Shankha S. Mitra" <ssm@antrim.com>
To: Peter T Mount <peter@retep.org.uk>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] JDBC ResultSetMetaData.getColumnType and
	getColumnTypeName work properly?
In-Reply-To: <Pine.LNX.4.04.9812281349360.1522-100000@maidast.retep.org.uk>
References: <36848562.83920B1D@antrim.com>
	<Pine.LNX.4.04.9812281349360.1522-100000@maidast.retep.org.uk>

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.
 > 
 > > 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
-------------------------------------------------------------------