You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by kotamrajuyashasvi <ko...@gmail.com> on 2018/01/08 09:12:35 UTC

Transaction operations using the Ignite Thin Client Protocol

Hi

I would like to perform Ignite Transaction operations from a C++ program
using the Ignite Thin Client Protocol. Is it possible to do so ? If this
feature is not available now, will it be added in future ? 



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

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by kotamrajuyashasvi <ko...@gmail.com>.
Hi

In Ignite ODBC all operations are sql based and as you mentioned sql
transactions feature is not available yet. So cannot use it. So just
exploring all light weight C++ client  options available which support
Ignite Transactions.



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

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Evgenii Zhuravlev <e....@gmail.com>.
Right now, this client implemented only for .NET, but it's not even
released yet.

I'm not sure about transactions since design document doesn't contain any
information about it.

BTW, why you don't want to use ODBC from C++?


2018-01-08 13:13 GMT+03:00 kotamrajuyashasvi <ko...@gmail.com>:

> Hi
>
> according to
> https://cwiki.apache.org/confluence/display/IGNITE/IEP-
> 9+Thin+Client+Protocol
>
> we can perform cache operations like get(),put() etc using thin client
> protocol which uses tcp socket communication with the Ignite server. I
> would
> like to know if similarly we can send a request to start a transaction or
> committing / rolling back transaction.
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by kotamrajuyashasvi <ko...@gmail.com>.
Hi

according to 
https://cwiki.apache.org/confluence/display/IGNITE/IEP-9+Thin+Client+Protocol

we can perform cache operations like get(),put() etc using thin client
protocol which uses tcp socket communication with the Ignite server. I would
like to know if similarly we can send a request to start a transaction or
committing / rolling back transaction.  




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

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Evgenii Zhuravlev <e....@gmail.com>.
Could you tell, what do you understand as ignite Thin Client Protocol?

Evgenii

2018-01-08 12:39 GMT+03:00 kotamrajuyashasvi <ko...@gmail.com>:

> Hi
>
> Thanks for your response.
> I would like to know if Transaction operations on Ignite cache at key-value
> level(not SQL) can be performed using the Thin Client Protocol.
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by kotamrajuyashasvi <ko...@gmail.com>.
Hi

Thanks for your response. 
I would like to know if Transaction operations on Ignite cache at key-value
level(not SQL) can be performed using the Thin Client Protocol.



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

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Evgenii Zhuravlev <e....@gmail.com>.
Hi,

Transactional SQL is not available yet, it will be fully available when
this ticket will be implemented:
https://issues.apache.org/jira/browse/IGNITE-3478

Evgenii

2018-01-08 12:12 GMT+03:00 kotamrajuyashasvi <ko...@gmail.com>:

> Hi
>
> I would like to perform Ignite Transaction operations from a C++ program
> using the Ignite Thin Client Protocol. Is it possible to do so ? If this
> feature is not available now, will it be added in future ?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Ivan Pavlukhin <vo...@gmail.com>.
It worth noting that users should be cautious with SQL transactions.
As fair SQL transactions are supported only for TRANSACTIONAL_SNAPSHOT
mode which are still kind of experimental feature [1].

[1] https://apacheignite.readme.io/docs/multiversion-concurrency-control

пт, 6 дек. 2019 г. в 15:12, Ilya Kasnacheev <il...@gmail.com>:
>
> Hello!
>
> As we have discussed privately, ODBC is actually the C++ thin SQL client, and it supports transactions since 2.7.
>
> C++ code should look forward to using ODBC to communicate with Ignite.
>
> Regards,
> --
> Ilya Kasnacheev
>
>
> пн, 2 дек. 2019 г. в 16:26, Igor Sapego <is...@apache.org>:
>>
>> Ivan,
>>
>> You are right. Though now we have transactions support in thin client protocol,
>> It is only now implemented for Java. Also, C++ thin client yet to support SQL.
>>
>> Best Regards,
>> Igor
>>
>>
>> On Sat, Nov 30, 2019 at 9:35 AM Ivan Pavlukhin <vo...@gmail.com> wrote:
>>>
>>> Igor,
>>>
>>> Could you please elaborate whether C++ thin client is going to have
>>> transactions support in 2.8? AFAIR, it was implemented only for Java
>>> thin client.
>>>
>>> пт, 29 нояб. 2019 г. в 18:29, Stephen Darlington
>>> <st...@gridgain.com>:
>>>
>>> >
>>> > The ticket says “Fix version: 2.8” so I would assume it would be available then. Currently planned for late January.
>>> >
>>> > > On 29 Nov 2019, at 13:58, dkurzaj <do...@hotmail.fr> wrote:
>>> > >
>>> > > Hello,
>>> > >
>>> > > Since this improvement : https://issues.apache.org/jira/browse/IGNITE-9410
>>> > > is resolved, I'd assume that it is now possible to do SQL transactions using
>>> > > the C++ thin client, though I'm not sure it is yet since I did not find
>>> > > documentation about that. Would someone happen to know more about this
>>> > > subject?
>>> > >
>>> > > Thank you!
>>> > >
>>> > > Dorian
>>> > >
>>> > >
>>> > >
>>> > > --
>>> > > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>> >
>>> >
>>>
>>>
>>> --
>>> Best regards,
>>> Ivan Pavlukhin



-- 
Best regards,
Ivan Pavlukhin

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

As we have discussed privately, ODBC is actually the C++ thin SQL client,
and it supports transactions since 2.7.

C++ code should look forward to using ODBC to communicate with Ignite.

Regards,
-- 
Ilya Kasnacheev


пн, 2 дек. 2019 г. в 16:26, Igor Sapego <is...@apache.org>:

> Ivan,
>
> You are right. Though now we have transactions support in thin client
> protocol,
> It is only now implemented for Java. Also, C++ thin client yet to support
> SQL.
>
> Best Regards,
> Igor
>
>
> On Sat, Nov 30, 2019 at 9:35 AM Ivan Pavlukhin <vo...@gmail.com>
> wrote:
>
>> Igor,
>>
>> Could you please elaborate whether C++ thin client is going to have
>> transactions support in 2.8? AFAIR, it was implemented only for Java
>> thin client.
>>
>> пт, 29 нояб. 2019 г. в 18:29, Stephen Darlington
>> <st...@gridgain.com>:
>>
>> >
>> > The ticket says “Fix version: 2.8” so I would assume it would be
>> available then. Currently planned for late January.
>> >
>> > > On 29 Nov 2019, at 13:58, dkurzaj <do...@hotmail.fr> wrote:
>> > >
>> > > Hello,
>> > >
>> > > Since this improvement :
>> https://issues.apache.org/jira/browse/IGNITE-9410
>> > > is resolved, I'd assume that it is now possible to do SQL
>> transactions using
>> > > the C++ thin client, though I'm not sure it is yet since I did not
>> find
>> > > documentation about that. Would someone happen to know more about this
>> > > subject?
>> > >
>> > > Thank you!
>> > >
>> > > Dorian
>> > >
>> > >
>> > >
>> > > --
>> > > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>> >
>> >
>>
>>
>> --
>> Best regards,
>> Ivan Pavlukhin
>>
>

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Igor Sapego <is...@apache.org>.
Ivan,

You are right. Though now we have transactions support in thin client
protocol,
It is only now implemented for Java. Also, C++ thin client yet to support
SQL.

Best Regards,
Igor


On Sat, Nov 30, 2019 at 9:35 AM Ivan Pavlukhin <vo...@gmail.com> wrote:

> Igor,
>
> Could you please elaborate whether C++ thin client is going to have
> transactions support in 2.8? AFAIR, it was implemented only for Java
> thin client.
>
> пт, 29 нояб. 2019 г. в 18:29, Stephen Darlington
> <st...@gridgain.com>:
>
> >
> > The ticket says “Fix version: 2.8” so I would assume it would be
> available then. Currently planned for late January.
> >
> > > On 29 Nov 2019, at 13:58, dkurzaj <do...@hotmail.fr> wrote:
> > >
> > > Hello,
> > >
> > > Since this improvement :
> https://issues.apache.org/jira/browse/IGNITE-9410
> > > is resolved, I'd assume that it is now possible to do SQL transactions
> using
> > > the C++ thin client, though I'm not sure it is yet since I did not find
> > > documentation about that. Would someone happen to know more about this
> > > subject?
> > >
> > > Thank you!
> > >
> > > Dorian
> > >
> > >
> > >
> > > --
> > > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
> >
> >
>
>
> --
> Best regards,
> Ivan Pavlukhin
>

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Ivan Pavlukhin <vo...@gmail.com>.
Igor,

Could you please elaborate whether C++ thin client is going to have
transactions support in 2.8? AFAIR, it was implemented only for Java
thin client.

пт, 29 нояб. 2019 г. в 18:29, Stephen Darlington
<st...@gridgain.com>:

>
> The ticket says “Fix version: 2.8” so I would assume it would be available then. Currently planned for late January.
>
> > On 29 Nov 2019, at 13:58, dkurzaj <do...@hotmail.fr> wrote:
> >
> > Hello,
> >
> > Since this improvement : https://issues.apache.org/jira/browse/IGNITE-9410
> > is resolved, I'd assume that it is now possible to do SQL transactions using
> > the C++ thin client, though I'm not sure it is yet since I did not find
> > documentation about that. Would someone happen to know more about this
> > subject?
> >
> > Thank you!
> >
> > Dorian
> >
> >
> >
> > --
> > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
>


--
Best regards,
Ivan Pavlukhin

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Stephen Darlington <st...@gridgain.com>.
The ticket says “Fix version: 2.8” so I would assume it would be available then. Currently planned for late January.

> On 29 Nov 2019, at 13:58, dkurzaj <do...@hotmail.fr> wrote:
> 
> Hello,
> 
> Since this improvement : https://issues.apache.org/jira/browse/IGNITE-9410
> is resolved, I'd assume that it is now possible to do SQL transactions using
> the C++ thin client, though I'm not sure it is yet since I did not find
> documentation about that. Would someone happen to know more about this
> subject?
> 
> Thank you!
> 
> Dorian
> 
> 
> 
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/



Re: Transaction operations using the Ignite Thin Client Protocol

Posted by dkurzaj <do...@hotmail.fr>.
Hello,

Since this improvement : https://issues.apache.org/jira/browse/IGNITE-9410
is resolved, I'd assume that it is now possible to do SQL transactions using
the C++ thin client, though I'm not sure it is yet since I did not find
documentation about that. Would someone happen to know more about this
subject?

Thank you!

Dorian



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

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Pavel Tupitsyn <pt...@apache.org>.
Hi Denis,

Yes, transactions in thin client protocol are surely very important, I
think we should add them soon (in 2.5).
Ticket: https://issues.apache.org/jira/browse/IGNITE-7369

And yes, server node will handle everything, client just performs TX_START,
TX_COMMIT, TX_ROLLBACK operations.

Pavel

On Wed, Jan 10, 2018 at 1:08 AM, Denis Magda <dm...@apache.org> wrote:

> + dev list
>
> Igniters, Pavel,
>
> I think we need to bring support for key-value transactions to one of the
> future versions. As far as I understand, a server node, a thin client will
> be connected to, will be the transaction coordinator and the client will
> simply offloading everything to it. What do you think?
>
> —
> Denis
>
> > On Jan 8, 2018, at 1:12 AM, kotamrajuyashasvi <
> kotamrajuyashasvi@gmail.com> wrote:
> >
> > Hi
> >
> > I would like to perform Ignite Transaction operations from a C++ program
> > using the Ignite Thin Client Protocol. Is it possible to do so ? If this
> > feature is not available now, will it be added in future ?
> >
> >
> >
> > --
> > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
>

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Pavel Tupitsyn <pt...@apache.org>.
Hi Denis,

Yes, transactions in thin client protocol are surely very important, I
think we should add them soon (in 2.5).
Ticket: https://issues.apache.org/jira/browse/IGNITE-7369

And yes, server node will handle everything, client just performs TX_START,
TX_COMMIT, TX_ROLLBACK operations.

Pavel

On Wed, Jan 10, 2018 at 1:08 AM, Denis Magda <dm...@apache.org> wrote:

> + dev list
>
> Igniters, Pavel,
>
> I think we need to bring support for key-value transactions to one of the
> future versions. As far as I understand, a server node, a thin client will
> be connected to, will be the transaction coordinator and the client will
> simply offloading everything to it. What do you think?
>
> —
> Denis
>
> > On Jan 8, 2018, at 1:12 AM, kotamrajuyashasvi <
> kotamrajuyashasvi@gmail.com> wrote:
> >
> > Hi
> >
> > I would like to perform Ignite Transaction operations from a C++ program
> > using the Ignite Thin Client Protocol. Is it possible to do so ? If this
> > feature is not available now, will it be added in future ?
> >
> >
> >
> > --
> > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
>

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Denis Magda <dm...@apache.org>.
+ dev list

Igniters, Pavel,

I think we need to bring support for key-value transactions to one of the future versions. As far as I understand, a server node, a thin client will be connected to, will be the transaction coordinator and the client will simply offloading everything to it. What do you think?

—
Denis

> On Jan 8, 2018, at 1:12 AM, kotamrajuyashasvi <ko...@gmail.com> wrote:
> 
> Hi
> 
> I would like to perform Ignite Transaction operations from a C++ program
> using the Ignite Thin Client Protocol. Is it possible to do so ? If this
> feature is not available now, will it be added in future ? 
> 
> 
> 
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/


Re: Transaction operations using the Ignite Thin Client Protocol

Posted by kotamrajuyashasvi <ko...@gmail.com>.
Hi

Thanks for your response.

The project I'm working on requires many C++ processes running on a machine
with each C++ process to perform cache operations on Ignite Cluster
transactionally. Hence Each Individual C++ process has to start an Ignite
C++ Client node with in its process. But there will be a large number of C++
processes running and starting Ignite C++ Client node with in each of the
process would be memory Intensive. Also there are some other issues while
working with Ignite C++, which could not be replicated/reproduced here and
due to time constraint we are not able to focus on this replication issue.
Hence exploring other options.



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

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Dmitriy Setrakyan <ds...@apache.org>.
Hi,

Is there a reason why you do not want to use the C++ client that comes with
Ignite?

https://apacheignite-cpp.readme.io/docs/transactions

D.

On Mon, Jan 8, 2018 at 2:12 AM, kotamrajuyashasvi <
kotamrajuyashasvi@gmail.com> wrote:

> Hi
>
> I would like to perform Ignite Transaction operations from a C++ program
> using the Ignite Thin Client Protocol. Is it possible to do so ? If this
> feature is not available now, will it be added in future ?
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Transaction operations using the Ignite Thin Client Protocol

Posted by Denis Magda <dm...@apache.org>.
+ dev list

Igniters, Pavel,

I think we need to bring support for key-value transactions to one of the future versions. As far as I understand, a server node, a thin client will be connected to, will be the transaction coordinator and the client will simply offloading everything to it. What do you think?

—
Denis

> On Jan 8, 2018, at 1:12 AM, kotamrajuyashasvi <ko...@gmail.com> wrote:
> 
> Hi
> 
> I would like to perform Ignite Transaction operations from a C++ program
> using the Ignite Thin Client Protocol. Is it possible to do so ? If this
> feature is not available now, will it be added in future ? 
> 
> 
> 
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/