t;
> > > >> > > >> http://localhost:8983/solr/col1/stream?action=PLUGINS
> > > >> > > >>
> > > >> > > >> When using the DIH I use the jdbc driver:
> > > >> > > >> org.mariadb.jdbc.Driver
>
gt; >>
> > >> > > >> With connection string:
> > >> > > >> jdbc:mysql://{{host}}:{{port}}/{{database}}
> > >> > > >>
> > >> > > >> I am able to get DIH pulling data from mariadb with that
> &g
n
> >> > > >> string.
> >> > > >>
> >> > > >> However using the same connection string in the streaming
> >> expression:
> >> > > >> jdbc(connection="jdbc:mysql://mariadb:3306/db",sql="select id
> >
>> from
>> > > tbl
>> > > >> order by id asc limit 1", sort="id asc",
>> > > driver="org.mariadb.jdbc.Driver")
>> > > >>
>> > > >> I get the error:
>> > > >> "EXCEPTION": "Fai
; > > >> I tried upgrading jdbc connector to 3x version and using the
> > connection
> > > >> string "jdbc:mariadb://:/" and get the same error
> > > message.
> > > >>
> > > >>
> > > >>
> >
Joel Bernstein
> > >> 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
>> > 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.clie
gin 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.blogspo
t; >
> >
> >
> > Joel Bernstein
> > http://joelsolr.blogspot.com/
> >
> >
> > On Thu, Sep 8, 2022 at 6:54 PM James Greene >
> > wrote:
> >
> > > I'm on solr 8.11.1 and trying to use the 'jdbc' streaming expression as
> > > document
n 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
elsolr.blogspot.com/
>
>
> On Thu, Sep 8, 2022 at 6:54 PM James Greene
> 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
>>
>&g
am-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&q
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
13 matches
Mail list logo