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?
Date: Mon, 28 Dec 1998 08:51:24 -0800
Message-ID: <199812281651.IAA20929@ssm-office.antrim.com> (raw)
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
-------------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ssm@antrim.com, peter@retep.org.uk
Subject: Re: [INTERFACES] JDBC ResultSetMetaData.getColumnType and getColumnTypeName work properly?
In-Reply-To: <199812281651.IAA20929@ssm-office.antrim.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox