Thread: More JDBC questions in PG6.3

More JDBC questions in PG6.3

From
"Schlough, Mark"
Date:
Does anyone have an example of how this feature works?  I'm
still reasonably new to JDBC and I want to get this working
properly.  I'm at a loss of how to implement the driver
differently than I already have.  Any and all help is
appreciated.

Basically I am trying to get the ResultSetMetaData to work.
(See the code snippet below)

[Please CC your reply to mtschlou@cloudnet.com]

Thanks

Mark

______________________________ Reply Separator
_________________________________
Subject: Re: More JDBC questions in 6.3
Author:  Peter T Mount [SMTP:pmount@maidast.demon.co.uk]  at NMB
Date:    3/6/98 3:48 PM


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)

If you have some sample code to test this please let me know, If there
is code in the release that I am too blind to see then let me know too

Re: More JDBC questions in PG6.3

From
Peter T Mount
Date:
On Wed, 11 Mar 1998, Schlough, Mark wrote:

> Does anyone have an example of how this feature works?  I'm
> still reasonably new to JDBC and I want to get this working
> properly.  I'm at a loss of how to implement the driver
> differently than I already have.  Any and all help is
> appreciated.
>
> Basically I am trying to get the ResultSetMetaData to work.
> (See the code snippet below)
>
> [Please CC your reply to mtschlou@cloudnet.com]

Actually I've found it, there was a small bug in postgresql.Field where
the type name wasn't getting stored (hence the null). I'm building a small
patch for this and another fix which will be posted tonight.

--
Peter T Mount  petermount@earthling.net or pmount@maidast.demon.co.uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk