Re: PreparedStatement.setBytes on OIDs - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: PreparedStatement.setBytes on OIDs
Date
Msg-id Pine.LNX.4.33.0302031311020.27245-100000@leary.csoft.net
Whole thread Raw
In response to PreparedStatement.setBytes on OIDs  (Bill Schneider <bschneider@vecna.com>)
List 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@postgresql.org
>


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: DatabaseMetaData oddities
Next
From: Kris Jurka
Date:
Subject: Re: bug in AbstractJdbc1Statement.java (7.3)