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?
Thanks,
Pramod
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
