Re: JDBC client disconnected without any exception

2019-04-29 Thread Ilya Kasnacheev
Hello! Is it possible that the process was killed by OOM killer? This should be visible in dmesg. Otherwise, we have not heard of such errors. Please share logs of all nodes in cluster, including this client. Regards, -- Ilya Kasnacheev вс, 28 апр. 2019 г. в 10:45, shivakumar : > Hi all, >

JDBC client disconnected without any exception

2019-04-28 Thread shivakumar
Hi all, I have created 3 tables and trying to ingest (batch commit with JDBC connection) 50 crore records to each table parallely, with 5000 records as batch commit size, after ingesting around 25 to 30 crore records the program which ingest data using JDBC connection is stopping without any

Re: JDBC Client Node connection number problem

2019-02-14 Thread gn01887818
Thank you. I will give it a try. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: JDBC Client Node connection number problem

2019-02-14 Thread Ilya Kasnacheev
Hello! Have you tried streaming mode? Client node has streaming mode and thin client also has streaming mode. It's not the question of number of parallel operations. Regards, -- Ilya Kasnacheev чт, 14 февр. 2019 г. в 05:41, gn01887818 : > Reason: Need to improve write DB performance. > The

Re: JDBC Client Node connection number problem

2019-02-13 Thread gn01887818
Reason: Need to improve write DB performance. The number of connections will affect the number of DBs written, so ask how to increase the number of connections. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: JDBC Client Node connection number problem

2019-02-13 Thread Ilya Kasnacheev
But if the JDBC Client Node Driver asks for 128 DB connections, it actually > creates up to seven connections. > (The number of connections is floating between 1 and 7) > > Will the JDBC Client Node Driver, > Can I establish the corresponding number of connections according to the

JDBC Client Node connection number problem

2019-02-11 Thread gn01887818
If the JDBC Thin Driver requires 128 DB connections, there are actually 128 connections. But if the JDBC Client Node Driver asks for 128 DB connections, it actually creates up to seven connections. (The number of connections is floating between 1 and 7) Will the JDBC Client Node Driver, Can I

JDBC Client Node connection number problem

2019-02-11 Thread gn01887818
If the JDBC Thin Driver requires 128 DB connections, there are actually 128 connections. But if the JDBC Client Node Driver asks for 128 DB connections, it actually creates up to seven connections. (The number of connections is floating between 1 and 7) Will the JDBC Client Node Driver, Can I

Re: Spring Cloud + Jdbc client driver

2019-02-07 Thread Ilya Kasnacheev
Hello! Is using JDBC thin driver an option? It has the bare minimum of settings. Regards, -- Ilya Kasnacheev пн, 4 февр. 2019 г. в 19:36, nikfuri : > Thanks for reply. I want to pass variables to ignite config xml. i get this > variables from git. If i correctly understand, ignite starts

Re: Spring Cloud + Jdbc client driver

2019-02-04 Thread nikfuri
Thanks for reply. I want to pass variables to ignite config xml. i get this variables from git. If i correctly understand, ignite starts it's own context which unaware of my context. Is there way to make ignite context aware of my application context? -- Sent from:

Re: Spring Cloud + Jdbc client driver

2019-02-04 Thread Michael Cherkasov
Hi, Could you please describe your question in more details? I think it's not clear what you are trying to ask. Thanks, Mike. пн, 4 февр. 2019 г. в 16:44, nikfuri : > Hi! Is there any availability to pass properties gained through config > server > to jdbc config file? > > > > -- > Sent from:

Spring Cloud + Jdbc client driver

2019-02-04 Thread nikfuri
Hi! Is there any availability to pass properties gained through config server to jdbc config file? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Sample configuration for one cache [name=KSDATA] and use it with JDBC (client do not find schema)

2018-12-06 Thread Taras Ledkov
quot;org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi">                   class="org.apache.ignite.configuration.CacheConfiguration">               When I use JDBC client (client & server 2.6.0 or 2.7.0) It seems conenct well but any SQL is not run

Sample configuration for one cache [name=KSDATA] and use it with JDBC (client do not find schema)

2018-12-06 Thread Philippe CEROU
-beans.xsd;> 10.200.2.10210.200.2.10510.200.4.10310.200.4.10610.200.6.10110.200.6.104 When I use JDBC client (client &

Re: custom plugin question - jdbc client

2018-08-29 Thread wt
Hi Taras I am slightly confused. You are mentioning sslcontext and looking at those related classes it doesn't appear to offer authentication and authorization. Here is where i currently am with this project. I have a white list plugin that i will apply to server nodes when they join. I have

Re: custom plugin question - jdbc client

2018-08-28 Thread Taras Ledkov
/ClientConnectorConfiguration.html) [2] See `sslFactory` property: https://apacheignite-sql.readme.io/docs/jdbc-driver#jdbc-thin-driver [3] https://apacheignite-sql.readme.io/docs/jdbc-client-driver On 28.08.2018 12:39, wt wrote: i have finally managed to get a plugin working for a white list on ignite 2.6. I am now

custom plugin question - jdbc client

2018-08-28 Thread wt
i have finally managed to get a plugin working for a white list on ignite 2.6. I am now going to start working on an authorization for users connecting to the cluster. How can i get clients pass through a kerberos ticket to the cluster? I think i need to override the authorization context class

RE: Does Merge statement (DML) work with JDBC client driver

2018-03-09 Thread vkulichenko
Naveen, Ignite provides out of the box implementation for RDBMS. The easiest way to integration would be to use Web Console to generate all required POJO classes and configurations: https://apacheignite-tools.readme.io/docs/automatic-rdbms-integration -Val -- Sent from:

RE: Does Merge statement (DML) work with JDBC client driver

2018-03-09 Thread Naveen
Hi Stan I do not want to Oracle with native persistence, I only wanted to use Oracle persistent layer. Are you sure, we need to implement cacheStore for each table we have in the cluster ? If that is the case, we need to have separate code base for Oracle as persistence layer and another

RE: Does Merge statement (DML) work with JDBC client driver

2018-03-07 Thread Stanislav Lukyanov
://apacheignite.readme.io/docs/3rd-party-store. Thanks, Stan From: Naveen Sent: 7 марта 2018 г. 15:20 To: user@ignite.apache.org Subject: RE: Does Merge statement (DML) work with JDBC client driver Hi Stan Currently I am using JDBC thin driver to connect to Ignite cluster for both read/write. Below is the config xml

RE: Does Merge statement (DML) work with JDBC client driver

2018-03-07 Thread Stanislav Lukyanov
on which persistence mechanism is enabled. For the reference on the SQL syntax supported by Ignite please see https://apacheignite-sql.readme.io/docs/dml. Thanks, Stan From: Naveen Sent: 7 марта 2018 г. 9:11 To: user@ignite.apache.org Subject: Does Merge statement (DML) work with JDBC client driver Hi

Does Merge statement (DML) work with JDBC client driver

2018-03-06 Thread Naveen
Hi We are using Ignite 2.3 We would like to have 2 Ignite clusters running - one with Ignite native persistence and second with Oracle database as persistent layer. So keeping this in mind, we would like to the build our code base which should work for both the clusters. I have read that

Re: JDBC Client

2017-11-16 Thread beginner miau
Hi Mike, Thanks for the reply and explanation. I have further curious question. 1. If use thick driver, can we use JDBC connection pooling? 2. How/What is the process to backup the data in Apache Ignite? 3. Let's say initially I start Apache Ignite with only one node (cache mode = replicated,

Re: JDBC Client

2017-11-16 Thread Mikhail
Hi Miau, 1. no, thin client won't reconnect to cluster, you need to handle an exception and re-connect to other servers manually. I create a ticket to improve this part: https://issues.apache.org/jira/browse/IGNITE-6942 2. Thick driver uses ignite instance under the hood, so ignite client will

JDBC Client

2017-11-16 Thread beginner miau
Hi, I am beginner with Apache Ignite and have few questions related to JDBC. 1. Let's say I have 2 node in 2 different machine (cache mode = replicated, native persistence is turned on). I want to connect to the Apache Ignite server using JDBC thin client. In the JDBC thin client URL, I only can