Re: [GENERAL] jdbc lob and postgresql

2007-12-13 Thread Thomas Kellerer
Kris Jurka, 13.12.2007 08:24: Using a PreparedStatement with setBinaryStream() to insert the blob and getBinaryStream() to read the BLOB works fine for me. It depends how you want to handle binary data on the server side. get/setBinaryStream only work with the bytea data type.

Re: [GENERAL] jdbc lob and postgresql

2007-12-13 Thread Kris Jurka
On Thu, 13 Dec 2007, Thomas Kellerer wrote: Can you point me to the manual for these types of BLOBs are described? The Data Types chapter does not list them as far as I can tell. Apparently the only documentation appears to be in the client interfaces section...

[GENERAL] jdbc lob and postgresql

2007-12-12 Thread Anu Padki
Hello all, I am contemplating to use postgresql for a product that requires to manipulate many blobs. From the documentation I am not clear if one has to use postgres api to insert/update/select blobs or one can use standard jdbc api? Can I just execute a statement insert into (..) that has a

Re: [GENERAL] jdbc lob and postgresql

2007-12-12 Thread Thomas Kellerer
Anu Padki wrote on 12.12.2007 20:09: Hello all, I am contemplating to use postgresql for a product that requires to manipulate many blobs. From the documentation I am not clear if one has to use postgres api to insert/update/select blobs or one can use standard jdbc api? Can I just execute a

Re: [GENERAL] jdbc lob and postgresql

2007-12-12 Thread Kris Jurka
On Thu, 13 Dec 2007, Thomas Kellerer wrote: I am contemplating to use postgresql for a product that requires to manipulate many blobs. From the documentation I am not clear if one has to use postgres api to insert/update/select blobs or one can use standard jdbc api? Can I just execute a