Re: Retrieving binary data - Mailing list pgsql-jdbc

From David Garnier
Subject Re: Retrieving binary data
Date
Msg-id 20020705232440.14a4332c.david.garnier@etudier-online.com
Whole thread Raw
In response to Re: Retrieving binary data  (Barry Lind <barry@xythos.com>)
Responses [SOLVED]Re: Retrieving binary data
List pgsql-jdbc
On Fri, 05 Jul 2002 12:12:45 -0700
Barry Lind <barry@xythos.com> wrote:

> David,
>
> If I understand what you are trying to do correctly, using a binary
> cursor should solve your problem.  See the docs on the "declare [binary]
> cursor" SQL command.

First, thanks for your anwser.
Yeah that's exactly what I'm thinking, but will it work with JDBC? I guess I can execute several queries in a row with
declareand fetch, but will it send me the correct bytes? I'm open to any suggestion (including Fastpath or another JDBC
driver).

Best Regards,
David Garnier

> David Garnier wrote:
>
> >Hello,
> >
> >I need to retrieve the binary representation of a custom type. I can retrieve the type just fine with the standard
method,but the results of getBytes is altered. getString shows just the right thing, but I need the binary. I looked at
thesource of the driver, and I still don't know exactly what I'm supposed to do. It seems to me that the QueryExecutor
isable to fetch a binary tuple, but I don't know how to request one. 
> >
> >Performance is my main problem, so I would like a fast solution. Thanks for helping.
> >
> >Best regards,
> >David Garnier
> >
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 6: Have you searched our list archives?
> >
> >http://archives.postgresql.org
> >
> >
> >
> >
> >
>
>
>



pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: Retrieving binary data
Next
From: Barry Lind
Date:
Subject: Re: PreparedStatement and DB default values