on 12-05-2007 5:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.