Re: [INTERFACES] JDBC ResultSetMetaData.getColumnType and getColumnTypeName work properly?

From: "Shankha S(dot) Mitra" <ssm(at)antrim(dot)com>
To: Peter T Mount <peter(at)retep(dot)org(dot)uk>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] JDBC ResultSetMetaData.getColumnType and getColumnTypeName work properly?
Date: 1998-12-28 16:51:24
Message-ID: 199812281651.IAA20929@ssm-office.antrim.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)antrim(dot)com
Principal Software Engineer ph: (+1) 831.430.4814
Antrim Design Systems fax: (+1) 831.430.1904
Scotts Valley, CA
-------------------------------------------------------------------

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Warren Craig 1998-12-28 17:18:40 unsubscribe
Previous Message Peter T Mount 1998-12-28 13:56:46 Re: [INTERFACES] JDBC ResultSetMetaData.getColumnType and getColumnTypeName work properly?