Problems connecting a WLST script to an Oracle 18C Database
WLST code - error is "...Got minus one from a read call..."
Suspect error is with connection string?
from com.ziclix.python.sql import zxJDBC
from oracle.jdbc.driver import OracleDriver
d, u, p, v = "jdbc:oracle:thin:@scxdd-scan.cit.health.nsw.gov.au:1521:PESBPRD_EXT", "username", "password","oracle.jdbc.driver.OracleDriver"
db = zxJDBC.connect(d, u, p, v)
Connection string from SQL Developer
jdbc:oracle:thin:@(DESCRIPTION=(SOURCE_ROUTE=yes)(ADDRESS=(PROTOCOL=tcp)(HOST=spzcman.cit.health.nsw.gov.au)(PORT=1525))(ADDRESS=(PROTOCOL=tcp)(HOST=scxdd-scan.cit.health.nsw.gov.au)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PESBPRD_EXT)))