ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yakov Zhdanov <yzhda...@apache.org>
Subject Re: SQLCacheQuery Problem
Date Fri, 19 Jun 2015 09:48:10 GMT
I have added warning panel to the page. Please take a look.

--Yakov

2015-06-18 18:03 GMT+03:00 Isaeed Mohanna <isaeedm@gmail.com>:

> I did not see that coming.... Thank you very much....
> A note in Query section of the docmentation will help as well
> http://apacheignite.readme.io/v1.1/docs/cache-queries
>
>
> On Wed, Jun 17, 2015 at 8:52 PM, Alexey Goncharuk <
> alexey.goncharuk@gmail.com> wrote:
>
>> Add module ignite-indexing to the classpath of your project, it should
>> work fine after that. I will create a ticket to make sure Ignite throws a
>> proper error message when indexing is not in the classpath.
>>
>> 2015-06-17 7:22 GMT-07:00 Isaeed Mohanna <isaeedm@gmail.com>:
>>
>>> Hi
>>> *I am using Ignite 1.0.0, I have a cache defined with the following
>>> configuration (defined at startup):*
>>> CacheConfiguration<?, ?> CacheConfig = new CacheConfiguration<>();
>>> CacheConfig .setName("myCache");
>>> CacheConfig .setCacheMode(CacheMode.REPLICATED);
>>> CacheConfig .setAtomicityMode(CacheAtomicityMode.ATOMIC);
>>> CacheConfig .setIndexedTypes(UUID.class, MyClass.class);
>>> *The class MyClass looks as follows:*
>>> public class MyClass implements Externalizable {
>>>         @QuerySqlField(index = true)
>>>         private UUID id;
>>>         private UUID anotherId;
>>>         @QuerySqlField(index = true)
>>>         private Date time;
>>>   .. setters/ getters and some other fields
>>> }
>>> *I am trying to perform sql query on my cache using the following:*
>>> IgniteCache<UUID, MyClass> reportsSchedule = ignite.cache("myCache");
>>> SqlQuery<UUID, MyClass> sqlQuery = new SqlQuery<UUID,
>>> MyClass>(MyClass.class, "time <= ?");
>>> QueryCursor<Entry&lt;UUID, MyClass>> cursor =
>>> myCache.query(sqlQuery.setArgs(new Date()));
>>>
>>> *However I keep getting the following exception:*
>>> Caused by: class org.apache.ignite.IgniteException: Failed to find SQL
>>> table
>>> for type: MyClass
>>>         at
>>>
>>> org.apache.ignite.internal.processors.closure.GridClosureProcessor$C2.execute(GridClosureProcessor.java:1699)
>>>         at
>>>
>>> org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:478)
>>>         at
>>>
>>> org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6069)
>>>         at
>>>
>>> org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:472)
>>>
>>> *MyClass and UUID are defined in the configuration as an indexed type,
>>> also
>>> annotated as so in MyClass definition however i still receive this
>>> exception. Any idea what am i missing?*
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://apache-ignite-users.70518.x6.nabble.com/SQLCacheQuery-Problem-tp511.html
>>> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>>>
>>
>>
>

Mime
View raw message