Re: Blob support... - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: Blob support...
Date
Msg-id 3C5FBBCA.3050201@xythos.com
Whole thread Raw
In response to Blob support...  (Benoit Menendez <benoitm@pacbell.net>)
List pgsql-jdbc
Benoit,

What version are you using?  I would strongly recommend using the 7.2
jdbc driver (it works fine against a 7.1 database).  Also the 7.2 jdbc
chapter of the documentation has examples on how to use both
LargeObjects and bytea datatypes via jdbc.

thanks,
--Barry


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
>



pgsql-jdbc by date:

Previous
From: Marc Lavergne
Date:
Subject: Re: Blob support...
Next
From: Barry Lind
Date:
Subject: Re: SET TRANSACTION ISOLATION LEVEL