Postgres Pro
Downloads
Home   >   mailing lists

Re: ResultSet metadata for a prepared statement missing the applicable table, schema etc properties - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: ResultSet metadata for a prepared statement missing the applicable table, schema etc properties
Date
Msg-id 506AF9B1.4060209@ringerc.id.au
Whole thread Raw
In response to ResultSet metadata for a prepared statement missing the applicable table, schema etc properties  (the6campbells <the6campbells@gmail.com>)
Responses JDBC change log needs updating for Version 9.2-1000
List pgsql-jdbc
Tree view 
On 09/24/2012 11:30 PM, the6campbells wrote:
> If you create a PreparedStatement such as select c1 from t1 and
> subsequently request the ResultSetMetadata for that statement you will
> observe that the driver is not providing any values for getTableName,
> getSchemaName etc.
>
> Is this a known bug?

Any chance of fleshing this one out with a test case / sources? Again I
can write one, but the best thing to do is submit some new (failing)
unit tests for PgJDBC that demonstrate the problem, or at least a
runnable standalone test case. Everyone working on the JDBC driver is a
badly swamped volunteer (including myself, not that I've done much on
the driver yet) so any time saved on testcase writing etc is time that
can be spent on compliance/bugs.

--
Craig Ringer

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: data set combination of integer and decimal/numeric returns wrong result type
Next
From: Craig Ringer
Date:
Subject: Re: DatabaseMetadata.getTypeInfo resultset returns more than just Postgres/user defined data types