Using this property, you can specify whether to allow the execution of unsupported operations. Such operations may otherwise produce an error when you have set the JDBC autocommit to false using java.sql.Connection#setAutoCommit API. If you set the autocommit to false, the operations in a column table produces an error as follows: Operations on column tables are not supported when query routing is disabled or autocommit is false. To allow such operations, set the allow-explicit-commit property to true.


Although this property allows using the JDBC autocommit(false) and commit/rollback APIs, all of these are no-op with no change in the product behavior. This means that autocommit is always true even if the user sets it explicitly to false.

This property is useful in scenarios as SQL client tools that may use transactions isolation levels (read committed / repeatable read) and explicitly set autocommit to false. In such cases, without this property, the SQL operations produce an error.


This property can be used in connection URLs while connecting to SnappyData JDBC server. In such a case JDBC URL appears as follows:


This property can also be passed to java.sql.DriverManager#getConnection(java.lang.String, java.util.Properties) API in the properties object.

Default Value


Property Type