Is the sql query must use the ignite-indexing jar?

classic Classic list List threaded Threaded
3 messages Options
anyway anyway
Reply | Threaded
Open this post in threaded view
|

Is the sql query must use the ignite-indexing jar?

This post has NOT been accepted by the mailing list yet.
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
vkulichenko vkulichenko
Reply | Threaded
Open this post in threaded view
|

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
anyway anyway
Reply | Threaded
Open this post in threaded view
|

Re: Is the sql query must use the ignite-indexing jar?

thank you . now, it's running successful!