Visit the official Paxata Documentation portal for all of your doc needs.

Paxata Admin: how to enable Oracle JDBC Connector

Oracle 12c JDBC driver (http://download.oracle.com/otn/utilities_drivers/jdbc/121010/ojdbc7.jar)

1.Add the ojdbc7.jar to /usr/local/paxata/server/drivers/

2. User ran recursive chown on drivers to make paxata user the owner (chown paxata:paxata -R /usr/local/paxata/server/drivers)

3. User set permissions as 755 on all drivers (chmod 755 -R /usr/local/paxata/server/drivers)

4. Edit /usr/local/paxata/server/drivers/jdbc-driver.properties:

    oracle=oracle.jdbc.driver.OracleDriver

5. Restart Paxata Server to register the new driver (service paxata-server restart)

6. Create Oracle datasource in Library Page.

     jdbc:oracle:thin:@//prod.company.com:1521/XE

Sign In or Register to comment.