JDBC Writer and cassandra-jdbc driver error

Gatling (Open-Source)
#1

Hi,

I’m trying to use jdbc writer in Gatling to put tests results to Cassandra but I get the following error :

[GatlingSystem-akka.actor.default-dispatcher-4] [akka.dispatch.Dispatcher] the Cassandra implementation is always in auto-commit mode

java.sql.SQLFeatureNotSupportedException: the Cassandra implementation is always in auto-commit mode

Is there a way to set auto-commit mode to false ?

e.g. setAutoCommit(false)

or in gatling.conf ?

Thanks!

GerraldG
#2 
Forgot to mention that we have cassandra-jdbc maven plugin installed ( [http://code.google.com/a/apache-extras.org/p/cassandra-jdbc/](http://code.google.com/a/apache-extras.org/p/cassandra-jdbc/))

And are using 2.0.0-M3a

#3

This writer was initially developed for standard JDBC4 compatible drivers, and it relies on batch inserts, hence setting auto-commit to false.
You’d have to fork or provide a pull request :slight_smile: