Pramod Sokke writes:
> Hmmm, the reason I'm not using Apache::DBI right now is coz our current
> scripts are using DBlib to talk to Sybase. Looks like I have to make
> thousands of changes all over the place after all and start using DBI.
> Those of you folks already using Apache::DBI, can you tell me what kind of
> message is logged in webserver error logs everytime a call to 'connect' is
> made?
There's an Apache::Sybase::DBlib module floating around somewhere that
you could use if you don't want to make all those changes.
However, in general it's a lot better if you can avoid having API
calls all over the place.
For example in the app I'm currently writing there is only 1
subroutine that calls the database API (Sybase::CTlib, in this case).
This adds a bit of overhead in the perl code, but cuts *way* down on
the code maintenance!
Michael
> At 02:21 PM 8/16/00 -0400, Shimon Rura wrote:
> >It seems to be starting a new connection each time. If you want connection
> >pooling, you should use the Apache::DBI module, which will transparently
> >pool DBI connections for you.
> >
> >Shimon Rura
> >
> >> Hi all,
> >>
> >> I think I misled everybody with my previous question on this topic. To put
> >> it in simple words:
> >> Apache 1.3.12/mod_perl 1.24/Solaris 2.7
> >> I'm establishing db connection at server startup and the logs indicate
> >> that's done. But in my subsequent calls to 'connect' in my scripts, I see
> >> the same message "Establishing connection to PURCHASEDB:purchasedb" in my
> >> webserver error log. Does this mean it's ignoring the already available db
> >> handle and making fresh connections?
> >> In other words, how do I make sure whether the original handle is used or
> >> if a fresh connection is established?
> >> Any help is greatly appreciated.
> >>
> >> Thanks,
> >> Pramod
>
--
Michael Peppler -||- Data Migrations Inc.
[EMAIL PROTECTED] -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: [EMAIL PROTECTED]