Harriet_Kim_1764

[JDBC] JWP for Oracle DB

Discussion created by Harriet_Kim_1764 on Oct 1, 2016
Scenario:

You are installing the JWP and come across these types of errors.

Error:

U00003590 UCUDB - DB error: '08006', 'IO Error: The Network Adapter could not establish the connection', '17002', 'java.sql.SQLRecoverableException' 

U00003590 UCUDB - DB error: '08006', 'IO Error: Unknown host specified ', '17002', 'java.sql.SQLRecoverableException'

Investigation:

These types of errors usually mean the values in your SQLDRIVERCONNECT= for the JDBC are configured incorrectly.

Solution:

Go to the tnsnames.ora file and verify the host and service_name. Next, implement that into the JDBC's SQLDRIVERCONNECT= in the ucsrv.ini file.

Example of a tnsnames.ora:

EXMPL1 =
  (DESCRIPTION = 
      (ADDRESS = (PROTOCOL = TCP)(HOST = vwa01.automic.com)(PORT = 1521))
      (CONNECT_DATE = 
         (SERVER = DEDICATED)
         (SERVICE_NAME = exmpl1.automic.com)
      )
  )

Syntax for the JWP's SQLDRIVERCONNECT:

[JDBC]
SQLDRIVERCONNECT=jdbc:oracle:thin:@dbserver:1521/service_name

Example:

[JDBC]
SQLDRIVERCONNECT=jdbc:oracle:thin:@vwa01.automic.com:1521/exmpl1.automic.com

Outcomes