I mentioned that I'm using Apache::Sybase::CTlib and not Apache::DBI for
persistent connectivity. Moreover, if the module is not declared and I try
to connect in the startup file, the server won't even start. So that's
obviously taken care of.
My question is more of, how do I know for sure that my server is using the
already opened connection and is not trying to make fresh connections on
every call to 'Connect'? The error logs say : [notice] Establishing
connection to PURCHASEDB:purchasedb.
-Pramod
At 11:47 PM 8/15/00 +0000, parthasarathy mahendirababu wrote:
>Hi Pramod,
>
>Did u declare, PerlModule as Apache::DBI in the httpd.conf file or
>startup.pl in the conf subdirectory on Apache? This must be declared before
>any other Apache modules declared on the configuration file.
>
>Mahen.
>
>
>>Hi,
>>
>>I'm using Apache::Sybase::CTlib to establish persistent db connectivity in
>>an effort to move our quite old and extremely dirty scripts from Netscape
>>onto Apache with mod_perl. I'm establishing this connection on server
>>startup and I haven't changed anything in my scripts. The above-mentioned
>>module is supposed to take care of it with no changes.
>>However, in my error logs, whenever a connection is made to the db, I see
>>the message : [notice] Establishing connection to <server>:<db>, where
>>'server' is our db server and 'db' is the database name.
>>Does this mean that fresh connections are being established on every call
>>to 'Connect' in my scripts inspite of establishing a connection at server
>>startup? Does this mean that Apache is not overriding the 'connect' calls
>>from my scripts?
>>
>>Thanks,
>>Pramod
