Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SID or Service Name for JDBC connection ?

452507Sep 26 2006 — edited Sep 26 2006
When establising a JDBC connection using the thin driver, is it common practice to use SID's or Service Names ?

Most JDBC examples I've found use SIDs, but Oracle say use Service Names because "SIDs will be cease to be supported in one of the next few releases of the database". Is there any real prospect of SIDs being dropped ?
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#05_04

I'd rather not have to write code that needs to cater for both SIDs and Service Names.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2006
Added on Sep 26 2006
#java-database-connectivity-jdbc
1 comment
6,668 views