search

jprante / elasticsearch-jdbc

JDBC importer for Elasticsearch
Apache License 2.0
2.84k stars 710 forks source link

Oracle jdbc connection issue #764

Open srijeyanthan opened 8 years ago

srijeyanthan commented 8 years ago

Hi I downloaded the zip file and then set the connection properties oracle-connection-properties.sh . My ojdbc14.jar is in elasticsearch-jdbc-2.1.1.2/lib folder. I am getting following error .

[17:43:45,542][ERROR][importer.jdbc.source.standard][pool-3-thread-1] while opening read connection: jdbc:oracle:thin:@//127.0.0.1/sd1 No suitable driver found for jdbc:oracle:thin:@//127.0.0.1/sd1 java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@//127.0.0.1/sd1 at java.sql.DriverManager.getConnection(DriverManager.java:596) ~[?:1.7.0_80] at java.sql.DriverManager.getConnection(DriverManager.java:187) ~[?:1.7.0_80] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.getConnectionForReading(StandardSource.java:485) [elasticsearch-jdbc-2.1.1.2-uberjar.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.execute(StandardSource.java:670) [elasticsearch-jdbc-2.1.1.2-uberjar.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardSource.fetch(StandardSource.java:597) [elasticsearch-jdbc-2.1.1.2-uberjar.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.fetch(StandardContext.java:188) [elasticsearch-jdbc-2.1.1.2-uberjar.jar:?] at org.xbib.elasticsearch.jdbc.strategy.standard.StandardContext.execute(StandardContext.java:163) [elasticsearch-jdbc-2.1.1.2-uberjar.jar:?] at org.xbib.tools.JDBCImporter.process(JDBCImporter.java:179) [elasticsearch-jdbc-2.1.1.2-uberjar.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:165) [elasticsearch-jdbc-2.1.1.2-uberjar.jar:?] at org.xbib.tools.JDBCImporter.newRequest(JDBCImporter.java:51) [elasticsearch-jdbc-2.1.1.2-uberjar.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:50) [elasticsearch-jdbc-2.1.1.2-uberjar.jar:?] at org.xbib.pipeline.AbstractPipeline.call(AbstractPipeline.java:16) [elasticsearch-jdbc-2.1.1.2-uberjar.jar:?] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [?:1.7.0_80] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_80] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_80] at java.lang.Thread.run(Thread.java:745) [?:1.7.0_80] ^C

feixy commented 8 years ago

I occure the same problem now ,Do you get the answer of this issue?

jprante commented 8 years ago

You need to add the Oracle driver jar to the "lib" directory.