Re: [PATCHES] Anoter JDBC Error

Aaron,

To answer one question about what getFixedString is doing there,
everything from the server is a string, (except binary values) integers,
floats, longs, dates, etc.

As far as the getInteger(9) goes this is quite likely a bug.

Dave
On Sat, 2002-10-19 at 19:36, Aaron Mulder wrote:
>     Ahh, never mind.  I tried again a few minutes later, and got the
> new behavior, which is to say a SQLException.  But I don't
> understand why this is happening.  Here's what I'm doing:
>
>     I create the database "test" (in my PG 7.2.2 DB) with a table with
> 3 columns, all integers.  I connect using the JDBC3 driver, get a
> connection, get the databasemetadata, call
>
>     dbmd.getColumns("test",null,"tablename","%");
>
>     I get back a ResultSet.  Column 9 is an integer column,
> DECIMAL_DIGITS.  If I call getObject, it tries to get an Integer object,
> so even the ResultSet thinks it's an integer column.  However, the result
> of getString/getFixedString used for new Integer(getFixedString()) is
> apparently an empty String, causing the SQLException due to a badly
> formatted Integer value.
>
>     So now I'm confused.  What's an empty String doing in an integer
> column when (if you believe the logic in getFixedString) the value was not
> null?  Is this broken null handling?  Test program and results attached...
>
> Aaron
>
> import java.sql.*;
>
> public class PostgresTest{
>     public static void main(String args[]) {
>         try {
>             Class.forName("org.postgresql.Driver");
>             Connection con =
> DriverManager.getConnection("jdbc:postgresql://localhost/test", "test",
> "password");
>             DatabaseMetaData dmd = con.getMetaData();
>             ResultSet rs = dmd.getColumns("test", null, "tablename", "%");
>             rs.next();
>             System.out.println("Col 9: "+rs.getInt(9)); // getObject(9)
>             rs.close();
>             con.close();
>         } catch(Exception e) {
>             e.printStackTrace();
>         }
>     }
> }
>
>
> Bad Integer
>     at
> org.postgresql.jdbc1.AbstractJdbc1ResultSet.toInt(AbstractJdbc1ResultSet.java:708)
>     at
> org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:148)
>     at PostgresTest.main(PostgresTest.java:12)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>