Sql developer custom connection string

Question

How to use custom connection string in Oracle sql developer to connect?

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=147.22.109.218)(port=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=147.22.109.219)(port=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=147.22.109.220)(port=1521)))
(FAILOVER=on)(LOAD_BALANCE=on)
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=cmphpd)))

Please help. Thanks

@Exhausted- My application has more than one database in our regression environment. For load balancing between databases, I chose to use advanced 'custom JDBC URL' to connect database. E.g. custom JDBC URL jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=147.22.109.218)(port=1521))(ADDRESS=(PROTOCOL=TCP) (HOST=147.22.109.219)(port=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=147.22.109.220)(port=1521))) (FAILOVER=on)(LOAD_BALANCE=on) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=cmphpd))). If you see it has more than one database address in the URL. — user1570345
– user1570345, Commented Dec 26, 2014 at 9:52
use the dropdown Connection Type to find jdbc URL. select that and then enter your URL into the textbox below. — xpioneer
– xpioneer, Commented Apr 18, 2021 at 3:48

bmaupin · Accepted Answer · 2020-05-14 19:17:52Z

5

To us a TNS connection string, in the New / Select Database Connection window where you configure the connection:

Set Connection Type to TNS
Under the Details tab select Connect Identifier
Put the connection string into the text box next to Connect Identifier
Click Test if you'd like, to make sure it works
Click Save

Similarly, under Connection Type there also seems to be an option for a custom JDBC URL if that's what you prefer.

(Instructions and screenshot from version 19.4, in case it makes a difference)

edited May 14, 2020 at 19:17

answered May 14, 2020 at 19:11

bmaupin

16.3k6 gold badges100 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mihai Ungureanu Over a year ago

Had the same problem, connection type "TNS" did not work for me as sql developer wanted the OCI libraries and I didn't have them. However, setting the connection type to "custom JDBC", having a connection string like jdbc:oracle:thin:@(...) worked for me.

Pang · Accepted Answer · 2017-02-07 07:35:23Z

0

Try this:

jdbc:oracle:thin:@147.22.109.220:1521/cmphpd

edited Feb 7, 2017 at 7:35

Pang

10.2k146 gold badges87 silver badges126 bronze badges

answered Feb 7, 2017 at 7:07

raz

11

Comments

Gagandeep Sharma · Accepted Answer · 2019-09-24 03:18:14Z

These are the best and complete instructions I've found. https://blogs.oracle.com/dev2dev/ssl-connection-to-oracle-db-using-jdbc,-tlsv12,-jks-or-oracle-wallets

Below are the steps which I took to fix this issue:

Install JCE (following the instructions in Readme) - JCE
Add below lines in build.gradle

System.setProperty('oracle.net.ssl_version', '1.2') System.setProperty('oracle.net.ssl_cipher_suites', '(TLS_RSA_WITH_AES_256_CBC_SHA256)') System.setProperty('oracle.net.tns_admin', './lib') System.setProperty('oracle.net.ssl_server_dn_match', 'true')
Setup db connection like

String connString = "jdbc:oracle:thin:@(description=(address_list= (address=(protocol=tcp)(port=1521)(host=prodHost))) (connect_data=(INSTANCE_NAME=ORCL)))"; OracleDataSource ods = new OracleDataSource(); ods.setURL(connString); ods.setUser("scott"); ods.setPassword("tiger"); Connection conn = ods.getConnection();

It would be better to brief the content since one day the link can be outdated

Collectives™ on Stack Overflow

Sql developer custom connection string

3 Answers 3

1 Comment

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Related