Re: Ignite sql queries working transactionally

2017-09-03 Thread Dmitriy Setrakyan
Denis, I think you provided an incorrect link to the ticket. Here is the correct link: https://issues.apache.org/jira/browse/IGNITE-3478 D. On Wed, Aug 30, 2017 at 5:50 PM, Denis Magda wrote: > Hi, > > The docs are still valid - SQL operations are not fully transactional yet > and, according,

Re: Ignite sql queries working transactionally

2017-08-30 Thread Denis Magda
Hi, The docs are still valid - SQL operations are not fully transactional yet and, according, to JIRA the works is in progress to make this happen: https://ggsystems.atlassian.net/browse/IGN-4666 — Denis > On Aug 30, 2017, at 12:21 AM, kotamra

Re: Ignite sql queries working transactionally

2017-08-30 Thread Evgenii Zhuravlev
In the nearest release should be fixed https://issues.apache.org/ jira/browse/IGNITE-6044 and in the subsequent release will be added support for transactional SQl. 2017-08-30 12:36 GMT+03:00 kotamrajuyashasvi : > Hi > > Thanks for the response > > I still do not understand the difference betwee

Re: Ignite sql queries working transactionally

2017-08-30 Thread kotamrajuyashasvi
Hi Thanks for the response I still do not understand the difference between using sql queries in ignite Transaction and sql transactions feature that is being mentioned which would be added in upcoming releases. If in future releases, using sql queries in Transactions throws exception, How am I

Re: Ignite sql queries working transactionally

2017-08-30 Thread ezhuravlev
Hi, Currently, Sql is not transactional, support of transactions in SQL should be added in 2.2 release(or it could be added in 2.3 release, if version 2.2 will be released for some hot fixes, it currently descussing on dev list). It's not recommended to use SQL in Transactions, most possible tha

Ignite sql queries working transactionally

2017-08-30 Thread kotamrajuyashasvi
Hi In my ignite client application I need to perform a set of update/delete sql query operations transactionally. I observed that by using ignite transactions I was able to achieve this. When ever an update or delete query is executed with in a transaction, it is locking all resulting rows and th

Ignite sql queries working transactionally

2017-08-30 Thread kotamrajuyashasvi
Hi In my ignite client application I need to perform a set of update/delete sql query operations transactionally. I observed that by using ignite transactions I was able to achieve this. When ever an update or delete query is executed with in a transaction, it is locking all resulting rows and th