Thanks for the feedback.
I'm confused regarding multiple connections to the
same database/user. What's the point in ever having multiple
connections to the same database/user, other than say, one
having PrinError=>0 and the other having PrintError=>1.
Or is having different attributes itself the only reason?
Since connections cannot be used simultaneously, there's no
advantage that I'm aware of (at least in Oracle, my area of
familiarity) in connecting to the same database more
than once. I'd be interested in an example where this
would be useful, in Oracle or any other database (just
to expand my understanding)
Thanks,
Mark
--- Adrian Howard <[EMAIL PROTECTED]> wrote:
> I'd say the current behaviour is correct. I have situations where I
> have multiple DBI connects to the same DB with different attributes.
> I
> don't want these munged into the same $dbh if I choose to use
> connect_cached.
>
> I also don't want the state of my handles changed if another piece of
>
> code uses connect_cached while my libraries have an active handle.
>
> Adrian
>
> On Tuesday, March 4, 2003, at 03:11 am, M. Addlework wrote:
>
> > connect_cached creates a _new_ connection on the second call
> > in this sample (only difference being PrintError attribute)
> >
> > DBI->connect($data_source, $user, $auth, {PrintError=>1});
> > DBI->connect($data_source, $user, $auth, {PrintError=>0});
> >
> > I would submit that this is "wrong" behavior, and that the
> > PrintError behavior is not an integral part of the user's
> > conception of a database connection, but rather is a _state_
> > of a given connection. Accordingly, the second call should
> > return the same db handle, but change the PrintError state
> > before doing so.
> >
> > Comments? Am I right? Or do people explicitly depend
> > on getting new connections unpon changing a DBI-specific
> > atribbute?
> >
> > Thanks,
> >
> > Mark
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> >
>
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
