Re: Diffrence between 8.0.3 and 8.1.3 - Mailing list pgsql-jdbc

On Mon, 3 Jul 2006, Yann PICHOT wrote:

> I use this JDBC Driver :
> JDBC driver build number : 8.1.407-JDBC3
> Server version : test do on 8.0.3 (linux), 8.1.3 (linux) and 8.1.2 (windows)
>
> I have problem with the method getColumnDisplaySize in ResultSetMetaData
> class.
>
>       String SQLselect = "SELECT col1, cast(' ' as varchar(3)) as mycol
> FROM mytable";
>       stmt = conn.createStatement();
>       ResultSet res = stmt.executeQuery(SQLselect);
>       ResultSetMetaData resMD = res.getMetaData();
>       System.out.println(resMD.getColumnDisplaySize(2));
>
> When i connect to 8.0.3 database the methode getColumnDisplaySize return 3,
> a good value
> When i connect to 8.1.2 or 8.1.3 database the methode getColumnDisplaySize
> return -5, a bad value.
>

I cannot reproduce this with a 8.1.4 database and nothing in the
8.1.3 -> 8.1.4 release notes suggest that this behavior should have
changed.  Are you sure you're exactly describing your test, jdbc driver,
and server versions?

Kris Jurka