Please also need to read release notes :-). (this is not an obscure thing being discussed)
On Mon, Jul 15, 2024 at 6:25 AM Eric Pugh <ep...@opensourceconnections.com> wrote: > > 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. >
