File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes ip addresses Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ip addresses" Watch "ip addresses" New topic
Author

ip addresses

shilpa reddy
Greenhorn

Joined: Dec 12, 2000
Posts: 29
Hi!
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 = 1.1.1.1, 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 127.0.0.1(local 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.
Shilpa
wayne hua
Greenhorn

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

Joined: Dec 12, 2000
Posts: 29
Hi!
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,
Shilpa.
 
wood burning stoves
 
subject: ip addresses