Search code examples
jdbcvoltdb

VoltDB does not support transaction?

I am connecting to a VoltDB enterprise instance through JDBC driver. However, it does not support transaction control. When I call conn.commit or rollback, it throwsjava.sql.SQLFeatureNotSupportedException.

Any thoughts?

Solution

  • VoltDB executes ACID transactions but does not support external transaction control. Multi-statement transactions can be implemented as java stored procedures. Each call/request to the database is essentially one ACID transaction.

    There are a number of reasons for this, which have to do with the architecture of VoltDB, and what makes it so fast and scalable. It is perhaps best explained in this video by John Hugg, one of the founding engineers at VoltDB.

    http://voltdb.com/resources/video/h-storevoltdb-architecture-vs-cep-systems-and-newer-streaming-architectures