JDBC URL with Oracle SID or ServiceName

Today I face a small problem with a definition of a JDBC URL which is referencing an Oracle Database.
I just define:
jdbc:oracle:thin:scott/tiger@localhost:1521/PROD.OCZH.CH
where PROD.OCZH.CH is the ServiceName of my Database, but it fails :-(

After a some investigations, the solution is simple, if you want to use the ServiceName of your Database in the JDBC URL you have to place // in front of the servername:
jdbc:oracle:thin:scott/tiger@//localhost:1521/PROD.OCZH.CH
Created by Dirk Nachbar
Monday, June 8, 2009 3:23 PM
Labels:

2 Comments :: JDBC URL with Oracle SID or ServiceName

  1. You saved my day

    Anonymous

    October 4, 2010 12:50 PM

  2. You are welcome Anonymous :-)
    Hope you'll find more usefull stuff on my blog.

    Cheers

    Dirk

    Dirk Nachbar

    October 4, 2010 2:44 PM

Post a Comment

Subscribe to: Post Comments (Atom)