Users also need to read the 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. > >
