/Presto-Oracle

Plugin Connect Oracle to Prestodb.io

Primary LanguageJava

Presto OraclePlugin

This is a plugin for Presto that allow you to use Oracle Jdbc Connection

Connection Configuration

Create new properties file inside etc/catalog dir:

connector.name=oracle
connection-url=jdbc:oracle:thin://ip:port/database
connection-user=myuser
connection-password=

Create a dir inside plugin dir called oracle. To make it easier you could copy mysql dir to oracle and remove the mysql-connector and prestodb-mysql jars. Finally put the prestodb-oracle in plugin/oracle folder. Here is the sptes:

cd $PRESTODB_HOME
cp -r plugin/mysql plugin/oracle
rm plugin/oracle/mysql-connector*
rm plugin/oracle/presto-mysql*
mv /home/Downloads/presto-oracle*.jar plugin/oracle

Building Presto Oracle JDBC Plugin

mvn clean install

Building Oracle Driver

Oracle Driver is not available in common repositories, so you will need to download it from Oracle and install manually in your repository.