Right ... there's a few "bugs" unconfirmed but it is in my eyes in
org.postgresql.jdbc2.PreparedStatement and ResultSet. Look in the source
(postgresql-7.2/src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet and
you'll see that the code was branched right around line 330.
Unfortunately, that breaks support for lo types in 7.2. Not I'm not sure
WHAT the official position is on this. However, there are four things
you can do: use the 7.1.3 JDBC driver, custom fix the 7.2 driver (ie.
remove the if statement to revert to 7.1.3 behavior), submit a diff
patch, file a bug and hope somebody fixes it. Obviously, the first and
second options are the easiest. The third and fourth would require some
kind of authoritative statement on what the position on BLOBs in 7.2 is!
Hope this helps and good luck!
Marc
Benoit Menendez wrote:
> I use the latest stable 7.2.2 under cygwin
>
> Benoit
>
> ----- Original Message -----
> From: "Marc Lavergne" <mlavergne-pub@richlava.com>
> To: "Benoit Menendez" <benoitm@pacbell.net>
> Cc: <pgsql-jdbc@postgresql.org>
> Sent: Tuesday, February 26, 2002 11:13 AM
> Subject: Re: [JDBC] Blob support...
>
>
>
>>Which release of PostgreSQL? There were numerous changes in BLOB support
>>from 7.0 to 7.1 to 7.2, your answer depends on the target release of
>>PostgreSQL.
>>
>>Benoit Menendez wrote:
>>
>>
>>>I use both ODBC and JDBC to access the same database (from two different
>>>applications) and I need blob support...
>>>
>>>
>>>
>>>I have created and used the "lo" type which is handled correctly by the
>>>ODBC driver...
>>>
>>>
>>>
>>>But JDBC does not like the "lo" type for blobs...
>>>
>>>
>>>
>>>If I do a getBytes on an "lo" I only get 4 (+1) bytes...
>>>
>>>
>>>
>>>I tried "bytea" but ODBC does not work properly with this type...
>>>
>>>
>>>
>>>Is the "lo" type supported in a recent patch?
>>>
>>>
>>>
>>>Thanks,
>>>
>>>
>>>
>>> Benoit
>>>
>>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>