Search code examples
apache-drill

Storage Plugin for Oracle DB in Apache Drill

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@123@192.xxx.xxx.xxx:8047/nvn"
}

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

Solution

  • 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/pass@192.168.xx.xx: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