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

From: <zigzagdna_at_yahoo.com>
Date: Mon, 5 Jan 2009 15:11:49 -0800 (PST)
Message-ID: <41252b4e-3673-451e-96e0-cd011a00d6b2_at_x16g2000prn.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 -

Mark:

Thanks a lot, it could work.

Prem Received on Mon Jan 05 2009 - 17:11:49 CST