Re: BLOB files, Updates, ... 2nd Edition

Egon,

I strongly suggest that you upgrade. The functionality for LargeObjects
changed a lot in the server between 7.0 and 7.1. And the functionality
in the jdbc driver for 'blobs' changed a lot between 7.1 and 7.2.

I would also recommend that you read the documentation from 7.2 for jdbc
on dealing with blobs (you can access this online off of the website).
It talks about the different ways you can use postgres to store blobs
via jdbc and why you might choose one option over another.

thanks,
--Barry

Egon Sommer wrote:
> Hello everybody,
>
> There are more things I do not understand:
>
> In my last letter I wrote that I save empty BLOB as NULL. And I wrote that the number of files is the same as bevore. WRONG: After the converting there are MORE
> files :( Tell me a way to fight agains this.
>
> 2nd problem is: If I try to read one of this BLOBS with ResultSet.getBinaryStream() I get an error message like "relation 0 does not exist". Sure it does not exist. It's
> NULL.... But to avoid this exception I have to use ResultSet.wasNull(). But this function is not available BEVORE I used a getXXX-methode. And AFTER using a
> getXXX-methode it's to late.
>
> Any idears?
>
> I use: Postgressql 7.0.3 with driver jdbc7.1-1.3.jar
>
> Hope you can help me...
>
> Greetings
> Joerg Sommer
>
> --------------------------------------------------------------------------
> Sommer Maschinenbau
> Pagenstecherstr. 146
> 49090 Osnabrück
>
> 0049 (0)541 125085
> 0049 (0)541 129557
>
> Service(at)Sommer-Maschinenbau(dot)de
> --------------------------------------------------------------------------
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>