[SOLVED]Re: Retrieving binary data

Поиск
Список
Период
Сортировка
Искать
От
David Garnier
Тема
[SOLVED]Re: Retrieving binary data
Дата
Msg-id
20020706025854.03230eff.david.garnier@etudier-online.com
Ответ на
Список
Дерево обсуждения
Re: [SOLVED]Re: Retrieving binary data Barry Lind <barry@xythos.com>
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  wrote:

> On Fri, 05 Jul 2002 12:12:45 -0700
> Barry Lind  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
> 
> 
> 


В списке pgsql-jdbc по дате отправления
От: Paul Ramsey
Дата:
Сообщение: BYTEA transport
От: Barry Lind
Дата:
Сообщение: Re: BYTEA transport
FAQ