Re: work around for problem where ignite query does not include objects added into Cache from within a transaction

2017-09-19 Thread kotamrajuyashasvi
Hi Thanks for your responses. I just wanted a temporary work around till the actual feature is implemented, even at the cost of performance. I have thought of another approach to this problem. I plan to use my own transaction mechanism instead of Ignite transactions. I can use explicit locks to

Re: work around for problem where ignite query does not include objects added into Cache from within a transaction

2017-09-18 Thread rick_tem
Okay, thank you. Nice to know it is under development. Best, Rick -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: work around for problem where ignite query does not include objects added into Cache from within a transaction

2017-09-18 Thread Dmitriy Setrakyan
On Mon, Sep 18, 2017 at 8:01 AM, rick_tem wrote: > I see that as a huge problem. Certainly one of the functions of Ignite is > to > be faster than the database, but if it fails to meet all of the > requirements > of what a database will do for you, what is the point of using it? Clearly > a > da

Re: work around for problem where ignite query does not include objects added into Cache from within a transaction

2017-09-18 Thread vkulichenko
As Vladimir mentioned, this is one of the features that is simply not implemented yet. Transactional support for SQL is in development right now. Hopefully we will have sometime this year, or probably early next year. -Val -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: work around for problem where ignite query does not include objects added into Cache from within a transaction

2017-09-18 Thread rick_tem
I see that as a huge problem. Certainly one of the functions of Ignite is to be faster than the database, but if it fails to meet all of the requirements of what a database will do for you, what is the point of using it? Clearly a database will keep read consistency between transactions. Most app

Re: work around for problem where ignite query does not include objects added into Cache from within a transaction

2017-09-18 Thread Vladimir Ozerov
Hi, Looks like you need the feature which is simply not implement in Ignite at the moment. SELECTs are not transactional and there is not easy way to make not-yet-committed updates visible to them. Solution 1 doesn't work as there are not "temporal" caches in Ignite. Not-yet-committed updates are

work around for problem where ignite query does not include objects added into Cache from within a transaction

2017-09-16 Thread kotamrajuyashasvi
Hi When a transaction is started and some rows are updated/inserted/deleted in a cache which is in transactional mode, And after that when I perform a select query, its not reflecting the results from of update/insert/delete done before with in the transaction. I found out that ignite sql does no

Re: Query does not include objects added into Cache from within a transaction

2016-09-16 Thread vkulichenko
Andrey, This was just a wrong link. Nikolay already provided the correct one above: https://issues.apache.org/jira/browse/IGNITE-3478 -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-does-not-include-objects-added-into-Cache-from-within-a-transaction

Re: Query does not include objects added into Cache from within a transaction

2016-09-16 Thread Andrey Kornev
Query does not include objects added into Cache from within a transaction Hi, SQL queries are currently not transactional. There is a ticket for this improvement: https://ggsystems.atlassian.net/browse/IGN-4666 -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/

Re: Query does not include objects added into Cache from within a transaction

2016-09-14 Thread vkulichenko
this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-does-not-include-objects-added-into-Cache-from-within-a-transaction-tp7651p7752.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Query does not include objects added into Cache from within a transaction

2016-09-14 Thread akaptsan
t: http://apache-ignite-users.70518.x6.nabble.com/Query-does-not-include-objects-added-into-Cache-from-within-a-transaction-tp7651p7747.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Query does not include objects added into Cache from within a transaction

2016-09-14 Thread Nikolai Tikhonov
rate concurrent transactions. > > -Val > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/Query-does-not-include-objects- > added-into-Cache-from-within-a-transaction-tp7651p7717.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >

Re: Query does not include objects added into Cache from within a transaction

2016-09-13 Thread akaptsan
ll need to redesign huge amount of application code. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-does-not-include-objects-added-into-Cache-from-within-a-transaction-tp7651p7723.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Query does not include objects added into Cache from within a transaction

2016-09-13 Thread vkulichenko
action and update transaction are two separate concurrent transactions. -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-does-not-include-objects-added-into-Cache-from-within-a-transaction-tp7651p7717.html Sent from the Apache Ignite Users mailing list

Re: Query does not include objects added into Cache from within a transaction

2016-09-13 Thread Denis Magda
itical problem. Can you estimate when it will be fixed? > (I don't have access to jira) > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Query-does-not-include-objects-added-into-Cache-from-within-a-transaction-tp7651p7703.

Re: Query does not include objects added into Cache from within a transaction

2016-09-13 Thread akaptsan
I would say it's critical problem. Can you estimate when it will be fixed? (I don't have access to jira) -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-does-not-include-objects-added-into-Cache-from-within-a-transaction-tp7651p7703.html Sen

Re: Query does not include objects added into Cache from within a transaction

2016-09-12 Thread vkulichenko
Hi, SQL queries are currently not transactional. There is a ticket for this improvement: https://ggsystems.atlassian.net/browse/IGN-4666 -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-does-not-include-objects-added-into-Cache-from-within-a

Query does not include objects added into Cache from within a transaction

2016-09-10 Thread UCDeveloper
state before the transaction. Thanks -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Query-does-not-include-objects-added-into-Cache-from-within-a-transaction-tp7651.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.