Skip site navigation (1) Skip section navigation (2)

Re: BLOB help - yes I've read around!

From: Brad Milne <mail_4brad(at)yahoo(dot)co(dot)uk>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Subject: Re: BLOB help - yes I've read around!
Date: 2009-04-07 14:04:19
Message-ID: 49DB5D63.5040103@yahoo.co.uk (view raw or flat)
Thread:
Lists: pgsql-jdbc
Thanks Achilleas

So how do you save the bytea data? I get:
Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setBinaryStream(int, 
InputStream) is not yet implemented



Achilleas Mantzios wrote:
> Στις Tuesday 07 April 2009 16:31:11 ο/η Brad Milne έγραψε:
>   
>> Hi all
>>
>> I'm a Java dev, new to postgres. I've just migrated an app during 
>> development from Derby to Postgres (due to better indexing features), 
>> but am very confused by the failing BLOB implementations.
>>
>> PostgreSQL: 8.3.7
>> PostgreSQL-JDBC: 8.3-604
>> JDK: 6
>>
>> A lot of what I've seen in searches and even in the google groups page, 
>> seems to be related to older jdbc drivers, where BLOBs were supported, 
>> both for OID and bytea. I'm currently getting 'unimplemented' exceptions 
>> doing anything with BLOBs.
>>
>> My application saves sound files as byte arrays to the database.
>>
>> Q1: Given that it's sound and not text, would it be safe to use bytea 
>> given that certain characters need to be escaped?
>>     
>
> I have been storing binary data in bytea for ages with postgresql,
> with no major problems.
> Performance might be an issue.
> It is a good practice to store along with the bytea value,
> its mime type as well.
> So in your binary library you could have mp3s,oggs,mpegs, ms docs, jpegs, pdfs,
> and your servlet would know exactly the content type to serve to the client.
>
> Also to answer your question about safeness/escaping, etc...
> those are taken care by the jdbc driver.
>
>   
>> Q2: How on earth do I use the BLOB methods? In particular setBlob(int 
>> parameterIndex, InputStream inputStream) and/or createBlob() and 
>> setBlob(int parameterIndex, Blob x)?
>>
>>     
>
> I never did anything with BLOBs so no experience from me here.
>
>   
>> Thanks a lot
>> Brad
>>
>>     
>
>
>
>   

In response to

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2009-04-07 14:13:38
Subject: Re: What do people use for connection pooling with PostgreSQL JDBC
Previous:From: Hannu KrosingDate: 2009-04-07 14:02:53
Subject: Re: What do people use for connection pooling with PostgreSQL JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group