By Sylvain Duloutre on Sep 30, 2009
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 \*
(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=55625)) \* establish \* orcl
TNS-12505: TNS:listener does not currently know of SID given in connect