Oracle Database Connection Failed

pgrachellod · September 27, 2018, 4:38pm

Hi all,

I was using Knime 3.5 version and today I updated to version 3.6. With Knime 3.5 I was able to connect to an Oracle database with a database connector node. However, now with version 3.6 I am getting this error:

ERROR Database Connector 0:49 Execute failed: Could not create a connection to the database: Maximum number of retries to get a valid connection reached. JDBC URL: jdbc:oracle:thin:@jrorap001.journalrep.tio.systems:1521:jrprd

I am using class12.jar

Any suggestion on why I can’t connect to the database?

Thank you.
Paola

thor · September 28, 2018, 6:49am

Sounds like a similar problem mentioned here.

pgrachellod · September 28, 2018, 10:35am

Hi Thor,

Thank you so much! Solved I replace the database drive to ojdbc8.jar and now works!

Cheers,
Paola

system · October 5, 2018, 10:35am

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.