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