cancel
Showing results for 
Search instead for 
Did you mean: 

Connector String for the data base for an Oracle System

Former Member
0 Kudos

Hi ,

I have all the drivers set for the oracle system in the database.

I need to know what can be the connection URL for the Oracle DB with the following details:

      (ADDRESS = (PROTOCOL = TCP)(HOST = 128.1.2.90)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = ODEV.world)

Best Regards

Sid

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sid,

The general form of the Oracle JDBC connection string is:

jdbc:oracle:<drivertype>:<username/password>@<database>

The <drivertype> is one of:

- thin

- oci

- kprb

The <username/password> is either empty or of the form: <username>/<password>

Based on your Oracle information and if you are using the 'thin' driver type, your connection string should look like:

<i>jdbc:oracle:thin:<username/password>@//128.1.2.90:1521/ODEV.world</i>

Hope this helps.

Regards,

Joseph

Answers (0)