Best approach for jdbc sink into ignite cache with write behind .net client and server 3rd party application

classic Classic list List threaded Threaded
4 messages Options
siva siva
Reply | Threaded
Open this post in threaded view
|

Best approach for jdbc sink into ignite cache with write behind .net client and server 3rd party application

Hi,
I have  .net core client and Server application Ignite v2.7.6.

All tables and indexes created through IgniteConfiguration and QueryEntity
in .net application at the time of cache creation.

currently i am using from source to
client.putAsync(key,tableModelClassObject) to put data in cache as well
write behind into SQL Server Database.

but now planning to sink source data from jdbc into ignite cache as well as
write behind for sql server with same follow instead of using
client.putAsync()...using JDBC.

All kind of suggestion are welcome.what kind of changes i need to do if any
refrence link.

Thank you.




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
ptupitsyn ptupitsyn
Reply | Threaded
Open this post in threaded view
|

Re: Best approach for jdbc sink into ignite cache with write behind .net client and server 3rd party application

Hi,

The question is not very clear - do you have any difficulties with JDBC?

On Tue, Jan 14, 2020 at 7:28 AM siva <[hidden email]> wrote:
Hi,
I have  .net core client and Server application Ignite v2.7.6.

All tables and indexes created through IgniteConfiguration and QueryEntity
in .net application at the time of cache creation.

currently i am using from source to
client.putAsync(key,tableModelClassObject) to put data in cache as well
write behind into SQL Server Database.

but now planning to sink source data from jdbc into ignite cache as well as
write behind for sql server with same follow instead of using
client.putAsync()...using JDBC.

All kind of suggestion are welcome.what kind of changes i need to do if any
refrence link.

Thank you.




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
siva siva
Reply | Threaded
Open this post in threaded view
|

Re: Best approach for jdbc sink into ignite cache with write behind .net client and server 3rd party application

Hi,Thanks for reply.
yes,i am unable parse result inside writeAll() method.
three kind of difficulities facing in writeAll() method while doing insert
statement execution either from java jdbc client or sqlline.
1.Unknown pair [platformId=1, typeId=1505474372]
2.Not enough data in stream [expected=4,receieve=0]
3. on writeAll() method args entries expand key and value both having null





--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
ptupitsyn ptupitsyn
Reply | Threaded
Open this post in threaded view
|

Re: Best approach for jdbc sink into ignite cache with write behind .net client and server 3rd party application

1: answered in another email, please see my reply there:

2 and 3: please provide a reproducer

On Tue, Jan 14, 2020 at 7:27 PM siva <[hidden email]> wrote:
Hi,Thanks for reply.
yes,i am unable parse result inside writeAll() method.
three kind of difficulities facing in writeAll() method while doing insert
statement execution either from java jdbc client or sqlline.
1.Unknown pair [platformId=1, typeId=1505474372]
2.Not enough data in stream [expected=4,receieve=0]
3. on writeAll() method args entries expand key and value both having null





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