Re: [EXTERNAL] Re: Class objects are fetched as string when JDBC api is used

2016-11-08 Thread chevy
I am not printing it out directly but converting resultset to list and passing to my rest-api. Overriding toString() provides me data on first level variables say class A but I have other class objects (say B) list inside A which is returning empty list even if I override toString() inside class

Re: [EXTERNAL] Re: Query on using Ignite as persistence data and processing layer

2016-11-08 Thread chevy
One more query Val, Is Node.js support for Ignite (client and server) available? -- Regards, Chetan. From: "vkulichenko [via Apache Ignite Users]" Date: Wednesday, November 9, 2016 at 3:31 AM To: "Chetan.V.Yadav" Subject: [EXTERNAL] Re: Query on using Ignite as persistence data and processing

Query on using Ignite as persistence data and processing layer

2016-11-08 Thread chevy
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 avail

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

2016-11-08 Thread chevy
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 t

Re: Class objects are fetched as string when JDBC api is used

2016-11-08 Thread chevy
@Audrey, can you provide me a snippet how can I override ignite api's testing implementation? -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Class-objects-are-fetched-as-string-when-JDBC-api-is-used-tp8720p8772.html Sent from the Apache Ignite Users mailing list

Class objects are fetched as string when JDBC api is used

2016-11-06 Thread chevy
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

2016-11-03 Thread chevy
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

2016-11-03 Thread chevy
iver.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 deployed yet. I am still in dev phase so trying to start ignite locally

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

2016-11-02 Thread chevy
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. Please refer dependency chain below – \--- org.apache.ignite:ignite-indexing:1.7.0 +--- org

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

2016-11-02 Thread chevy
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:35 GMT+03:00 chevy <[hidden email]>: It works perfectly without spring-b

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

2016-11-02 Thread chevy
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]" Date: Wedn

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

2016-11-02 Thread chevy
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

2016-11-01 Thread chevy
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

2016-10-27 Thread chevy
ERNAL] 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 like below [1](I am getting error pop up in eclipse when I use name in exclude as

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

2016-10-24 Thread chevy
;org.apache.ignite:ignite-rest-http:1.6.0') { exclude group: "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

Re: SLF4J AND LOG4J delegation exception with ignite dependency

2016-10-22 Thread chevy
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: org.eclipse.jetty.util.log.StdErrLog.setPr

SLF4J AND LOG4J delegation exception with ignite dependency

2016-10-21 Thread chevy
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 dependencies.

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

2016-09-23 Thread chevy
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

2016-09-21 Thread chevy
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

2016-09-21 Thread chevy
Yadav" Subject: [EXTERNAL] Re: Failed to write class name to file: java.io.FileNotFoundException Hi, Are you sure, your application have enough permission on write to the directory (/opt/ignite/apache-ignite-fabric-1.6.0-bin/work/marshaller/)? On Wed, Sep 21, 2016 at 12:43 PM, chevy <[hidden

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

2016-09-21 Thread chevy
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, file=/opt/ignite/apache-i

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

2016-09-07 Thread chevy
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: http://apache-ignite-users.70518.x6.nabble.com/class-org-apache-ignite-IgniteCheckedException-Failed-to-register-query-type-Typ

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

2016-09-06 Thread chevy
6 at 11:46 PM To: "Chetan.V.Yadav" mailto:chetan.v.ya...@target.com>> Subject: Re: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor Please send the full stack trace of the error you are getting now, may be it is not really

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

2016-09-06 Thread chevy
September 6, 2016 at 5:18 PM To: "[hidden email]" <[hidden email]> Subject: [EXTERNAL] Re: class org.apache.ignite.IgniteCheckedException: Failed to register query type: TypeDescriptor Hi! The name `TODAY` is problematic because there is a function with the same name. Sergi

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

2016-09-06 Thread chevy
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

2016-09-05 Thread chevy
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" provided or JDBC api and I ha

Re: Way to save Multiple queries results for further manipulation

2016-08-30 Thread chevy
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 Nabb

Re: Way to save Multiple queries results for further manipulation

2016-08-21 Thread chevy
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 crea

Way to save Multiple queries results for further manipulation

2016-08-20 Thread chevy
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

2016-08-10 Thread chevy
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 f

Re: IgniteException on starting node from Jar

2016-08-10 Thread chevy
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 unde

Re: IgniteException on starting node from Jar

2016-08-09 Thread chevy
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]" mailto:ml-node+s70518n6887...@n6.nabble.com>> Date: Wednesday, August 10, 2016 at 4:53 AM To: "Chetan.V.Yadav" mailto:cheta

Re: IgniteException on starting node from Jar

2016-08-09 Thread chevy
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]" mailto:ml-node+s70518n6887...@n6.nabble.com>> Date: Wednesday, August 10, 2016 at 4:53 AM To: "Chetan.V.Yadav" mailto:cheta

Re: IgniteException on starting node from Jar

2016-08-09 Thread chevy
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: http://apache-ignite-users.70518.x6.nabble.

IgniteException on starting node from Jar

2016-08-09 Thread chevy
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 org.apache.ignite.IgniteExce

Re: Start node in remote server which needs authentication

2016-08-08 Thread chevy
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 an

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

2016-08-07 Thread chevy
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: http://apache-ignite-users.70518.x6.nabble.com/Rest-api-Creating-servic

Re: Start node in remote server which needs authentication

2016-08-05 Thread chevy
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: http://apache-ignite-users.70518.x6.nabble.com/Start-node-in-remote-server-which-needs-authentication-tp6668p67

Re: Start node in remote server which needs authentication

2016-08-05 Thread chevy
io/docs/network-config#tcpcommunicationspi<http://apacheignite.readme.io/docs/network-config#tcpcommunicationspi> [3] http://apacheignite.readme.io/docs/ssltls On Fri, Aug 5, 2016 at 9:30 AM, chevy <[hidden email]> wrote: I have started node in my remote machine using belo

Rest-api: Creating service to read data from cache

2016-08-05 Thread chevy
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 m

Re: Not able to start ignite node in ubuntu server

2016-08-05 Thread chevy
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

2016-08-04 Thread chevy
arget.com>> Subject: Re: Start node in remote server which needs authentication Hello, I don't think, which it is OS issue. Difficult understand to me where are you problem, without any demonstration. Can you please provide code example or full configuration file and logs from cluster nodes?

Re: Not able to start ignite node in ubuntu server

2016-08-04 Thread chevy
[via Apache Ignite Users]" mailto:ml-node+s70518n6773...@n6.nabble.com>> Date: Friday, August 5, 2016 at 10:54 AM To: "Chetan.V.Yadav" mailto:chetan.v.ya...@target.com>> Subject: Re: Not able to start ignite node in ubuntu server On 2016-08-04 15:44, chevy wrote: > Below

Re: Start node in remote server which needs authentication

2016-08-04 Thread chevy
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: http://apache-ignite-users.70518.x6.nabble.com/Start-node-in-remote-s

Re: Start node in remote server which needs authentication

2016-08-04 Thread chevy
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

2016-08-04 Thread chevy
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 machine

Re: Not able to start ignite node in ubuntu server

2016-08-04 Thread chevy
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 mail

Re: Not able to start ignite node in ubuntu server

2016-08-04 Thread chevy
ur 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 2016-08-03 18:02, chevy wrote: > Hi, > > I am getting below error

Re: Not able to start ignite node in ubuntu server

2016-08-04 Thread chevy
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 arc

Re: Not able to start ignite node in ubuntu server

2016-08-03 Thread chevy
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 what

Not able to start ignite node in ubuntu server

2016-08-03 Thread chevy
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: bin/ig

Re: Start node in remote server which needs authentication

2016-08-03 Thread chevy
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 nodes

Re: Start node in remote server which needs authentication

2016-08-02 Thread chevy
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 star

Start node in remote server which needs authentication

2016-08-02 Thread chevy
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 f

Re: Rest-api: Returning no reply from server

2016-08-01 Thread chevy
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

2016-08-01 Thread chevy
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

2016-08-01 Thread chevy
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 contex

Re: Rest-api: Returning no reply from server

2016-07-29 Thread chevy
I have already added connector config in my xml as shown below. But it is not working. This is similar to what you have mentioned as Java code if I am not wrong. . . . . . -- View this message i