Fwd: Getting javax.cache.CacheException after upgrading to Ignite 2.7

[Prasad Bhalerao]

Can someone please explain if anything has changed in ignite 2.7.

Started getting this exception after upgrading to 2.7.


---------- Forwarded message ---------
From: Prasad Bhalerao <[hidden email]>
Date: Fri 4 Jan, 2019, 8:41 PM
Subject: Re: Getting javax.cache.CacheException after upgrading to Ignite
2.7
To: <[hidden email]>


Can someone please help me with this?

On Thu 3 Jan, 2019, 7:15 PM Prasad Bhalerao <[hidden email]
wrote:

> Hi
>
> After upgrading to 2.7 version I am getting following exception. I am
> executing a SELECT sql inside optimistic transaction with serialization
> isolation level.
>
> 1) Has anything changed from 2.6 to 2.7 version?  This work fine prior to
> 2.7 version.
>
> After changing it to Pessimistic and isolation level to REPEATABLE_READ it
> works fine.
>
>
>
>
>
>
> *javax.cache.CacheException: Only pessimistic repeatable read transactions
> are supported at the moment.at
> org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:697)at
> org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:636)at
> org.apache.ignite.internal.processors.cache.GatewayProtectedCacheProxy.query(GatewayProtectedCacheProxy.java:388)at
> com.qualys.agms.grid.dao.AbstractDataGridDAO.getFieldResultsByCriteria(AbstractDataGridDAO.java:85)*
>
> Thanks,
> Prasad
>

[dmagda]

Hello,

Ignite versions prior to 2.7 never supported transactions for SQL queries.
You were enlisting SQL in transactions for your own risk. Ignite version
2.7 introduced true transactional support for SQL based on MVCC. Presently
it's in beta with GA to be available around Q2-Q3 this year. The community
is working on optimizations.

Please refer to this docs for more details:
https://apacheignite.readme.io/docs/multiversion-concurrency-control
https://apacheignite-sql.readme.io/docs/transactions
https://apacheignite-sql.readme.io/docs/multiversion-concurrency-control

--
Denis

On Sat, Jan 5, 2019 at 7:48 PM Prasad Bhalerao <[hidden email]>
wrote:

> Can someone please explain if anything has changed in ignite 2.7.
>
> Started getting this exception after upgrading to 2.7.
>
>
> ---------- Forwarded message ---------
> From: Prasad Bhalerao <[hidden email]>
> Date: Fri 4 Jan, 2019, 8:41 PM
> Subject: Re: Getting javax.cache.CacheException after upgrading to Ignite
> 2.7
> To: <[hidden email]>
>
>
> Can someone please help me with this?
>
> On Thu 3 Jan, 2019, 7:15 PM Prasad Bhalerao <[hidden email]
> wrote:
>
> > Hi
> >
> > After upgrading to 2.7 version I am getting following exception. I am
> > executing a SELECT sql inside optimistic transaction with serialization
> > isolation level.
> >
> > 1) Has anything changed from 2.6 to 2.7 version?  This work fine prior to
> > 2.7 version.
> >
> > After changing it to Pessimistic and isolation level to REPEATABLE_READ
> it
> > works fine.
> >
> >
> >
> >
> >
> >
> > *javax.cache.CacheException: Only pessimistic repeatable read
> transactions
> > are supported at the moment.at
> >
> org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:697)at
> >
> org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:636)at
> >
> org.apache.ignite.internal.processors.cache.GatewayProtectedCacheProxy.query(GatewayProtectedCacheProxy.java:388)at
> >
> com.qualys.agms.grid.dao.AbstractDataGridDAO.getFieldResultsByCriteria(AbstractDataGridDAO.java:85)*
> >
> > Thanks,
> > Prasad
> >
>