Re: Package jar file path for sql Query Entity

[Vladislav Pyatkov]

Hi,

Ignite stores date as it specify in marshaller. Binary marshaller was
configured by default.
In case, if Binary marshaller was specified, all internal works will be
processed in binary view (hence do not need to store java classes on
server).
If you want to use binary view in own code, you should use "withKeepBinary"
cache method[1].
If your classes do not implement Binarylizable, the marshaller will get
values through reflection and builds binary view.
Is that clear explanation?

[1]:
https://apacheignite.readme.io/docs/binary-marshaller#binaryobject-cache-api

On Thu, Dec 1, 2016 at 5:02 PM, rishi007bansod 
wrote:

> Thanks. After importing same package on server and client side solved my
> problem(initially i wrote class in client node instead of importing it).
>
> But, I am still unclear about how ignite stores data
> case I  : In both Binary and serialized format, and de-serializes data when
> required
> case II : Only in binary format, and then there is no need of
> de-serialization
>
> Can you please explain what is default behavior of ignite for storing
> data(is it case I or case II). Also I have configured cache from xml file
> that I have attached and I have used binarylizable interface so does this
> mean my objects are stored in binary format only?
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Getting-null-query-output-after-using-
> QueryEntity-tp9217p9331.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Vladislav Pyatkov

Re: Package jar file path for sql Query Entity

[rishi007bansod]

Thanks. After importing same package on server and client side solved my
problem(initially i wrote class in client node instead of importing it). 

But, I am still unclear about how ignite stores data 
case I  : In both Binary and serialized format, and de-serializes data when
required
case II : Only in binary format, and then there is no need of
de-serialization

Can you please explain what is default behavior of ignite for storing
data(is it case I or case II). Also I have configured cache from xml file
that I have attached and I have used binarylizable interface so does this
mean my objects are stored in binary format only?



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Getting-null-query-output-after-using-QueryEntity-tp9217p9331.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Package jar file path for sql Query Entity

[Vladislav Pyatkov]

Hi,

I think in your case (when you configured "QueryEntity"), have not
necessary to copy classe (schema.jar) to a server. Ignite will by use
binary[1] format, and execute SQL (or other query) without deserialization.

But I definitly do not understand why it does not work...
You can to clarify are all data structures created as are you think or not.
Please, check it by using H2 debug console[2].

[1]: https://apacheignite.readme.io/docs/binary-marshaller
[2]:
https://apacheignite.readme.io/v1.7/docs/performance-and-debugging#using-h2-debug-console

On Tue, Nov 29, 2016 at 7:17 AM, rishi007bansod 
wrote:

> I have added warehouse.java containing class warehouse to package schema.
> Thats why I wrote schema.warehouse. Query I am executing is SELECT * from
> warehouse w WHERE w.w_id = 1 and entry corresponding to w_id = 1 is present
> in warehouse cache. schema.jar
> 
> this is my jar file.
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Getting-null-query-output-after-using-
> QueryEntity-tp9217p9252.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Vladislav Pyatkov

Re: Package jar file path for sql Query Entity

[rishi007bansod]

I have added warehouse.java containing class warehouse to package schema.
Thats why I wrote schema.warehouse. Query I am executing is SELECT * from
warehouse w WHERE w.w_id = 1 and entry corresponding to w_id = 1 is present
in warehouse cache. schema.jar
  
this is my jar file.



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Getting-null-query-output-after-using-QueryEntity-tp9217p9252.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Package jar file path for sql Query Entity

[Vladislav Pyatkov]

Hi,

Is it correct class name?



If you want to save several different classes to the cache, you must set
some matched "QueryEntry" 's.
Could you please provide the jar file?

On Mon, Nov 28, 2016 at 2:17 PM, rishi007bansod <rishi007ban...@gmail.com>
wrote:

> I have written following query entity for my database
>
> up1.xml <http://apache-ignite-users.70518.x6.nabble.com/file/n9217/up1.xml
> >
>
> For this query entity I have created jar file of package schema, which
> contains warehouse class. I kept this jar file in libs folder in apache
> ignite installation path. But when I run query on "warehouse cache" that I
> have created I am always getting null(blank) result. Even if I remove this
> jar file from libs folder(and keeping same xml file), still the query runs
> but gives null(blank) result. I think this packaged jar file is not getting
> included when ignite is running. So where should this jar file kept, so
> that
> i can be automatically loaded when ignite starts?
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Package-jar-file-path-for-sql-Query-Entity-tp9217.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Vladislav Pyatkov

Package jar file path for sql Query Entity

[rishi007bansod]

I have written following query entity for my database

up1.xml <http://apache-ignite-users.70518.x6.nabble.com/file/n9217/up1.xml>  

For this query entity I have created jar file of package schema, which
contains warehouse class. I kept this jar file in libs folder in apache
ignite installation path. But when I run query on "warehouse cache" that I
have created I am always getting null(blank) result. Even if I remove this
jar file from libs folder(and keeping same xml file), still the query runs
but gives null(blank) result. I think this packaged jar file is not getting
included when ignite is running. So where should this jar file kept, so that
i can be automatically loaded when ignite starts? 



--
View this message in context: 
http://apache-ignite-users.70518.x6.nabble.com/Package-jar-file-path-for-sql-Query-Entity-tp9217.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.