From: | Peter T Mount <pmount(at)maidast(dot)demon(dot)co(dot)uk> |
---|---|
To: | "Schlough, Mark" <Mark(dot)Schlough(at)nmb(dot)norwest(dot)com> |
Cc: | pgsql-interfaces(at)postgresql(dot)org, java-linux-help(at)java(dot)blackdown(dot)org |
Subject: | Re: More JDBC questions in 6.3 |
Date: | 1998-03-06 21:48:15 |
Message-ID: | Pine.LNX.3.95.980306214709.12835A-100000@maidast |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Fri, 6 Mar 1998, Schlough, Mark wrote:
> ---------my other questions----------------
>
> I am using the book "JDBC Database Access with Java" and after
> using
> some of the examples, (available for download from
> http://www.javasoft.com/products/jdbc/book.html) I run into
> problems.
> I'm wondering if these methods are supported by the driver:
>
> The questions so far seem to deal with ResultSetMetaData
>
> I am having trouble getting it to return the datatypes, such as
> VARCHAR, INTEGER, FLOAT,....
>
> code snip ----- 8-< ----
>
> ResultSetMetaData rsmd
>
> int columns = rsmd.getColumnCount();
> for (int i = 1; i<= columns; i++) {
>
> int jdbcType = rsmd.getColumnType(i)
> String name = rsmd.getColumnTypeName(i)
> System.out.print("Column "+1+" is JDBC type " + jdbcType);
> System.out.print(", which the DBMS calls " + name);
> }
>
> code snip ----- 8-< ----
>
> the code runs, but I get results like:
>
> Column 1 is JDBC type 12. which the DBMS calls null
> Column 2 is JDBC type 4. which the DBMS calls null
> Column 3 is JDBC type 8. which the DBMS calls null
> Column 4 is JDBC type 4. which the DBMS calls null
>
> does anyone know if these ResultSetMetaData methods that look at
> the
> datatypes are supposed to work, or are they not implemented?
>
> If they are supposed to work, could someone help me figure out what
> I
> am missing.
>
> Thanks in advance
>
> Mark
I'll check the current source to make sure nothing is broken, but this is
supported (and has been for quite some time)
--
Peter T Mount petermount(at)earthling(dot)net or pmount(at)maidast(dot)demon(dot)co(dot)uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1998-03-07 11:19:28 | JDBC FAQ |
Previous Message | The Hermit Hacker | 1998-03-06 20:09:26 | Re: [INTERFACES] Solarix 2.x shared libraries... |