Re: Blob support...

From: Barry Lind <barry(at)xythos(dot)com>
To: Benoit Menendez <benoitm(at)pacbell(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Blob support...
Date: 2002-02-05 11:02:34
Message-ID: 3C5FBBCA.3050201@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2002-02-05 18:01:10 Re: Arrays returned in a result set
Previous Message Barry Lind 2002-02-05 10:59:24 Re: Timestamp output