Query on using Ignite as persistence data and processing layer

Hi, I am looking at a feasibility of using Ignite as a persistence layer instead of a mySql/Postgres db where we do lot of processing before sending data to our rest-api. 1. Is it good to use ignite as a storage? 2. Is it efficient to do so much processing of data in ignite? 3. What is the

Re: [EXTERNAL] Re: Exception while trying to access cache via JDBC API

I went to local gradle repo and manually deleted other h2 versions. It’s working now. I have one more query – is there a way I can make ‘ignite-http-rest’ work with spring-boot? Last time when I checked with one of Ignite dev they mentioned that I can’t use it with boot. Without rest-api, I need

Class objects are fetched as string when JDBC api is used

Hi, After adding data to cache, i am try to fetch it using JDBC api and below statement - *rs = conn.createStatement().executeQuery("select * from SalesModel where _key=" + storeId);* Issue: Values other than class objects is retrieved correctly but class objects are taken as strings as shown

Re: [EXTERNAL] Re: Exception while trying to access cache via JDBC API

I am starting my server node within my boot app[1]. Both my client and server nodes start from same code but I will get the service part with starts client out of it later. How can I not start ignite server and still manage to use same config in my external server node? (bold part below). [1] -

Re: [EXTERNAL] Re: Exception while trying to access cache via JDBC API

o you can check where H2 classes come from: System.out.println(org.h2.Driver.class.getProtectionDomain().getCodeSource().getLocation()); In the end you must have in classpath only h2-1.4.191.jar and no other versions. Sergi 2016-11-03 9:13 GMT+03:00 chevy <[hidden email]>: There are no remote nodes

Re: [EXTERNAL] Re: Exception while trying to access cache via JDBC API

e that you must have correct H2 version in classpath on all the cluster nodes. BTW, can you please post exception stack trace from remote node? Sergi 2016-11-02 21:41 GMT+03:00 chevy <[hidden email]>: I see only one dependency which is coming from ignite-indexing jar

Re: [EXTERNAL] Re: Exception while trying to access cache via JDBC API

t; <chetan.v.ya...@target.com> Subject: Re: [EXTERNAL] Re: Exception while trying to access cache via JDBC API The problem here is that you have a wrong H2 version in classpath. Most probably this wrong transitive dependency comes from Spring Boot, you need to exclude it. Sergi 2016-11-02 20

Re: [EXTERNAL] Re: Exception while trying to access cache via JDBC API

It works perfectly without spring-boot (previously tested) but I need to go with spring-boot as business logic needs faster execution using boot features. Is there any workaround with which I can fix this problem? -- Regards, Chetan. From: "Sergej Sidorov [via Apache Ignite Users]"

Re: [EXTERNAL] Re: Exception while trying to access cache via JDBC API

There is a issue with downgrading h2 jar. I am working with spring-boot and I had tried this earlier. It throws below exception - [17:32:43] Ignite node stopped OK [name=ignite-jdbc-driver-297d7d9b-ee4c-47b8-abcf-fe4812374296, uptime=00:00:00:233] java.sql.SQLException: Failed to query Ignite.

Exception while trying to access cache via JDBC API

Hi, Below is my code where I am trying to access ignite cache using JDBC API. I am getting exception as mentioned after my code - try { Class.forName("org.apache.ignite.IgniteJdbcDriver"); try (Connection conn = DriverManager.getConnection(

Re: [EXTERNAL] Re: SLF4J AND LOG4J delegation exception with ignite dependency

"Chetan.V.Yadav" <chetan.v.ya...@target.com> Subject: Re: [EXTERNAL] Re: SLF4J AND LOG4J delegation exception with ignite dependency Hi, Could you please, provide your gradle file? On Mon, Oct 24, 2016 at 9:13 PM, chevy <[hidden email]> wrote: My current dependency looks li

Re: [EXTERNAL] Re: SLF4J AND LOG4J delegation exception with ignite dependency

uot;org.slf4j", name: "slf4j-log4j12" } 2) Ignite 1.6 supports h2 1.3 version. You need to use last version 1.7 of Ignite, with support h2 1.4. On Sat, Oct 22, 2016 at 11:58 AM, chevy <[hidden email]> wrote: 1. Now I am getting below exception. Saw in one of the threads that

Re: SLF4J AND LOG4J delegation exception with ignite dependency

1. Now I am getting below exception. Saw in one of the threads that removing ignite-rest-http will solve the issue which it does. But I need to include rest-api as I will be using ignite rest services. Please help me fix this. java.lang.NoSuchMethodError:

SLF4J AND LOG4J delegation exception with ignite dependency

Hi, Below exception is thrown when I include ignite dependency with my spring boot app. Even though reason seems obvious that 2 jars are in deadlock here, can you suggest me how can I fix this. I am not adding any of these jars directly and these are included automatically with other

Re: [EXTERNAL] Re: Failed to write class name to file: java.io.FileNotFoundException

Any workaround for this issue? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Failed-to-write-class-name-to-file-java-io-FileNotFoundException-tp7855p7906.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: [EXTERNAL] Re: Failed to write class name to file: java.io.FileNotFoundException

Yes, I did provide permissions using your solution but still running into same issue. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Failed-to-write-class-name-to-file-java-io-FileNotFoundException-tp7855p7863.html Sent from the Apache Ignite Users mailing list

Re: [EXTERNAL] Re: Failed to write class name to file: java.io.FileNotFoundException

0-bin/work/marshaller/)? On Wed, Sep 21, 2016 at 12:43 PM, chevy <[hidden email]> wrote: Hi, I am getting below error when I try to add data to cache. It used to work earlier with no issues. I am using Ignite version 1.6. [ERROR][main][MarshallerContextImpl] Failed to write class

Failed to write class name to file: java.io.FileNotFoundException

Hi, I am getting below error when I try to add data to cache. It used to work earlier with no issues. I am using Ignite version 1.6. [ERROR][main][MarshallerContextImpl] Failed to write class name to file [id=-1398818952, clsName=com.target.ignite.model.sales.SalesModel,

Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Thanks for the help Sergi. I ran jps and found a thread hanging which had skipped my exit criteria. Started working after I killed it. -- View this message in context:

Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

nabble.com>> Date: Tuesday, September 6, 2016 at 11:46 PM To: "Chetan.V.Yadav" <chetan.v.ya...@target.com<mailto:chetan.v.ya...@target.com>> Subject: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor Please sen

Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

` is problematic because there is a function with the same name. Sergi 2016-09-06 12:40 GMT+03:00 chevy <[hidden email]>: Hi, I am getting "Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE TABLE ""salesCache"".SALESMODEL (_KEY

class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor

Hi, I am getting "Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE TABLE ""salesCache"".SALESMODEL (_KEY INT NOT NULL,_VAL OTHER,ID VARCHAR,STOREID INT,DATE VARCHAR,GOAL DOUBLE,FORECAST DOUBLE,HOURLYSALES OTHER,SALESDATE VARCHAR,TODAY[*] OTHER,TYSALES DOUBLE,LYSALES

Not able to retrieve data from cache

Hi, I am adding data to cache in below format - "cache.putAll(finalMap)" and cache is of format "IgniteCache cache". "finalMap" looks like "finalMap.put(storeId, salesModel)". SalesModel structure is shown below. I am not able to get data using any of the "rest-api"

Re: Way to save Multiple queries results for further manipulation

Is it possible, that I add JSON data instead of Map and able to query it? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Way-to-save-Multiple-queries-results-for-further-manipulation-tp7189p7399.html Sent from the Apache Ignite Users mailing list archive at

Re: Way to save Multiple queries results for further manipulation

I am adding data into a map and loading it to cache. But when I do that using cache.put() method, all my column names gets added as metadata and values in items. How can I get my results as shown above i.e., key : value format. Also, I keep updating data every hour, should I destroy cache and

Way to save Multiple queries results for further manipulation

Hi, I am querying around 7 queries and need to pick data and save it in the cache. I need my response to look as shown below. I have following queries to help me achieve this efficiently - 1. How do I manipulate and store data intermediately before loading it to cache. Also, I need to cache few

Re: IgniteException on starting node from Jar

I am not using complete path to my config. The example you have provided is to start node externally. I am starting node by using -> Ignition.start("config/mpm-ignite.xml”); where config folder (which is also a source folder holds xml files) is directly under my project folder. So, when I run it

Re: IgniteException on starting node from Jar

I am using just the config and I think the details provided by ignite.sh are provided by ignite maven dependences. When I run through my ide it just refers to config and performs node startup. Can I replicate similar behavior through my jar itself? Otherwise it points to xml which is available

Re: IgniteException on starting node from Jar

Please find the attached config files. It is working when I run my code from eclipse and not through jar. -- Regards, Chetan. From: "vkulichenko [via Apache Ignite Users]" > Date: Wednesday, August 10, 2016 at

Re: IgniteException on starting node from Jar

I am not using spring framework for my code and it is in plain Java. So, I do not have any spring version to specify explicitly. Also, how can i make my code use config inside jar rather than pick it from $IGNITE_HOME? -- View this message in context:

IgniteException on starting node from Jar

Hi, When I start ignite node from my eclipse IDE it starts without any issues but when I export my code to jar and execute the code, I get below mentioned error. I am using same config even when I am running directly from IDE. Error: Exception in thread "main" class

Re: Start node in remote server which needs authentication

Hi Val, I was able to fix SSL issue by adding key and certs into Java security folder and using keystore file in config. But I am not able to get my remote node join the cluster as it throws below error - "[14:47:35,087][WARNING][main][TcpDiscoverySpi] Node has not been connected to topology

Re: Rest-api: Creating service to read data from cache

I have set up ignite-rest-http and able to access api but I do not want to send query in my api and instead prefer to send object or method to fetch data directly. Is there a way to do this? -- View this message in context:

Re: Start node in remote server which needs authentication

That is the issue I am facing. I am not able to load my key in pem file to jks as it expects certificate along with it. Anyway I can get this working? -- View this message in context:

Rest-api: Creating service to read data from cache

Hi, I have created bean which aligns to my table structure as shown below and add data to it. While pulling data from cache I need to do some aggregation on data and then create service using the data. Ignite provides rest-api but I did not see any variant where I just use that api by mentioning

Re: Not able to start ignite node in ubuntu server

It is working now. Thank you. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Not-able-to-start-ignite-node-in-ubuntu-server-tp6707p6786.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Start node in remote server which needs authentication

onfiguration file and logs from cluster nodes? On Thu, Aug 4, 2016 at 8:14 PM, chevy <[hidden email]> wrote: So, what do you think that is going wrong. Should I change from Ubuntu to something else or config? Also, can I use just .pem file and implement SSLContextFactory to connect to remo

Re: Not able to start ignite node in ubuntu server

art ignite node in ubuntu server On 2016-08-04 15:44, chevy wrote: > Below is the command I am using - > I do - cd $IGNITE_HOME and then, > sudo sh bin/ignite.sh -v config/my-ignite.xml > ^^ > ^^ That is the problem. You can do either: $ sudo $IGNITE_HOME/bin/igni

Re: Start node in remote server which needs authentication

So, what do you think that is going wrong. Should I change from Ubuntu to something else or config? Also, can I use just .pem file and implement SSLContextFactory to connect to remote server? -- View this message in context:

Re: Start node in remote server which needs authentication

1. I have done both of those steps. 2. Also, please look into below config. Is this the right way to add remote machines which forms cluster? 127.0.0.1:47500..47509 10.63.78.112:47500..47509

Re: Start node in remote server which needs authentication

What are the things I need to include that will make nodes in different remote machines join the same cluster. Also, I am getting below error when I try to start Ignite node in ubuntu server. I have set both JAVA_HOME and IGNITE_HOME in /etc/environment. I am able to start in my local MAC

Re: Not able to start ignite node in ubuntu server

Below is the command I am using - I do - cd $IGNITE_HOME and then, sudo sh bin/ignite.sh -v config/my-ignite.xml -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Not-able-to-start-ignite-node-in-ubuntu-server-tp6707p6751.html Sent from the Apache Ignite Users

Re: Not able to start ignite node in ubuntu server

ot found Note the similarity with the first error you have. I did see your message where you mention you are running under bash, but could you verify that once more? Please also add the exact command you are running. If you are running /bin/sh /path/to/ignite.sh, you might be getting dash. On

Re: Not able to start ignite node in ubuntu server

Yes, it points to "/opt/ignite/apache-ignite-fabric-1.6.0-bin" where where my ignite.sh is residing. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Not-able-to-start-ignite-node-in-ubuntu-server-tp6707p6740.html Sent from the Apache Ignite Users mailing list

Re: Not able to start ignite node in ubuntu server

I had already provided full permissions (777) and owner for these folders/files is root (also starting it as a root user). So I think permissions are right. I am using same permissions that I have used in my local setup. I am running it in bash. It would be great if you can provide insight on

Not able to start ignite node in ubuntu server

Hi, I am getting below error when I try to start Ignite node in ubuntu server. This is the node which I will be connecting from my code which resides in a different machine. I am able to start in my local MAC machine. bin/ignite.sh: 36: bin/ignite.sh: source: not found bin/ignite.sh: 41:

Re: Start node in remote server which needs authentication

One more point to add - Consider this scenario: my code is running in one machine with config file set with all remote addresses that has to start nodes. 1. Should I externally start ignite node in each of these remote machines? 2. If yes, will the data be replicated automatically in these

Re: Start node in remote server which needs authentication

I have set up rest jetty config and other settings in my local. When I deploy my code in a server I need to access that remote machine to start the node in that machine through my code. To achieve this, can you provide me config changes I need to make in my config files as well as my code that

Start node in remote server which needs authentication

Hi, We use openstack machines to deploy any app in remote. Generally I *ssh* to the machine using a .pem file and its ip address which is assigned during setting up that machine. My query is that I need to start my node in this remote machine (I have added its address into ipfinder list). Now

Re: Rest-api: Returning no reply from server

Thanks. It is working now. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Rest-api-Returning-no-reply-from-server-tp6561p6660.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Issue with querying from cache

Issue got fixed. I have set Index type in my code which was not matching my Class type. Thanks for the help. -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Issue-with-querying-from-cache-tp6588p6658.html Sent from the Apache Ignite Users mailing list archive at

Re: Issue with querying from cache

Regarding Payroll, I had changed Payroll to tableB but missed to change it there. That is not an issue. I tried querying using cache_name.table_name but still it is not working. Please let me know if you need more inputs on this so that I can get some resolution. -- View this message in