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 < [email protected]> 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 <[email protected]>: > >> 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<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. >> > >
