(wrong string) – is they a way to provide indirection for db name?

From: <zigzagdna_at_yahoo.com>
Date: Tue, 6 Jan 2009 14:29:57 -0800 (PST)
Message-ID: <9dd977e6-0dc4-4f14-b539-6f9d4209ecaf_at_r15g2000prh.googlegroups.com>

On Jan 5, 1:16 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Jan 5, 12:35 pm, ddf <orat..._at_msn.com> wrote:
>
>
>
>
>
> > On Jan 5, 11:24 am, zigzag..._at_yahoo.com wrote:
>
> > > A third party application is using JDBC URL to connect to Oracle,
>
> > > jdbc:oracle:thin:scott/tiger_at_MyOracleHost:1521:MyDB
>
> > > For some reason in third party application, same URL has to be used
> > > for
> > > Dev, QA and Production. I know using /etc/hosts (Or its equivalent in
> > > Windows), I can point MyOracleHost to different hosts. But, is there
> > > any way to point  MyDB to different database names.
>
> > No, as that is the SID of the instance/database for the connection;
> > it's not a TNS alias.
>
> > David Fitzjarrell
>
> Without changing the connect string presented then I agree with
> David.  The application should be written so that it builds the
> connect string.  We use something like below:
>
> jdbc:oracle:thin:_at_(description=(address=(protocol=tcp)(host=db_server)
> (port=1521))(connect_data=(SERVICE_NAME = test.world)))
>
> The connect data comes from a Webserver configuration file so the same
> code can be ran against multiple targets just based on the webserver
> configuration.
>
> Have you checked to see if there is a provided way to configure the
> third-party connect string information.
>
> HTH -- Mark D Powell --- Hide quoted text -
>
> - Show quoted text -

Information provided by Mark and Steve solved my problem. I cannot thank them enough because it saved me so much work. It really shows the benefit of the news groups. Thanks to others as well for their input. Received on Tue Jan 06 2009 - 16:29:57 CST