Re: Migrate from 2.6 to 2.7

[whiteman <wh...@centrum.cz>]

Hi guys,

As far as I am concerned this is a breaking behaviour. In Apache Ignite v
2.5 it was possible to have the SQL query inside the optimistic serializable
transaction. Point here is that SQL query might not be part of the
transaction (no guarantees) but was at least performed. In 2.7 this code
won't work at all. The advice to move all SQL queries outside the
transactions is in real world not possible. It would greatly increased
complexity of the codebase. My question is if there is a switch for enabling
pre 2.7 behaviour. 

THanks,
Cheers,
D.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Migrate from 2.6 to 2.7

[whiteman <wh...@centrum.cz>]

Hello!

thanks for prompt resolution, will try once 2.8 is out.

Best!



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Migrate from 2.6 to 2.7

[Ilya Kasnacheev <il...@gmail.com>]

Hello!

Cross-posting: I have filed a blocker ticket about it.
https://issues.apache.org/jira/browse/IGNITE-10884

Regards,
-- 
Ilya Kasnacheev


чт, 3 янв. 2019 г. в 03:24, Denis Magda <dm...@apache.org>:

> Are you using JDBC/ODBC drivers? Just want to know why it's hard to
> execute SQL queries outside of transactions.
>
> Can you switch to pessimistic transactions instead?
>
> --
> Denis
>
> On Wed, Jan 2, 2019 at 7:24 AM whiteman <wh...@centrum.cz> wrote:
>
>> Hi guys,
>>
>> As far as I am concerned this is a breaking behaviour. In Apache Ignite v
>> 2.5 it was possible to have the SQL query inside the optimistic
>> serializable
>> transaction. Point here is that SQL query might not be part of the
>> transaction (no guarantees) but was at least performed. In 2.7 this code
>> won't work at all. The advice to move all SQL queries outside the
>> transactions is in real world not possible. It would greatly increased
>> complexity of the codebase. My question is if there is a switch for
>> enabling
>> pre 2.7 behaviour.
>>
>> THanks,
>> Cheers,
>> D.
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>

Re: Migrate from 2.6 to 2.7

[whiteman <wh...@centrum.cz>]

Hi,

No, I am not using JDBC driver.
Re switching to the pessimistic transaction, tried but is not working
correctly in some cases, for instance, .clear() on caches and some more...
which is fine as Igniters state it's not production ready yet. Obviously
happy guys you are adding new transaction semantics :)



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Migrate from 2.6 to 2.7

[Denis Magda <dm...@apache.org>]

Are you using JDBC/ODBC drivers? Just want to know why it's hard to execute
SQL queries outside of transactions.

Can you switch to pessimistic transactions instead?

--
Denis

On Wed, Jan 2, 2019 at 7:24 AM whiteman <wh...@centrum.cz> wrote:

> Hi guys,
>
> As far as I am concerned this is a breaking behaviour. In Apache Ignite v
> 2.5 it was possible to have the SQL query inside the optimistic
> serializable
> transaction. Point here is that SQL query might not be part of the
> transaction (no guarantees) but was at least performed. In 2.7 this code
> won't work at all. The advice to move all SQL queries outside the
> transactions is in real world not possible. It would greatly increased
> complexity of the codebase. My question is if there is a switch for
> enabling
> pre 2.7 behaviour.
>
> THanks,
> Cheers,
> D.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>