Re: Development Cycle

I use a similar technique to Brian and find that it runs things quite smoothly.
The other option you can use as you said the databases are using the same SID and your tnsnames.ora is configured on each machine, is creating a table in the db to hold your information pertinent to your links. It's essentially the same as using a text file, except all it takes is a select statement to retrieve your values.
I used to use that technique in a global.asa when programming ASP. All the files stay the same except for the global.asa and a few values in the database.

hth,

--
Joseph Ranseth - Webmaster
World Cup Fishing
http://www.worldcupfishing.com
"Brian Peasland" <peasland_at_usgs.gov> wrote in message
news:3A9A622C.89CE7058_at_usgs.gov...


> One of the things that we do is put all of our connect information in a

> flat file on our server. Then the application reads the connect

> information from this "parameter file". You then have different

> parameter files depending on which server you may be running your code

> on. For example:

>

> on my work server, I may have the following in my connect parameter

> file:

>    ip_address: 123.456.789.012

>    sid: orcl

>    username: scott

>    password: tiger

> On my home server, I will have nearly identical information, but it may

> look like:

>    ip_address: 456.789.012.345

>    sid: orcl

>    username: other_user

>    password: his_pswd

>

> Then in my code, I have something like this psuedo code:

>    begin

>      open my parameter file

>      read ip_address into var_ip_address

>      ...  (two nearly identical entries here)

>      read password into var_password

>      close my parameter file

>

>      connect to database using (var_ip_address, var_sid,

>                                 var_username, var_password)

>      begin processing

>   end;

>

> The code is the same no matter which machine you are on, it's just your

> parameter file (which defines your connection) is changed.

>

> HTH,

> Brian

>

>

> Mazur wrote:

> >

> > How do you guys keep the SID's and ip addresses of your code straight

> > during the development cycle?

> >

> > Let me explain....I have a project that I would like to work on at the

> > office where there is a Oracle instance on a server.  I write my code

> > (servlets/JSP's) on my laptop connected to the Oracle server on the LAN.

> >

> > I also have an Oracle instance at home on a server, where I write my

> > code on a desktop connected to the Oracle server on the LAN.  It has the

> > same SID name as the Oracle instance at work.  Both work and home have

> > active web servers online as well.

> >

> > When developing the code/web pages, I need to specify ip addresses for

> > web links, a SID for the database, an ip address for the Oracle server

> > to accompany the SID for the conneciton, etc.  If I am writing this code

> > at work, I can't very well take my java source files home to work on

> > them, and expect them to work on the fly....as the ip addresses for the

> > web servers are different, the ip addresses for the Oracle servers are

> > different....luckily the SID's are the same.

> >

> > Do you see the dilemna?  Of course, when I take the code home, I could

> > change all the hardcoded ip addresses and web link addresses before I

> > begin work again.  But then I would have to change them back in the

> > morning when I return to work....a bit of a pain.

> >

> > Is there some kind of cool scenario anyone uses to get around an issue

> > like this?  I mean, an answer would be "do all your development in one

> > place."  But....I would like to work at the office and at home on the

> > same project.

> >

> > Any advice would be appreciated.

> > Thank you,

> > Rob Mazur

>

> --

> ========================================

> Brian Peasland

> Raytheons Systems at

>   USGS EROS Data Center

> These opinions are my own and do not

> necessarily reflect the opinions of my

> company!

> ========================================