[SOLVED]Re: Retrieving binary data

Binary cursors works just fine with JDBC. I can retrieve my binaries without any problem, and it's very very fast. Now, can you assure me that it isn't converted into a String at some point? (I doubt it.)

Best Regards,
David Garnier

On Fri, 5 Jul 2002 23:24:40 +0200
David Garnier <david(dot)garnier(at)etudier-online(dot)com> wrote:

> On Fri, 05 Jul 2002 12:12:45 -0700
> Barry Lind <barry(at)xythos(dot)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 declare and 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 the source of the driver, and I still don't know exactly what I'm supposed to do. It seems to me that the QueryExecutor is able 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
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>