Oracle drivers are no more available for the Database Connector (deprecated) although installed
Dear KNIME-Enthusiasts,
We are facing a strange behavior for the Database Connector (deprecated) and the current DB Connector for KNIME version 4.7.4 and 5.1.2. . All over sudden the Oracle driver stopped working for one of my collegues in the old Database Connector (deprecated). Although there are two Oracle drivers installed (12.1 and 23.2) they simply don’t appear anymore in the Database Connector (deprecated) driver selection dropdown (for both KNIME versions) - the dialect selection does not contain any Oracle related selection. For the current Database Connector both drivers appear and work (dialect selection + driver available). Reinstalling one or both Oracle drivers via the KNIME preferences doesn’t help - the appear in the new Connector nodes but not in the old, deprecated ones. We tried to fix the issue by reinstalling an old version of KNIME (4.7.4) but the issue still persists: No more Oracle database and dialect selection although the driver(s) is installed (they appeared for the old KNIME version without reinstallation).
And even stranger is the fact that the Database Connector (deprecated) and the current Database Connector work with both drivers on other machines on KNIME Analytics Platform 5.1.2.
Unfortunately we have no clue how to fix the issue (that is only present for one of my collegues). Can anybody make sense of this behavior and is there a way to fix it?
Many thanks and best regards,
Andy