Apache Ignite Developers - Legacy Mail Archive

TX savepoints

Classic

List

Threaded

17 messages Options

yzhdanov TX savepoints – Guys, Let's think of implementing savepoints for Ignite transactions. For me, this is not too hard to do. Having "savepoints" see...

Sergey Kozlov Hi, Yakov I suppose it's very very handy feature. My two cents are following: - number of savepoints may be more than one per transaction ...

Alexey Goncharuk We also should define savepoint behavior and API rules for each of the transaction concurrency and isolation types. * Should rollbackToSavepo...

yzhdanov Alex, I think we should put consecutive checkpoints to stack thus your example should be illegal and should result to exception. And we will thro...

dsetrakyan Does anyone know how MySQL or PostgreSQL work with checkpoints? Do they support it in a similar way? On Mon, Nov 7, 2016 at 5:58 AM, Yakov Zhd...

Denis Magda This is how how the savepoints are supported by PostgreSQL [1], Oracle [2] and MySQL [3]. The implementation details and behavior are pretty the s...

dsetrakyan Couldn't agree more about ODBC and JDBC. We must support savepoints from SLQ, given the DML functionality being planned for 1.8 release. On Mo...

Igor Sapego Hi, Currently, we do not support transaction in ODBC at all. I'm not quite sure about JDBC, but I believe we do not support them there either....

Sergi All the SQL statements currently run out of transactions. It is a big feature for 2.0 Sergi 2016-11-08 15:09 GMT+03:00 Igor Sapego <isap...

dsetrakyan I am not sure why we don't add the transaction support now, given that we are going to support insert, update, and delete statements. On Tue, ...

Sergi Dmitriy, I don't see how we can support it without having all the complex MVCC machinery that we are creating for 2.0 (and it is very far from...

dsetrakyan On Tue, Nov 8, 2016 at 11:51 AM, Sergi Vladykin <sergi.vladykin@...> wrote: > Dmitriy, > > I don't see how we can support it ...

Sergi > > I see your point, but why not add the SQL commands right now and support > transactions in the same way we support them in the proj...

dsetrakyan Agree. On Tue, Nov 8, 2016 at 12:38 PM, Sergi Vladykin <sergi.vladykin@...> wrote: > > > > I see your point, but why not...

Denis Magda Created tickets for transactional support of DML and SELECT statements on JDBC, ODBC and DML API sides https://issues.apache.org/jira/browse/IGNI...

Denis Magda I’ve wrapped up the outcomes of the discussion and created JIRA tickets https://issues.apache.org/jira/browse/IGNITE-4188 <https://issues.apac...

Igor Sapego Denis, As far as I know, there is no support for savepoints in ODBC API. ODBC drivers which implement it just detect "SAVEPOINT" key...