Problem with the river-jdbc sqlite

Elastic Stack Elasticsearch
3

Hello Jörg,

Thans for your help !! It's working !

Franck

Le jeudi 24 avril 2014 01:25:28 UTC+2, Franck B a écrit :

Hello,

I use jdbc-river to feed my ES 0.92 with sqlite datasource . Everything
is OK.

I wanted to upgrade ES 1.1.1 and there is drama , I have this error:

[ERROR][org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverSource] while opening read connection: jdbc:sqlite:/data/db/
maDb.db No suitable driver found for jdbc:sqlite:/data/db/maDb.db
java.sql.SQLException: No suitable driver found for jdbc:sqlite:/data/db/
maDb.db
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.
connectionForReading(SimpleRiverSource.java:133)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.
execute(SimpleRiverSource.java:252)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.
fetch(SimpleRiverSource.java:227)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.move(
SimpleRiverFlow.java:129)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.run(
SimpleRiverFlow.java:88)
at java.lang.Thread.run(Unknown Source)

The driver sqlite-jdbc-3.7.2.jar is installed in the plugin directory . The
river- jdbc plugin has been updated and has
Elasticsearch-river-jdbc-1.1.0.0.jar
ES is deployed on a CentOS 6 64bit .

The river:

PUT /_river/monIndex/_meta
{
"type" : "jdbc",
"jdbc" : {
"driver" : "org.sqlite.JDBC",
"url" : "jdbc:sqlite:/data/db/maDb.db",
"user" : "",
"password" : "",
"sql" : "SELECT * FROM toto "
},
"index" : {
"index" : "monIndex",
"type" : "monType",
"bulk_size" : 50000,
"max_bulk_requests" : 5
}
}

I thought that the ES release was too recent for the plugin so I went on
version 1.1.0 putting the plugin version 1.1.0.0 . Still the same
problem ...

The sqlite driver is not the problem because I did the test with a mysql
driver , I have the same problem.

In addition, I find the driver in the classpath ES . ( by ps aux | grep
elast )

I'm lost, I do not really see where the problem lies . I followed the
procedures .

It's a shame to downgrade ES and lose the benefits of Marvel .

Someone has encountered the same problem ? How has it been resolved?

Thank you for your help!

Franck

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/50589b9a-4293-4da1-8ed0-4a72833ac6a5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.