Hi, By default Ignite uses "ATOMIC" atomicity mode which doesn't support transactions: https://apacheignite.readme.io/docs/transactions#section-atomicity-mode
In case you want to use transactions in SQL you should set "TRANSACTIONAL_SNAPSHOT" atomicity level, as described here: https://apacheignite-sql.readme.io/docs/multiversion-concurrency-control#section-overview But I should mention that SQL transactions are in beta and not recommended for usage in production, instead of that you can use key-value transactions executed via JavaAPI: https://apacheignite.readme.io/docs/transactions#section-ignitetransactions Regards, Igor On Mon, Sep 23, 2019 at 10:33 AM Arpit Gadle <[email protected]> wrote: > Hi All, > > I want to test transaction with Apache Ignite SQL table. For this I > created a small program. What the program does is > > 1. Start a ignite server node from the code itself. > 2. Create a JDBC url to local ignite server > 3. Get a JDBC connection, create the table > 4. Get a JDBC connection, set auto commit to false, insert few records, > then close the connection without committing. > 5. Create a new jdbc connection, execute select query. > > Output: As auto commit is set to false, after closing the connection, the > select query should have returned is returning records. > > Expected Output: The select query should have returned no records, as auto > commit is set to false, and connection is not committed. > > Ignite Version 2.7.0 > > Attaching > 1. the sample code > 2. pom.xml > > > Any help is appreciated. > > Thanks > Arpit > > >
