pg703: support for Large objects via JDBC PreparedStatement.setBi naryStream()

From: Julian Richardson <JRichardson(at)softwright(dot)co(dot)uk>
To: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: pg703: support for Large objects via JDBC PreparedStatement.setBi naryStream()
Date: 2001-03-20 14:49:32
Message-ID: 07E0E649A9C3D411A80A0020350804BD1763F2@exch002.softwright.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi all,

maybe this one's been asked before but I've just found this list (if it's
archived & searchable someplace then let me know)

I just installed Postgres 7.0.3 the other day (Redhat 7.0) and was trying to
insert binary data into the DB via JDBC using the standard
PreparedStatement.setBinaryStream() method, but the JDBC driver wasn't
having any of it. Taking a look at the source code shows it as not being
implemented yet, at least in the drivers I have.

I didn't study the code in detail but it looked like there's stuff missing
in the Large Objects API too, so it may not even be possible to use that as
an alternative (I'd rather not anyway, but may have been able to make the
setBinaryStream method call into it behind the scenes to do the work)

Is there a workaround for this (or preferably a fix for the drivers!!) - or
does it work in pg6.5 as downgrading may be an option?

cheers,

Jules

ps. posted a variation on this to the pgsql-bugs list the other day but
don't know if it got through - hopefully this one will.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter T Mount 2001-03-20 15:10:25 Re: pg703: support for Large objects via JDBC PreparedStatement.setBi naryStream()
Previous Message Peter T Mount 2001-03-20 14:37:17 Re: get the query created by PreparedStatement