It would be nice if the exception that was raised had some sort of hint to what you need to do to fix it! I suspect we see this question more and more as folks adopt the new modularized Solr!
> On Jul 13, 2024, at 2:34 AM, Derrick Cui <derrick...@gmail.com> wrote: > > 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 _______________________ Eric Pugh | Founder | OpenSource Connections, LLC | 434.466.1467 | http://www.opensourceconnections.com <http://www.opensourceconnections.com/> | My Free/Busy <http://tinyurl.com/eric-cal> Co-Author: Apache Solr Enterprise Search Server, 3rd Ed <https://www.packtpub.com/big-data-and-business-intelligence/apache-solr-enterprise-search-server-third-edition-raw> This e-mail and all contents, including attachments, is considered to be Company Confidential unless explicitly stated otherwise, regardless of whether attachments are marked as such.
