Re: [SOLVED]Re: Retrieving binary data - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: [SOLVED]Re: Retrieving binary data
Date
Msg-id 3D264943.7050704@xythos.com
Whole thread Raw
In response to Retrieving binary data  (David Garnier <david.garnier@etudier-online.com>)
List pgsql-jdbc
David,

One thing to watch out for using binary cursors is that all of the data
selected comes back in binary form.  Thus if you select an integer value
along with you bytea data you need to realize that that integer value
comes back in the native server 32bit format.  Thus if the client and
server are running different architectures you may have endian
conversion issues.  I use binary cursors to get bytea data without any
problems.  I am quite certain that the data is never converted to a string.

thanks,
--Barry


David Garnier wrote:

>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.garnier@etudier-online.com> wrote:
>
>
>
>>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
withdeclare and fetch, but will it send me the correct bytes? I'm open to any suggestion (including Fastpath or another
JDBCdriver). 
>>
>>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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: Have you searched our list archives?
>>
>>http://archives.postgresql.org
>>
>>
>>
>>
>>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>
>
>
>





pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: BYTEA transport
Next
From: Dave Cramer
Date:
Subject: Re: DBVisualizer Null Pointer Exception