Warning Oracle Connection : .DatabaseWrappedDriver return null

[mpm]

Hi,

I have this warning and I can’t select data:

Driver “org.knime.core.node.port.database.DatabaseWrappedDriver” return 'null’

When I select
WARN Database Reader 0:2 Drive org.knime.core.node.port.database.DatabaseWrappedDriver" return ‘null’ connection for DB URL
WARN Database Reader 0:2 Error during fetching metadata from database, reason: null

I use oracle and oracle driver : ojdbc14.jar.

Any idea?

[ipazin]

Hi there @mpm ,

Welcome to KNIME Community Forum!

Can you give a bit more info? What KNIME version are you using? What nodes are you using and how are they connected? What is the database URL? Do you get any error?

Additionally here is a link to new Database Guide which you might find useful.
https://docs.knime.com/2019-06/db_extension_guide/index.html

Br,
Ivan

[mpm]

KNIME 3.2.1

jdbc:oracle:thin:&USER@&PASSWORD(DESCRIPTION=(LOAD_BALANCE=on)(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=2)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=&NAME_HOST)(PORT=&PORT)))(CONNECT_DATA=(SERVICE_NAME=&SERVICE_NAME)))

[ipazin]

Hi there,

any specific reason why not upgrading to the newest version? Currently the newest one is 4.0.1. In it you can try new Database Integration nodes and dedicated connector for Oracle database.

Check this topic for more info: How to setup Oracle connector?

Br,
Ivan

[mpm]

About version, is the company-approved version. ;(

[tobias.koetter]

Hi,
can you please try to register the ojdbc8 driver which is compatible with Java 8 which KNIME runs on instead of the old ojdbc14 driver which was developed for Java 1.4.
Thanks
Tobias