How can I connect Cassandra DB using its JDBC driver in Matlab?

Asked by Jasim Waheed Ansari on 13 Dec 2017

Latest activity Answered by MathWorks Computational Finance Team on 9 Nov 2018

41 views (last 30 days)

Hello, I am pretty new to Matlab. I have a task to connect the Cassandra cluster using Matlab. I do have an access to Cassandra JDBC driver jar, therefore I wrote a test script to test if I could connect to cluster. Where am I going wrong. Thanks.

function cassandra_matlab
cassandra_jdbc_path='C:/Users/adm_lokal/Downloads/cassandra-jdbc-wrapper-3.1.0-SNAPSHOT.jar';
javaaddpath(cassandra_jdbc_path)
datasource='cassandra';
username='';
password='';
driver='org.apache.cassandra2.cql.jdbc.CassandraDriver';
url='jdbc:cassandra://127.0.0.1:9042/project_fvag_dev';
%connecting to cassandra cluster
conn=database(datasource,username,password,driver,url);
print('connected!!!');
selectquery='SELECT * from project_fvag_dev.zeit2_schnellemessrate_6dof_033 LIMIT 5';
data=select(conn,selectquery);
close(conn);

Output: Error using database (line 158) Java exception occurred: com.google.common.util.concurrent.ExecutionError: java.lang.ExceptionInInitializerError

    at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
    at com.google.common.cache.LocalCache.get(LocalCache.java:3932)
    at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3936)
    at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4806)
    at com.github.adejanovski.cassandra.jdbc.CassandraDriver.connect(CassandraDriver.java:102)
    at com.mathworks.toolbox.database.DrivJDBC.connect(DatabaseConnection.java:30)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at com.mathworks.toolbox.database.DatabaseConnection.<init>(DatabaseConnection.java:151)

Caused by: java.lang.ExceptionInInitializerError

    at com.github.adejanovski.cassandra.jdbc.SessionHolder.createSession(SessionHolder.java:137)
    at com.github.adejanovski.cassandra.jdbc.SessionHolder.<init>(SessionHolder.java:83)
    at com.github.adejanovski.cassandra.jdbc.CassandraDriver$1.load(CassandraDriver.java:68)
    at com.github.adejanovski.cassandra.jdbc.CassandraDriver$1.load(CassandraDriver.java:65)
    at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3522)
    at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2315)
    at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2278)
    at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2193)
    ... 8 more

Caused by: java.lang.IllegalStateException: Detected Guava issue #1635 which indicates that a version of Guava less than 16.01 is in use. This introduces codec resolution issues and potentially other incompatibility issues in the driver. Please upgrade to Guava 16.01 or later.

    at com.datastax.driver.core.SanityChecks.checkGuava(SanityChecks.java:62)
    at com.datastax.driver.core.SanityChecks.check(SanityChecks.java:36)
    at com.datastax.driver.core.Cluster.<clinit>(Cluster.java:67)
    ... 16 more

Error in cassandra_matlab (line 11) conn=database(datasource,username,password,driver,url);

0 Comments

Products

Database Toolbox

1 Answer

Link

Answer by MathWorks Computational Finance Team on 9 Nov 2018

As of MATLAB R2018b, you can connect to Cassandra without the JDBC driver using the Database Toolbox™ Interface for Apache Cassandra® Database. You can find more information on this here:

Database Toolbox™ Interface for Apache Cassandra® Database

0 Comments

Products

Database Toolbox

You are now following this question

Jasim Waheed Ansari (view profile)