Skip site navigation (1) Skip section navigation (2)

RE: jdbc large object support ??

From: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
To: "'John Thorhauer'" <jthorhauer(at)phoenixcolor(dot)com>, postgres-inter <pgsql-interfaces(at)postgresql(dot)org>
Subject: RE: jdbc large object support ??
Date: 2000-07-20 11:20:30
Message-ID: 1B3D5E532D18D311861A00600865478CF1B124@exchange1.nt.maidstone.gov.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
The LargeObject & LargeObjectManager classes implement the actual interface
to the large objects. setBytes() actually uses those classes, so in theory
using the LargeObject classes would be the better.

However, setBytes() is part of the standard JDBC api.

Personally I prefer the extension classes, as you gain random access to the
BLOB.

Peter

--
Peter Mount
Enterprise Support Mushroom
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council


-----Original Message-----
From: John Thorhauer [mailto:jthorhauer(at)phoenixcolor(dot)com]
Sent: Thursday, July 20, 2000 12:08 PM
To: postgres-inter
Subject: Re: [INTERFACES] jdbc large object support ??


Peter Mount wrote:
> 
> Large Objects have been supported for years - just not via streams.
> 
> Stream support is simply passing an InputStream (say from a file) directly
> to a large object in the database. The ImageViewer example shows the other
> two ways, using setBytes() and using our own extensions.

I tried the setBytes method and it worked great!  Thanks for the help.
However, I have another question.  If I understand correctly I can use
the setBytes() method or the getLargeObjectAPI() method.  Is one
preferred over the other?  Does either have any distinct problems that I
should be aware of?

I know these are real general questions but I am trying to make sure
that I start off going in the right direction with this stuff ;-)

Thanks again,
John
-- 
********************************
** John Thorhauer
** jthorhauer(at)phoenixcolor(dot)com
********************************

pgsql-interfaces by date

Next:From: Brian PiatkusDate: 2000-07-20 13:48:27
Subject: Can I change ODBC Parameters on thr fly ?
Previous:From: Peter MountDate: 2000-07-20 11:10:34
Subject: RE: large object clean up

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group