Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

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