JDBC URLs with Oracle database

The JDBC URL structure indicated in the DPS doc set to access ORACLE databases is wrong somehow: Referring to the DPS admin guide, the db-url is in the form jdbc:vendor:driver://dbhost:dbport.

A correct db-url for Oracle is jdbc:oracle:thin:@localhost:1521:

Using "//" instead of "@" may lead to errors similar to the one below:


Snipplet from the Oracle EX logs:
28-SEP-2009 12:12:52 \*
(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) \*
(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=55625)) \* establish \* orcl
\* 12505
TNS-12505: TNS:listener does not currently know of SID given in connect
descriptor

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About


I am Sylvain Duloutre, I work as a Software Architect in the Oracle Directory Integration Team, the customer-facing part of Directory Services & Identity Management Product Development, working on Technical Field Enablement.

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
9
10
11
12
13
14
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today