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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>>
>>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2009-04-07 14:13:38 | Re: What do people use for connection pooling with PostgreSQL JDBC |
Previous Message | Hannu Krosing | 2009-04-07 14:02:53 | Re: What do people use for connection pooling with PostgreSQL JDBC |