Oracle Weblogic Server (MOSC)

MOSC Banner

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)))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center