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 >
