You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by vkulichenko <va...@gmail.com> on 2016/03/31 23:46:00 UTC
Re: Is the sql query must use the ignite-indexing jar?
Hi,
Can you please properly subscribe to the mailing list so that the community
can receive email notifications? Here is the instruction:
http://apache-ignite-users.70518.x6.nabble.com/mailing_list/MailingListOptions.jtp?forum=1
anyway wrote
> Exception in thread "main" javax.cache.CacheException: Failed to execute
> query. Add module 'ignite-indexing' to the classpath of all Ignite nodes.
> at
> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.validate(IgniteCacheProxy.java:684)
> at
> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:619)
> at com.query.util.CacheQueryExample.sqlQuery(CacheQueryExample.java:156)
> at com.query.util.CacheQueryExample.main(CacheQueryExample.java:104)
>
> And when i add the ignite-indexing jar ,the error as follows:
>
> java.lang.NoClassDefFoundError: org/h2/server/Service
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Unknown Source)
> at
> org.apache.ignite.internal.IgniteComponentType.inClassPath(IgniteComponentType.java:146)
> at org.apache.ignite.internal.processors.query.GridQueryProcessor.
> <init>
> (GridQueryProcessor.java:159)
> at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:888)
> at
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1688)
> at
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1547)
> at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1003)
> at
> org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:929)
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:815)
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:714)
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:584)
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:554)
> at org.apache.ignite.Ignition.start(Ignition.java:347)
> at com.query.util.CacheQueryExample.main(CacheQueryExample.java:79)
> Caused by: java.lang.ClassNotFoundException: org.h2.server.Service
> at java.net.URLClassLoader.findClass(Unknown Source)
> at java.lang.ClassLoader.loadClass(Unknown Source)
> at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
> at java.lang.ClassLoader.loadClass(Unknown Source)
> ... 15 more
> [14:24:31] Ignite node stopped OK [uptime=00:00:11:755]
> Exception in thread "main" java.lang.NoClassDefFoundError:
> org/h2/server/Service
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Unknown Source)
> at
> org.apache.ignite.internal.IgniteComponentType.inClassPath(IgniteComponentType.java:146)
> at org.apache.ignite.internal.processors.query.GridQueryProcessor.
> <init>
> (GridQueryProcessor.java:159)
> at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:888)
> at
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1688)
> at
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1547)
> at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1003)
> at
> org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:929)
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:815)
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:714)
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:584)
> at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:554)
> at org.apache.ignite.Ignition.start(Ignition.java:347)
> at com.query.util.CacheQueryExample.main(CacheQueryExample.java:79)
> Caused by: java.lang.ClassNotFoundException: org.h2.server.Service
> at java.net.URLClassLoader.findClass(Unknown Source)
> at java.lang.ClassLoader.loadClass(Unknown Source)
> at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
> at java.lang.ClassLoader.loadClass(Unknown Source)
> ... 15 more
ignite-indexing module is required for SQL queries. The last error can
happen if you add only ignite-indexing.jar, but do not add JARs it depends
on (mainly H2 database). Can this be the case?
-Val
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Is-the-sql-query-must-use-the-ignite-indexing-jar-tp3808p3824.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
Re: Is the sql query must use the ignite-indexing jar?
Posted by anyway <11...@qq.com>.
thank you . now, it's running successful!
--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Is-the-sql-query-must-use-the-ignite-indexing-jar-tp3808p3834.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.