Re: PreparedStatement.setBytes on OIDs

From: Kris Jurka <books(at)ejurka(dot)com>
To: Bill Schneider <bschneider(at)vecna(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: PreparedStatement.setBytes on OIDs
Date: 2003-02-03 18:20:53
Message-ID: Pine.LNX.4.33.0302031311020.27245-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


The problem is that the driver doesn't know the underlying storage format
for the column. The driver would have to parse your SQL statement, query
the server's meta data for the various columns, and then determine what
method to use. This is not going to happen.

Kris Jurka

On Mon, 3 Feb 2003, Bill Schneider wrote:

> Is there any way it is possible to make AbstractJdbc1Statement.setBytes work
> on both bytea and oid columns? I found the "compatible" switch to revert
> behavior so that the method can be used with oid columns, but I'd hate to
> give up the bytea functionality to keep setBytes working with oids. IMO
> there should be some way to get setBytes to work on both simultaneously.
>
> What are other users' thoughts on this? Is this something that could be
> solved with a small patch or would this feature require a significant
> redesign of the driver?
>
> -- Bill
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2003-02-03 19:18:23 Re: bug in AbstractJdbc1Statement.java (7.3)
Previous Message Kris Jurka 2003-02-03 18:00:11 Re: DatabaseMetaData oddities