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

database url explanation?

 
carl varola
Ranch Hand
Posts: 59
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Would any one explain to me in details the following please:
"jdbc racle:thin:@147.89.124.140:1527 MS", "scott", "tiger"
please show sample code(just the url) how to access local database and remote database.
Thanks
 
Mark Spritzler
ranger
Sheriff
Posts: 17276
6
IntelliJ IDE Mac Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
jdbc racle:thin is the driver type
@147.89.124.140 is the Oracle Server IP
:1527 is the port number
:MS is the Sid, you nead a : there not a space.
"scott" is the user
"tiger" is the password.
Hope that helps
jdbc racle:thin@ServerAddress ortNumber:SID,user,password
Mark
[ May 16, 2002: Message edited by: Mark Spritzler ]
 
carl varola
Ranch Hand
Posts: 59
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks alot for the reply.
would you please tell me how to get the oracle id address and the port number?
thanks
 
carl varola
Ranch Hand
Posts: 59
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sorry i meant the Oracle Server IP
and the port?how to get them?
thanks.
 
Mark Spritzler
ranger
Sheriff
Posts: 17276
6
IntelliJ IDE Mac Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You should be able to get them from your DBA. and if they already have a DNS name for the server you can use that instead of the IP address. Port 1521 is the default, so if they use that, that is what it is.
Mark
[ May 16, 2002: Message edited by: Mark Spritzler ]
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic