thanks Christos, it works
On Fri, 12 Jul 2024 at 11:27, Christos Malliaridis <c.malliari...@gmail.com> wrote: > Hi Derrick, > > a ClassNotFoundException is usually thrown if you haven't enabled the SQL > module for your collection / Solr. You can enable it by starting Solr with > the -Dsolr.modules=sql property or the environment > variable SOLR_MODULES=sql. > > The documentation about Solr Modules > < > https://solr.apache.org/guide/solr/latest/configuration-guide/solr-modules.html > > > provides > a few more information. The documentation of SQL > < > https://solr.apache.org/guide/solr/latest/query-guide/sql-query.html#module > > > does point out what module (by name) you have to enable for the SQL to > work. > > I hope this solves your problem. > > Best, > Christos > > On Fri, Jul 12, 2024 at 5:42 AM Derrick Cui <derrick...@gmail.com> wrote: > > > Hi, > > > > I installed solr 9.6.1, I want to use the sql function, but the server > > throws a classNotFound error., anyone have an idea why this class is not > in > > solr 9.6.1? Do I need to install a special jar? > > > > { > > "error": { > > "metadata": [ > > "error-class", > > "org.apache.solr.common.SolrException", > > "root-error-class", > > "java.lang.ClassNotFoundException" > > ], > > "msg": " Error loading class 'solr.SQLHandler'", > > "trace": "org.apache.solr.common.SolrException: Error loading class > > 'solr.SQLHandler'\n\tat > > > > > org.apache.solr.core.SolrResourceLoader.findClass(SolrResourceLoader.java:551)\n\tat > > > > > org.apache.solr.core.SolrResourceLoader.findClass(SolrResourceLoader.java:472)\n\tat > > org.apache.solr.core.SolrCore.createInstance(SolrCore.java:939)\n\tat > > > > > org.apache.solr.core.PluginBag$LazyPluginHolder.createInst(PluginBag.java:520)\n\tat > > > > > org.apache.solr.core.PluginBag$LazyPluginHolder.get(PluginBag.java:502)\n\tat > > org.apache.solr.core.PluginBag.get(PluginBag.java:198)\n\tat > > > > > org.apache.solr.handler.RequestHandlerBase.getRequestHandler(RequestHandlerBase.java:311)\n\tat > > > > -- > > Regards, > > > > Derrick Cui > > Email: derrick...@gmail.com > > > -- Regards, Derrick Cui Email: derrick...@gmail.com
