Storage Plugin for Oracle DB in Apache Drill

1
votes

I am trying to configure for Oracle DB. But showing: Error

Error(Not able to create and update storage.)

{
    type: "jdbc",
    enabled: true,
    driver: "oracle.jdbc.OracleDriver",
    url:"jdbc:oracle:thin:system/pass@[email protected]:8047/nvn"
}

Please tell what i am doing wrong in this..?

1
apache-drill
Did you restart drill after adding ojdbc7.jar? – Dev
Ya.. i restart the drill – Naveen D
check logs in apache-drill-1.4.0/log/sqlline.log. Is anything mentioned there regarding this failure? – Dev
This Error Coming in log:------- 2016-01-28 17:04:11,980 [main] INFO o.a.drill.common.config.DrillConfig - Configuration and plugin file(s) identified in 166ms. Base Configuration: - jar:file:/F:/apache-drill-1.4.0/apache-drill-1.4.0/jars/drill-common-1.4.0.jar!/drill-default.conf Intermediate Configuration and Plugin files, in order of precedence: - jar:file:/F:/apache-drill-1.4.0/apache-drill-1.4.0/jars/drill-common-1.4.0.jar!/drill-module.conf – Naveen D
This error is showing in log file – Naveen D

1 Answers

1
votes

The problem is with url of storage plugin.

You need to mention Oracle machnie's hostname/IP & port not Drill Web UI's URL.

url:"jdbc:oracle:thin:<username>/<password>@<oracle-machine-hostname>:<port>/SID"

Eg: 

url:"jdbc:oracle:thin:user/[email protected]:1521/orcl"

NOTE:

  1. Make sure ojdbc7.jar is added in <drill-directory>/jars/3rdparty
  2. Double check your connection url, username, password via JDBC client or code using JDBC jar