File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Host String in jdbc url

 
jignesh soni
Ranch Hand
Posts: 150
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jignesh,
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic