permaculture playing cards
The moose likes JDBC and Relational Databases and the fly likes Host String in jdbc url Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Host String in jdbc url" Watch "Host String in jdbc url" New topic

Host String in jdbc url

jignesh soni
Ranch Hand

Joined: Dec 10, 2007
Posts: 150
I am trying to connect to oracle database. Unfortunately, I dont remember what is my SID. So how can I retrieve that ? Secondly, what version of oracle shall I download for practice coding (Enterprise, Lite or which one) ?

Thanks in advance
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33113

Welcome to JavaRanch!

If you look at your tnsnames.ora file, it will contain the SID in use on your machine.

As for edition of Oracle, I recall Oracle Express Edition being free. Best bet is to check on the Oracle site.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Host String in jdbc url
It's not a secret anymore!