OK, got it. Is it possible to use the same db connections in one
request? if yes, could you please show me how to implement this if a
cgi script calls many times other perl modules which requests db
connections to work.
On 7/31/07, Perrin Harkins <[EMAIL PROTECTED]> wrote:
> On 7/30/07, Ken Perl <
On 7/30/07, Dodger <[EMAIL PROTECTED]> wrote:
> You're being semantically picky with this guy, and innacurately so.
> An apache registry script *is* a CGI script. So is an ASP page, a PHP
> script, and any other interpreted way fo dealing with CGI input.
We tend to be generous with the use of the
Clinton Gormley wrote:
On Mon, 2007-07-30 at 18:21 +0800, Ken Perl wrote:
I've configured the Apache::DBI in httpd.conf like this,
PerlModule Apache::DBI
I didn't have Apache::DBI->connect_on_init($data_source, $username,
$auth, \%attr) in startup.pl since we don't use startup.pl. and the
On 7/30/07, Ken Perl <[EMAIL PROTECTED]> wrote:
> I didn't run it under ModPerl::Registry
Did you run it under some other mod_perl module, like
ModPerl::PerlRun? If it's a CGI script, and you aren't running it
through something like this, then you aren't running it through
mod_perl and you won't
I didn't run it under ModPerl::Registry, is there any risk to use the
module? maybe I have to run lots of testing to the existing scripts.
Could I just run use the previous connections via DBI->connect_cache
instead of the Apache::DBI in one single cgi script(but the script
will call other modules
On 7/30/07, Ken Perl <[EMAIL PROTECTED]> wrote:
> my question is I can not find any persistent connections for my CGI
> script.
If you are running your scripts through ModPerl::Registry, all you
need to do is call DBI->connect normally and you will get persistent
connections.
- Perrin
On Mon, 2007-07-30 at 18:21 +0800, Ken Perl wrote:
> I've configured the Apache::DBI in httpd.conf like this,
>
> PerlModule Apache::DBI
>
> I didn't have Apache::DBI->connect_on_init($data_source, $username,
> $auth, \%attr) in startup.pl since we don't use startup.pl. and the
> doc says to co
connect_on_init() creates the database connection when the Apache
child process starts (vs when it serves the first request). This
ensures that the first request gets to use an existing connection vs
having to wait for a connection to be made.
Also to benefit from Apache::DBI functionality your sc
I've configured the Apache::DBI in httpd.conf like this,
PerlModule Apache::DBI
I didn't have Apache::DBI->connect_on_init($data_source, $username,
$auth, \%attr) in startup.pl since we don't use startup.pl. and the
doc says to config it in httpd.conf is OK.
my question is I can not find any p
