File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes ip addresses 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 "ip addresses" Watch "ip addresses" New topic

ip addresses

shilpa reddy

Joined: Dec 12, 2000
Posts: 29
I would appreciate some advice on a problem I am working on.
The requirement is to transfer data from a remote oracle database to a local database.I am not clear how to specify the data base url for the two dbs.
Assuming -
DBremote- ip address =, sid = remote
DBlocal - ip address = can keep changing depending upon the machine upon which the app is run, sid = local.
Do I specify the local address as being host) or does the static ip address of the local machine need to be specified ?
How do I set up the database url for the two databases in the properties file given the ip addresses and the sid?
Apologies if the questions sound trivial, and thanks in advance if for any help on the issue.
wayne hua

Joined: Jan 14, 2001
Posts: 5
For the local machine, you can use (or localhost). In this way, you don't have to change the ip address for different machines.
shilpa reddy

Joined: Dec 12, 2000
Posts: 29
Thanks for the answer Wayne!
Does anyone have any advice for the second part of the question ?
How do you set up the database URL in the properties file given the ip address and the sid of the db ?
Thanks in advance,
I agree. Here's the link:
subject: ip addresses
It's not a secret anymore!