SEO

#1 (**permalink**) 04-16-2008, 12:59 AM

I made several attempts today to get an example of a blob insert via jdbc
working today, but ran into several errors. I tried both oid and bytea data
types, and tried the LargeObject manager/methods. [The bytea type probably
won't ultimately work for me - we need to be able to insert blobs of a few
megs each.] We use 8.0 in production, so newer examples with 8.1/8.2/8.3
specific implementations wouldn't help very much.

So, any ideas where I can find working examples of jdbc/blob operations?

Thanks,

Brent Friedman

#2 (**permalink**) 04-16-2008, 12:59 AM

On Thu, 31 Jan 2008, Brent Friedman wrote:

> I made several attempts today to get an example of a blob insert via jdbc
> working today, but ran into several errors. I tried both oid and bytea data
> types, and tried the LargeObject manager/methods. [The bytea type probably
> won't ultimately work for me - we need to be able to insert blobs of a few
> megs each.] We use 8.0 in production, so newer examples with 8.1/8.2/8.3
> specific implementations wouldn't help very much.
>
> So, any ideas where I can find working examples of jdbc/blob operations?
>

http://jdbc.postgresql.org/documenta...nary-data.html

The sample code here using the LargeObjectManager API should work.
Checking the test suite is also a reasonable place to look for examples.
See readWrite here:

http://cvs.pgfoundry.org/cgi-bin/cvs...-cvsweb-markup

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Any examples for Postgresql 8.0 using jdbc type 2/3 driver with blobs?