Re: multiple database users

[prev] [thread] [next] [Date index for 2005/06/06]

On Mon, 2005-06-06 at 12:29 +0200, Hartmaier Alexander wrote:
> And where can/should I override the default db_Main?
> I have no idea how to do that...

Do it in your cdbi base class (so all your db classes use it). See the
following for examples:

http://wiki.class-dbi.com/index.cgi?UsingMultipleDatabases
http://wiki.class-dbi.com/index.cgi?UsingWithModPerl

-mark

> -----Urspr=FCngliche Nachricht-----
> Von: William Ross [mailto:will@xxxxxxx.xxx]=20
> Gesendet: Freitag, 3. Juni 2005 10:43
> An: Hartmaier Alexander
> Cc: cdbi-talk@xxxxxx.xxxxx.xxx
> Betreff: Re: multiple database users
>=20
> On 2 Jun 2005, at 18:43, Hartmaier Alexander wrote:
>=20
> > Hi list!
> >
> > I just found out that one of my scripts is using the wrong db user =20
> > to access my database.
> >
> > I created different users with different access rights in oracle I =20
> > used before CDBI.
> >
> > The connection info is stored in the base class so a different user =20
> > means a different db connection regardless which parameter is =20
> > different.
> >
> > This topic was already on the list but for different databases but =20
> > I think it=FFs the same problem
> It is the same problem. If you want cdbi to use a different database =20
> handle under different circumstances, you need a sub db_Main() in =20
> your base class (or wherever) that selects the handle according to =20
> your criteria. That sub needs to return an appropriate =20
> DBIx::ContextualFetch object, btw, and should be as quick as possible =20
> as it's called very frequently.
>=20
>=20
> will
This email (and any attachments) is intended solely for the individual(s)=20
to whom addressed.=20
It may contain confidential and/or legally privileged information.=20
Any statement or opinions therein are not necessarily those of ITN unless s=
pecifically stated.=20
Any unauthorised use, disclosure or copying is prohibited.=20
If you have received this email in error, please notify the sender and dele=
te it from your system.=20
Security and reliability of the e-mail and attachments are not guaranteed.=20
You must take full responsibility for virus checking.

Please note that to ensure regulatory compliance and for the protection of =
our clients and business,=20
we may monitor and read e-mails sent to and from our server(s).


Independent Television News Limited,

Registered No. 548648 England,

VAT Reg. No: GB 756 2995 81,

200 Gray's Inn Road, London WC1X 8XZ,

Telephone: 020 7833 3000.