Re: PreparedStatement.getMetaData() and Creator

From: Kris Jurka <books(at)ejurka(dot)com>
To: Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu>
Cc: postgres jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: PreparedStatement.getMetaData() and Creator
Date: 2004-07-29 18:23:46
Message-ID: Pine.BSO.4.56.0407291307090.9250@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 29 Jul 2004, Jeremiah Jahn wrote:

> >We just tested postgresql in house and found that the driver is
> >returning null for PreparedStatement.getMetaData()
>

It may be possible to do that now. Previously PreparedStatements were
implemented by doing the substitution on the driver side and sending the
full query to the backend, so the only way to get the metadata was to
actually run the query. With the new V3 protocol support it seems
possible to issue Parse and Describe messages without issuing Bind or
Execute.

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-07-29 21:33:23 Re: Bug in 7.4_213 driver: returns VARCHAR instead of
Previous Message Mike Martin 2004-07-29 17:45:32 Re: Wrong column names in ResultSetMetaData