Oracle DB connection

KNIME Analytics Platform
1

Folks-

I’m having difficulty using the Database Connector to hit an Oracle DB.

I’ve installed ojdbc6.jar and registered it.

For Database Connector I’ve selected oracle.jdbc.OracleDriver.

I’ve tried numerous combinations for Database URL.

jdbc:oracle:thin:@//MYORACLE-DB.xyz.com:PORT#/serviceName but all yield “failed to apply settings: Database connection could not be validated: Invalid argument: create.”

2

Hi @RCL1,

Have you tried using the ojdbc7.jar driver as well? That might solve your problem.

Cheers,
Roland