On Tue, 15 Aug 2000, Pramod Sokke wrote:
> 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.
I don't think Apache::DBI works with Apache::Sybase::CTlib. You need a
separate module for that:
Apache-Sybase-CTlib
I vaguely remember I had some problem with the ping method of
Apache-Sybase-CTlib, though. I hope I am wrong.
Jie
> -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
>
>
