That's right, there is some padding there...
So, instead of getting calling array(), you have to do something like:
byte[] data = resultSet.one().getBytes("data");
int length = data.remaining();
blobBytes = new byte[length];
data.get(blobBytes, 0, length);
Gabi
On 4/11/13 4:09 PM, Brian O'Neill wrote:
Yep, it worked like a charm. (PreparedStatement avoided the hex
conversion)
But now, I'm seeing a few extra bytes come back in the select….
(I'll keep digging, but maybe you have some insight?)
I see this:
ERROR [2013-04-11 13:05:03,461] com.skookle.dao.RepositoryDao:
repository.add() byte.length()=[259804]
ERROR [2013-04-11 13:08:08,487] com.skookle.dao.RepositoryDao:
repository.get() [foo.jpeg] byte.length()=[259861]
(Notice the length's don't match up)
Using this code:
public void addContent(String key, byte[] data)
throws NoHostAvailableException {
LOG.error("repository.add() byte.length()=["+ data.length+ "]");
String statement = "INSERT INTO "+ KEYSPACE+ "."+ TABLE+ "(key,
data) VALUES (?, ?)";
PreparedStatement ps = session.prepare(statement);
BoundStatement bs = ps.bind(key, ByteBuffer.wrap(data));
session.execute(bs);
}
public byte[] getContent(String key) throws NoHostAvailableException {
Query select = select("data").from(KEYSPACE,
TABLE).where(eq("key", key));
ResultSet resultSet = session.execute(select);
byte[] data = resultSet.one().getBytes("data").array();
LOG.error("repository.get() ["+ key + "] byte.length()=["+
data.length+ "]");
return data;
}
---
Brian O'Neill
Lead Architect, Software Development
*Health Market Science*
/The Science of Better Results/
2700 Horizon Drive •King of Prussia, PA •19406
M: 215.588.6024 • @boneill42 <http://www.twitter.com/boneill42> •
healthmarketscience.com
This information transmitted in this email message is for the intended
recipient only and may contain confidential and/or privileged
material. If you received this email in error and are not the intended
recipient, or the person responsible to deliver it to the intended
recipient, please contact the sender at the email above and delete
this email and any attachments and destroy any copies thereof. Any
review, retransmission, dissemination, copying or other use of, or
taking any action in reliance upon, this information by persons or
entities other than the intended recipient is strictly prohibited.
From: Sylvain Lebresne <sylv...@datastax.com
<mailto:sylv...@datastax.com>>
Reply-To: <user@cassandra.apache.org <mailto:user@cassandra.apache.org>>
Date: Thursday, April 11, 2013 8:48 AM
To: "user@cassandra.apache.org <mailto:user@cassandra.apache.org>"
<user@cassandra.apache.org <mailto:user@cassandra.apache.org>>
Cc: Gabriel Ciuloaica <gciuloa...@gmail.com <mailto:gciuloa...@gmail.com>>
Subject: Re: Blobs in CQL?
Hopefully, the prepared statement doesn't do the conversion.
It does not.
(I'm not sure if it is a limitation of the CQL protocol itself)
thanks again,
-brian
---
Brian O'Neill
Lead Architect, Software Development
Health Market Science
The Science of Better Results
2700 Horizon Drive • King of Prussia, PA • 19406
M: 215.588.6024 <tel:215.588.6024> • @boneill42
<http://www.twitter.com/boneill42> •
healthmarketscience.com <http://healthmarketscience.com>
This information transmitted in this email message is for the intended
recipient only and may contain confidential and/or privileged
material. If
you received this email in error and are not the intended
recipient, or
the person responsible to deliver it to the intended recipient, please
contact the sender at the email above and delete this email and any
attachments and destroy any copies thereof. Any review,
retransmission,
dissemination, copying or other use of, or taking any action in
reliance
upon, this information by persons or entities other than the intended
recipient is strictly prohibited.
On 4/11/13 8:34 AM, "Gabriel Ciuloaica" <gciuloa...@gmail.com
<mailto:gciuloa...@gmail.com>> wrote:
>I'm not using the query builder but the PreparedStatement.
>
>Here is the sample code: https://gist.github.com/devsprint/5363023
>
>Gabi
>On 4/11/13 3:27 PM, Brian O'Neill wrote:
>> Great!
>>
>> Thanks Gabriel. Do you have an example? (are using QueryBuilder?)
>> I couldn't find the part of the API that allowed you to pass
in the
>>byte
>> array.
>>
>> -brian
>>
>> ---
>> Brian O'Neill
>> Lead Architect, Software Development
>> Health Market Science
>> The Science of Better Results
>> 2700 Horizon Drive € King of Prussia, PA € 19406
>> M: 215.588.6024 <tel:215.588.6024> € @boneill42
<http://www.twitter.com/boneill42> €
>> healthmarketscience.com <http://healthmarketscience.com>
>>
>> This information transmitted in this email message is for the
intended
>> recipient only and may contain confidential and/or privileged
material.
>>If
>> you received this email in error and are not the intended
recipient, or
>> the person responsible to deliver it to the intended recipient,
please
>> contact the sender at the email above and delete this email and any
>> attachments and destroy any copies thereof. Any review,
retransmission,
>> dissemination, copying or other use of, or taking any action in
reliance
>> upon, this information by persons or entities other than the
intended
>> recipient is strictly prohibited.
>>
>>
>>
>>
>>
>>
>>
>> On 4/11/13 8:25 AM, "Gabriel Ciuloaica" <gciuloa...@gmail.com
<mailto:gciuloa...@gmail.com>> wrote:
>>
>>> Hi Brian,
>>>
>>> I'm using the blobs to store images in cassandra(1.2.3) using the
>>> java-driver version 1.0.0-beta1.
>>> There is no need to convert a byte array into hex.
>>>
>>> Br,
>>> Gabi
>>>
>>> On 4/11/13 3:21 PM, Brian O'Neill wrote:
>>>> I started playing around with the CQL driver.
>>>> Has anyone used blobs with it yet?
>>>>
>>>> Are you forced to convert a byte[] to hex?
>>>> (e.g. I have a photo that I want to store in C* using the
java-driver
>>>> API)
>>>>
>>>> -brian
>>>>
>>>> --
>>>> Brian ONeill
>>>> Lead Architect, Health Market Science
(http://healthmarketscience.com)
>>>> mobile:215.588.6024 <tel:215.588.6024>
>>>> blog: http://brianoneill.blogspot.com/
>>>> twitter: @boneill42
>>
>