On Wed, May 19, 2004 at 09:40:41AM -0400, Geoffrey Young wrote:
> my $dbh = DBI->connect('dbi:Oracle:HELM', 'user', 'password');
>
>
>
> local $dbh->{AutoCommit} = 0;
> local $dbh->{PrintError} = 0;
>
One good use for local as if you just set the attribute the handle gets corrupted for
i
Perrin Harkins wrote:
> Geoffrey Young wrote:
>
>> as for the the different DBI strings, are you using a post 5.8.0 perl? I
>> have suspected that the random hash foo in 5.8.1 (or whenever it was
>> added,
>> I forget) would muck up Apache::DBI's caching mechanism.
>
>
> No, the hash keys are
Geoffrey Young wrote:
as for the the different DBI strings, are you using a post 5.8.0 perl? I
have suspected that the random hash foo in 5.8.1 (or whenever it was added,
I forget) would muck up Apache::DBI's caching mechanism.
No, the hash keys are sorted.
- Perrin
--
Report problems: http://perl
please keep responses on list so everyone can benefit from the archives :)
[EMAIL PROTECTED] wrote:
> I am exploring this right now. The problem though is the explosion of
> connections. we go from 100->600 in about 2 minutes. We can't
> correlate it to the load, and I can't find anywhere that
[EMAIL PROTECTED] wrote:
> We are having a problem with the oracle sessions running wild. We
> have five web servers that run 6 servers.
> StartServers 6
> MaxClients 32
according to the your settings you _start_ 6 servers (well, child
processes). you allow up to 32 processes (each with it'
When using Apache::DBI you must remember that it caches the connections by using the
connection string it you have two types of connection say one with autocommit on and
the other with it off this is cached as two connections.
If you do not have a standard method/module for making your database
