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

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);

Answer 1

[MathWorks Computational Finance Team]

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