This isn’t documented in the Ref Guide right?   @Joel, throw me a JIRA and I’ll 
add it ;-)

> On Sep 8, 2022, at 10:15 PM, Joel Bernstein <joels...@gmail.com> wrote:
> 
> The jdbc stream was removed from the standard expression library for
> security reasons. It is still in the jars though and can be included
> through a change in the solrconfig.xml.
> 
> This jira describes how to plugin an expression:
> 
> https://issues.apache.org/jira/browse/SOLR-9103
> 
> The class is: org.apache.solr.client.solrj.io.stream.JDBCStream
> 
> 
> 
> Joel Bernstein
> http://joelsolr.blogspot.com/
> 
> 
> On Thu, Sep 8, 2022 at 6:54 PM James Greene <ja...@jamesaustingreene.com>
> wrote:
> 
>> I'm on solr 8.11.1 and trying to use the 'jdbc' streaming expression as
>> documented here:
>> https://solr.apache.org/guide/8_11/stream-source-reference.html#jdbc
>> 
>> When I try to run a jdbc stream expression I get the error:
>> 'function 'jdbc' is unknown (not mapped to a valid TupleStream'
>> 
>> Here is an example of the expression i'm trying to run:
>> jdbc(connection="jdbc:mysql://mariadb:3306/threatquotient2",sql="select id
>> from data order by id asc limit 1", sort="id asc"
>> driver="org.mariadb.jdbc.Driver")
>> 
>> I use the mariadb jdbc driver to get data from our mariadb instance using
>> the data import handler so the jdbc driver should be property loaded.
>> 

_______________________
Eric Pugh | Founder & CEO | 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.

Reply via email to