oracle connector via tnsname

[rufmau68]

hi,
im new with knime
i need to connect a lot of oracle server via tnsname or jdbc but dont work

can anyone help me ?
thanks
best regards
mauro

[ggruff]

Hello Mauro,

Have you installed the necessary JDBC drivers yet for this server type?

https://docs.knime.com/latest/database_extension_guide/index.html#register_jdbc

What specifically was not working for you?

Cheers,
Gamble

[rufmau68]

yes i download oracle jdbc, sets in knime preference and then used database connector

ERROR Database Connector 0:1 Execute failed: Could not create connection to database: Maximum number of retries to get a valid connection reached. JDBC URL: jdbc:oracle:thin:@DWHP.RETEUNITARIA.PIEMONTE.IT:1589:DWHPDC

[arofab]

Hi,
from https://docs.oracle.com/cd/B28359_01/java.111/b31224/urls.htm#BEIDHCBA, you can try the following connection string:

jdbc:oracle:thin:@//DWHP.RETEUNITARIA.PIEMONTE.IT:1589/DWHPDC

Regards,
Fabrizio

[rufmau68]

Grazie fabrizio, ho provato come hai detto tu, ho provato anche in altre forme tipo jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = CSI_PIEMONTE) (PROTOCOL = TCP) (HOST = DWHP.RETEUNITARIA.PIEMONTE.IT) (PORT = 1589))) (CONNECT_DATA = (SID = DWHPDC) ))
come da un esempio trovato all’ url oracle che mi hai indicato
ma sempre con gli stessi errori:

ho provato a togliere le jdbc dalle preference ma niente, usando 2 database driver diversi che vedo nella tendina del connettore (oracle,jdbc.OracleDriver o oracle,jdbc.driver.OracleDriver) ma sempre con vari errori

---

*** Welcome to KNIME Analytics Platform v3.7.1.v201901281154 ***
*** Copyright by KNIME AG, Zurich, Switzerland ***

---

Log file is located at: C:\Users\2083\knime-workspace.metadata\knime\knime.log
ERROR KNIMECorePlugin Error while starting workbench, some setting may not have been applied properly: Duplicate driver found for name:oracle.jdbc.OracleDriver
ERROR Database Table Connector 0:3 Execute failed: Errore di I/O: The Network Adapter could not establish the connection
ERROR Database Table Connector 0:3 Execute failed: Errore di I/O: Invalid connection string format, a valid format is: “host:port:sid”
ERROR Database Table Connector 0:3 Execute failed: Errore di I/O: Invalid connection string format, a valid format is: “host:port:sid”
ERROR Database Table Connector 0:3 Execute failed: Maximum number of retries to get a valid connection reached. JDBC URL: jdbc:oracle:thin:@//DWHP.RETEUNITARIA.PIEMONTE.IT:1589/DWHPDC
ERROR Database Table Connector 0:3 Execute failed: java.lang.UnsatisfiedLinkError: oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber()I
ERROR Database Table Connector 0:3 Execute failed: Errore di I/O: Invalid connection string format, a valid format is: “host:port:sid”
ERROR Database Table Connector 0:3 Execute failed: Maximum number of retries to get a valid connection reached. JDBC URL: jdbc:oracle:thin:@//DWHP.RETEUNITARIA.PIEMONTE.IT:1589/DWHPDC
WARN Database Table Connector 0:3 java.lang.IllegalArgumentException: Invalid JDBC URL in settings: url=“jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = CSI_PIEMONTE) (PROTOCOL = TCP) (HOST = DWHP.RETEUNITARIA.PIEMONTE.IT) (PORT = 1589))) (CONNECT_DATA = (SID = DWHPDC) ))”
WARN Database Table Connector 0:3 java.lang.IllegalArgumentException: Invalid JDBC URL in settings: url=“jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = CSI_PIEMONTE) (PROTOCOL = TCP) (HOST = DWHP.RETEUNITARIA.PIEMONTE.IT) (PORT = 1589))) (CONNECT_DATA = (SID = DWHPDC) ))”
ERROR Database Table Connector 0:3 Execute failed: Maximum number of retries to get a valid connection reached. JDBC URL: jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = CSI_PIEMONTE) (PROTOCOL = TCP) (HOST = DWHP.RETEUNITARIA.PIEMONTE.IT) (PORT = 1589))) (CONNECT_DATA = (SID = DWHPDC) ))

[ipazin]

Hi there!

What driver version do you have?
Check here for more info: Oracle connection error

Br,
Ivan

[rufmau68]

yes, using ojdbc6.jar all seems to work,
i hav a java8 on my machine , can i try later …ojdbc8n.jar but by now im just sutisfied
thanks
bye
mauro