Anchormen / sql4es

sql4es: JDBC driver for Elasticsearch
https://www.anchormen.nl
Apache License 2.0
278 stars 114 forks source link

Unable to Connect to Elasticsearch 5.5.3 using JDBC Driver sql4es-0.8.2.4.jar. #47

Open JHGithubRep opened 6 years ago

JHGithubRep commented 6 years ago

Below is the error message, however this driver supports elasticsearch 2.2.0 but not 5.5.3.

We are in urgent need of help to connect to elasticsearch using Oracle DVD 4. Please suggest/advise.

Also I have tried latest driver "sql4es-0.9.2.4.jar", but no luck.

Apr 13, 2018 5:18:08 PM oracle.bi.datasource.logging.ODLLoggerWrapper error SEVERE: java.util.concurrent.ExecutionException oracle.bi.datasource.exceptions.DatasourceException: [JDSError : 102] Cannot create a connection since there are some errors. Please fix them and try again. Failed creating a data source connection for jdbc:sql4es://localhost:9300/twitter_local?cluster.name=elasticsearch Cause - [JDSError : 102] Cannot create a connection since there are some errors. Please fix them and try again. Failed creating a data source connection for jdbc:sql4es://localhost:9300/twitter_local?cluster.name=elasticsearch java.util.concurrent.FutureTask.report(FutureTask.java:122) java.util.concurrent.FutureTask.get(FutureTask.java:206) oracle.bi.datasource.service.adf.server.DatasourceServlet.doGet(DatasourceServlet.java:450) oracle.bi.datasource.service.adf.server.DatasourceServlet.doPost(DatasourceServlet.java:597) javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

mallim commented 6 years ago

The release jar is strictly speaking sql4es-with-dependencies.jar, you have to check out the code and recompile with your desired Elasticsearch version