Oracle Developer: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Kia (talk | contribs)
No edit summary
Kia (talk | contribs)
Line 18: Line 18:
jdbc:oracle:thin:@(DESCRIPTION = (SOURCE_ROUTE = YES)
jdbc:oracle:thin:@(DESCRIPTION = (SOURCE_ROUTE = YES)


(ADDRESS = (PROTOCOL = TCP)(HOST = 193.162.253.211)(PORT = 1610))
(ADDRESS = (PROTOCOL = TCP)(HOST = 193.162.253.211)(PORT = 1645))


(ADDRESS = (PROTOCOL = TCP)(HOST = '''<Host>''')(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = '''<Host>''')(PORT = 1521))


(CONNECT_DATA = (SERVICE_NAME = '''<SID>''')))
(CONNECT_DATA = (SERVER=dedicated)(SERVICE_NAME = '''<SID>''')))

Revision as of 12:23, 21 March 2019

SIS

You need to fill out Username, Password and change the connection string information.

Connection string

jdbc:oracle:thin:@(DESCRIPTION = (SOURCE_ROUTE = YES)

(ADDRESS = (PROTOCOL = TCP)(HOST = 193.162.253.211)(PORT = 1610))

(ADDRESS = (PROTOCOL = TCP)(HOST = <Host>)(PORT = 1521))

(CONNECT_DATA = (SERVICE_NAME = <SID>)))

EASY

You just need to fill out Username and Password

Connection string

jdbc:oracle:thin:@(DESCRIPTION = (SOURCE_ROUTE = YES)

(ADDRESS = (PROTOCOL = TCP)(HOST = 193.162.253.211)(PORT = 1645))

(ADDRESS = (PROTOCOL = TCP)(HOST = <Host>)(PORT = 1521))

(CONNECT_DATA = (SERVER=dedicated)(SERVICE_NAME = <SID>)))