Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of sdddilrukshi@gmail.com
 designates 209.85.214.44 as permitted sender)
MIME-Version: 1.0
Date: Mon, 5 Dec 2011 22:10:27 +0530
Message-ID: 
 <CAK4eHaov7dpiGcEfk4xi_TJY+cKQZoSvf_h_z-+1N6wG+7tf4w@mail.gmail.com>
Subject: Setting Key Validation Class
From: Dinusha Dilrukshi <sdddilrukshi@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=0016364267cddbc02504b35af9f1

--0016364267cddbc02504b35af9f1
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I am using apache-cassandra-1.0.0 and I tried to insert/retrieve data in a
column family using cassandra-jdbc program.
Here is how I created 'USER' column family using cassandra-cli.

create column family USER with comparator=UTF8Type
and column_metadata=[{column_name: user_id, validation_class: UTF8Type,
index_type: KEYS},
{column_name: username, validation_class: UTF8Type, index_type: KEYS},
{column_name: password, validation_class: UTF8Type}];

But, when i try to insert data to USER column family it gives the error
"java.sql.SQLException: Mismatched types: java.lang.String cannot be cast
to java.nio.ByteBuffer".

Since I have set user_id as a KEY and it's validation_class as UTF8Type, I
was expected Key Validation Class as UTF8Type.
But when I look at the meta-data of USER column family it shows as "Key
Validation Class: org.apache.cassandra.db.marshal.BytesType" which has
cause for the above error.

When I created USER column family as follows, it solves the above issue.

create column family USER with comparator=UTF8Type and
key_validation_class=UTF8Type
and column_metadata=[{column_name: user_id, validation_class: UTF8Type,
index_type: KEYS},
{column_name: username, validation_class: UTF8Type, index_type: KEYS},
{column_name: password, validation_class: UTF8Type}];

Do we always need to define *key_validation_class* as in the above query ?
Isn't it not enough to add validation classes for each column ?

Regards,
~Dinusha~

--0016364267cddbc02504b35af9f1
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,<div><br></div><div>I am using=A0apache-cassandra-1.0.0 and I tried to i=
nsert/retrieve=A0data in a column family using cassandra-jdbc program.</div=
><div>Here is how I created &#39;USER&#39; column family using cassandra-cl=
i.</div>

<div><br></div><div><div>create column family USER with comparator=3DUTF8Ty=
pe</div><div>and column_metadata=3D[{column_name: user_id, validation_class=
: UTF8Type, index_type: KEYS},</div><div>{column_name: username, validation=
_class: UTF8Type, index_type: KEYS},</div>

<div>{column_name: password, validation_class: UTF8Type}];</div></div><div>=
<br></div><div>But, when i try to insert data to USER column family it give=
s the error &quot;java.sql.SQLException: Mismatched types: java.lang.String=
 cannot be cast to java.nio.ByteBuffer&quot;.</div>

<div><br></div><div>Since I have set user_id as a KEY and it&#39;s=A0valida=
tion_class as UTF8Type, I was expected=A0Key Validation Class as=A0UTF8Type=
.=A0</div><div>But when I look at the meta-data of USER column family it sh=
ows as &quot;Key Validation Class: org.apache.cassandra.db.marshal.BytesTyp=
e&quot; which has cause for the above error.</div>

<div><br></div><div>When I created USER column family as follows, it solves=
 the above issue.</div><div><br></div><div><div>create column family USER w=
ith comparator=3DUTF8Type <font color=3D"#FF0000">and key_validation_class=
=3DUTF8Type</font></div>

<div>and column_metadata=3D[{column_name: user_id, validation_class: UTF8Ty=
pe, index_type: KEYS},</div><div>{column_name: username, validation_class: =
UTF8Type, index_type: KEYS},</div><div>{column_name: password, validation_c=
lass: UTF8Type}];</div>

</div><div><br></div><div>Do we always need to define=A0<b style=3D"font-st=
yle:italic">key_validation_class</b><span style=3D"color:rgb(255,0,0);font-=
weight:bold;font-style:italic">=A0</span>as in the above query ? Isn&#39;t =
it not enough to add validation classes for each column ?</div>

<div><br></div><div>
Regards,</div><div><font color=3D"#cc33cc">~Dinusha~</font><br><br>
</div>

--0016364267cddbc02504b35af9f1--