Re: More JDBC questions in 6.3

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