Transactional SQL queries

[colinc <co...@yahoo.co.uk>]

Is it possible for SQL queries to participate in Ignite transactions in the
same way that cache get/put operations do?

So far, I've not managed to get them to do so. For example, an
optimistic/serializable transaction around a query (and with a concurrent
put in another transaction) doesn't throw a TransactionOptimisticException
when it commits - whereas a transaction around an equivalent cache get
operation does.

The documentation around transactions doesn't seem to mention queries.

Thanks,
Colin.



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Transactional-SQL-queries-tp4207.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Transactional SQL queries

["david.alexanyan" <da...@optym.com>]

Any news on this ?



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Transactional-SQL-queries-tp4207p15271.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Transactional SQL queries

[vkulichenko <va...@gmail.com>]

Hi Colin,

This is not possible, transactional guarantees are fully supported only for
key-based access. This is something that we have on the roadmap, but I don't
think that it will be available very soon.

-Val



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Transactional-SQL-queries-tp4207p4208.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.