Re: ResultSet internal data type handling - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: ResultSet internal data type handling
Date
Msg-id 4A0936F1.3010005@opencloud.com
Whole thread Raw
In response to ResultSet internal data type handling  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-jdbc
Luca Ferrari wrote:
> Having a look at jdbc2.AsbtractJDBC2ResultSet (the parent of all ResultSets) I
> discovered that all data received from the server is handled internally as a
> string (right?) and is converted from the getXXX methods into the appropriate
> type. This means that you can actually write a getString on a date field
> obtaining a valida date (and if you are lucky you can do something the
> opposite). I'm curious to know if this is an implementation choice or a jdbc
> specification and why the objects are not checked against the table metadata
> (as the getInternalObject method does).

There's a table in the JDBC spec that lists the basic type conversions
that a JDBC driver must support. Most types can be converted to strings,
from memory.

-O

pgsql-jdbc by date:

Previous
From: John Lister
Date:
Subject: Re: ResultSet internal data type handling
Next
From: Joe Kramer
Date:
Subject: Re: [GENERAL] Unable to access table named "user"