Re: Issue when executing sql query using REST API

2017-09-17 Thread Ray
This problem is resolved after I add proper getter/setter in the POJO class and deploy the jar file under the IgniteHome/lib folder. Also, I'd like to mention the POJO class written in scala case class is not working for the query exe api. Had to use a java POJO class if you want to get this API w

Re: Issue when executing sql query using REST API

2017-09-15 Thread Alexey Kukushkin
Hi Ray, The REST response is in plan text so you do not need those dependencies if you do nothing with the received plain text. But looking at your exception my guess was that your application deserialises received text into POJO, cannot find a deserialiser and displays that error. Can you please

Re: Issue when executing sql query using REST API

2017-09-15 Thread Ray
>From Ignite document https://apacheignite.readme.io/docs/rest-api#section-sql-query-execute. the response should be a plain text JSONObject, why do I have to have these dependencies on client side? Could you please advice how to get this API to working if I'm using Postman or curl as a client? T

Re: Issue when executing sql query using REST API

2017-09-15 Thread Ray
Yes, this exception is from client side. I'm using Postman as a REST client to retrieve the data from ignite. I don't think postman will be able to add these dependencies. >From my understanding, the results returned from Ignite sql query REST call is plain text, is it right? But from your explana

Re: Issue when executing sql query using REST API

2017-09-15 Thread Alexey Kukushkin
Hi Ray, The exception seems not related to Ignite to me. I believe you see it on the client side. Are you sure you have all Jackson runtime dependencies? For example, I have jackson-annotations, jackson-core and jackson-databind. Id you do not have it then you forgot to reference ignite-rest-http

Re: Issue when executing sql query using REST API

2017-09-15 Thread Ray Liu (rayliu)
discovered to create BeanSerializer Any ideas? From: Alexey Kukushkin Reply-To: "user@ignite.apache.org" Date: Wednesday, 13 September 2017 at 17:46 To: "user@ignite.apache.org" Subject: Re: Issue when executing sql query using REST API Hi Ray, You can avoid deploying classes

Re: Issue when executing sql query using REST API

2017-09-13 Thread Alexey Kukushkin
r@ignite.apache.org" > *Date: *Wednesday, 13 September 2017 at 17:20 > > *To: *"user@ignite.apache.org" > *Subject: *Re: Issue when executing sql query using REST API > > > > Ray, I am sorry - just read your second email and I realised I originally > mi

Re: Issue when executing sql query using REST API

2017-09-13 Thread Ray Liu (rayliu)
ot;user@ignite.apache.org<mailto:user@ignite.apache.org>" mailto:user@ignite.apache.org>> Date: Wednesday, 13 September 2017 at 17:12 To: "user@ignite.apache.org<mailto:user@ignite.apache.org>" mailto:user@ignite.apache.org>> Subject: Re: Issue when executing s

Re: Issue when executing sql query using REST API

2017-09-13 Thread Alexey Kukushkin
17:12 > *To: *"user@ignite.apache.org" > *Subject: *Re: Issue when executing sql query using REST API > > > > Hi Ray, > > > > Just copied your code into a simple single file sample project, ran it and > your query worked fine for me: > > > > *1.

Re: Issue when executing sql query using REST API

2017-09-13 Thread Ray Liu (rayliu)
Can you share your configuration xml? I think it’s a binary masharller configuration issue. From: Alexey Kukushkin Reply-To: "user@ignite.apache.org" Date: Wednesday, 13 September 2017 at 17:12 To: "user@ignite.apache.org" Subject: Re: Issue when executing sql query us

Re: Issue when executing sql query using REST API

2017-09-13 Thread Alexey Kukushkin
Hi Ray, Just copied your code into a simple single file sample project, ran it and your query worked fine for me: 1. Request URL: http://127.0.0.1:8080/ignite?cacheName=person&pageSize=1&qry=limit+2&cmd=qryexe&type=Person&; 2. Request Method: GET 3. Status Code: 200 OK 4.

Re: Issue when executing sql query using REST API

2017-09-13 Thread Ray Liu (rayliu)
ssing the Person class should be somehow uploaded to the lib folder under Ignitehome folder? From: "Ray Liu (rayliu)" Reply-To: "user@ignite.apache.org" Date: Wednesday, 13 September 2017 at 14:56 To: "user@ignite.apache.org" Subject: Issue when executing sql quer

Issue when executing sql query using REST API

2017-09-12 Thread Ray Liu (rayliu)
Hi all, I’m trying to execute a sql query using REST API with the following url. http://127.0.0.1:8080/ignite?cacheName=person&pageSize=1&qry=limit+2&cmd=qryexe&type=Person&; But I got the following error response { "successStatus": 1, "error": "IgniteTest$Person", "response": null,