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
Can you do a similar posting for SQL Server 2005?
thanks,
Freeman
Posted by Freeman Fridie on October 16, 2009 at 04:20 PM CEST #
The JDBC URL structure for SQLServer 2005 can be found at http://msdn.microsoft.com/en-us/library/ms378428(SQL.90).aspx
Posted by Sylvain Duloutre on October 20, 2009 at 09:08 AM CEST #