Hi Ray, You can avoid deploying classes to the server nodes by using Ignite API that does not require building POJOs (IgniteTest$Person in your case).
- For SQL API use SqlFieldsQuery <https://apacheignite.readme.io/docs/sql-queries#section-sqlfieldsqueries> that, unlike SqlQuery, does not build a full object - For REST API use command "qryfldexe" <https://apacheignite.readme.io/docs/rest-api#sql-fields-query-execute>(that will result in SqlFieldsQuery) - For Java API use IgniteBinary API <https://apacheignite.readme.io/docs/binary-marshaller#binaryobject-cache-api> . Also, Ignite has Zero deployment feature <https://apacheignite.readme.io/docs/zero-deployment> applicable only to the computational code (compute closures and tasks) that enables automated deployment. But as I said it is not applicable to the metadata (cache) classes. On Wed, Sep 13, 2017 at 12:23 PM, Ray Liu (rayliu) <[email protected]> wrote: > Do I have to deploy my classes on all of the server nodes manually? > > Every time I added some new classes, I have to do this again? > > > > > > *From: *Alexey Kukushkin <[email protected]> > *Reply-To: *"[email protected]" <[email protected]> > *Date: *Wednesday, 13 September 2017 at 17:20 > > *To: *"[email protected]" <[email protected]> > *Subject: *Re: Issue when executing sql query using REST API > > > > Ray, I am sorry - just read your second email and I realised I originally > misunderstood your question. You guessed right, your classes need to be > deployed on the server nodes and on the server nodes you need to set the > USER_LIBS environment variable like: > > export USER_LIBS=<path to your IgniteTest JAR>/<your IgniteTest>.jar > > > > On Wed, Sep 13, 2017 at 12:15 PM, Ray Liu (rayliu) <[email protected]> > wrote: > > Can you share your configuration xml? > > I think it’s a binary masharller configuration issue. > > > > *From: *Alexey Kukushkin <[email protected]> > *Reply-To: *"[email protected]" <[email protected]> > *Date: *Wednesday, 13 September 2017 at 17:12 > *To: *"[email protected]" <[email protected]> > *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.* *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. --------------------- > > 5. {"successStatus":0,"error":null,"response":{"items":[{" > key":0,"value":{"id":0,"firstName":"John","lastName":" > Doe","salary":2000.0,"organizationId":1}}],"last": > false,"fieldsMetadata":[],"queryId":2},"sessionToken":null} > > > > > > -- > > Best regards, > > Alexey > -- Best regards, Alexey
