Support Forums : DataStax

DataStax Support Forums » Apache Cassandra

JDBC interaction with Cassandra

(6 posts) (3 voices)

Started 9 months ago by hardikupadhyay
Latest reply from thepaul
This topic is not a support question

Tags:

hardikupadhyay
Member

Hi,
I want to know
Does JDBC needs predefined cassandra column family structure?
Means should i create column family schema prior to inserting data into column family
via JDBC?

Posted 9 months ago #
xedin
Member

Yes, you need to create your schema before using JDBC.

Posted 9 months ago #
hardikupadhyay
Member

Thanks for the reply, one more thing which i like to know is ,can i insert different columns which i have not specified in schema definition?

Because i tried , and it failed.

Posted 9 months ago #
xedin
Member

I don't know about JDBC but if you want to insert columns that you don't have in your schema you can use Thrift which allows that for sure.

Posted 9 months ago #
hardikupadhyay
Member

I want to understand that how cassandra ensures high availability. What i know is when we query casssandra database for data, a node called coordinator route the query to the appropriate cassandra node in the cluster with the required data. But what if the node which we specify in JDBC connection URL (Which i think will act as coordinator in the cluster, please make me correct if i am wrong) itself down? In this case how come cassandra ensures high availability?

Perhaps we as a developer must provide fallback mechanism for that?

Please help me out to understand this.

Posted 9 months ago #
thepaul
Moderator

That's right, the client software must be able to reconnect to a different node if the coordinator goes down. Ideally the CQL driver or other Cassandra connector library would take care of that for you, but not all of them do yet.

Posted 9 months ago #

RSS feed for this topic