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

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

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

://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

Hi Naveen, When you’re using Ignite SQL queries they aren’t processed by the Oracle’s SQL engine. Instead, Ignite will process the SQL itself (via H2 database engine) and get the data from its cache. For that to work you need to first preload the data to the cache via a CacheStore.loadCache()