PH == Perrin Harkins [EMAIL PROTECTED] writes:
PH Don't open a connection during startup. If you do, it will be shared when
PH Apache forks, and sharing a database handle is bad for the same reasons
PH sharig a file handle is. Open a connection in the child process instead.
Speaking of
From: Benjamin Trott [EMAIL PROTECTED]
PH Don't open a connection during startup.
PH Open a connection in the child process instead.
BT I will second this. I've done this (unintentionally) when using MySQL, and
BT you get a lot of weird errors about statement handles being active, etc.
Rodney Broom [EMAIL PROTECTED] said something to this effect on 08/23/2001:
From: Rasoul Hajikhani [EMAIL PROTECTED]
I am sorry but this topic is confusing me... Are you saying that
persistent DB connection objects are bad?
It sounds like that, doesn't it?
This is only when one handle is
PH Don't open a connection during startup.
PH Open a connection in the child process instead.
BT I will second this. I've done this (unintentionally) when using MySQL,
and
BT you get a lot of weird errors about statement handles being active, etc.
I haven't read the entire thread, so
Nope, you've got it. If you don't have transactions (anything else?) to
worry about, I'd say to use
Apache::DBI.
Apache::DBI doesn't have a problem with transactions. If you're doing
strange things like changing isolation levels on particular requests you can
get into trouble, but that's an
From: Perrin Harkins [EMAIL PROTECTED]
Apache::DBI doesn't have a problem with transactions.
Ah, OK. What about when a shared connection is rolled back in one process, will it
effect other running processes with the same handle?
---
Rodney Broom
Programmer: Desert.Net
Apache::DBI doesn't have a problem with transactions.
Ah, OK. What about when a shared connection is rolled back in one process,
will it effect other running processes with the same handle?
Database handles are never shared between processes. If you missed this,
you should re-read the
PH Don't open a connection during startup. If you do, it will be shared when
PH Apache forks, and sharing a database handle is bad for the same reasons
PH sharig a file handle is. Open a connection in the child process instead.
I will second this. I've done this (unintentionally) when using
Benjamin Trott wrote:
PH Don't open a connection during startup. If you do, it will be shared when
PH Apache forks, and sharing a database handle is bad for the same reasons
PH sharig a file handle is. Open a connection in the child process instead.
I will second this. I've done this
BT == Benjamin Trott [EMAIL PROTECTED] writes:
that all clients also use? That is, how can I force Apache::DBI to
close that handle prior to the forking of children?
BT By using the magic 6th arg ($connect_meth in the DBI::connect source) to
BT DBI::connect. In my DB wrapper I have a
: [EMAIL PROTECTED]
Subject: Problem with DBD::Oracle with mod_perl
Hello!
I'm getting constant troubles with DBD::Oracle and mod_perl.
DBD::Oracle 1.08, DBI 1.19, mod_perl 1.26 on Apache 1.3.20,
SunOS netra 5.8 Generic_108528-09 sun4u sparc SUNW,UltraAX-i2
gcc 2.95.3 20010315 (release
On Thu, Aug 23, 2001 at 11:19:22AM -0700, Kyle Oppenheim wrote:
3. Apache::DBI intercepts the connect(), looks in it's hash and sees that it
already has a connection. It pings the handle, fails, and deletes the entry
from the hash. That's the last refcount on the dbh, so DESTROY gets
On Wed, Aug 22, 2001 at 09:42:59AM -0400, Perrin Harkins wrote:
Are you using Apache::DBI? Are you opening a connection in
the parent
process (in startup.pl or equivalent)?
Yes, yes.
Don't open a connection during startup. If you do, it will be
shared when
Apache forks, and
Are you using Apache::DBI? Are you opening a connection in the parent
process (in startup.pl or equivalent)?
Yes, yes.
Don't open a connection during startup. If you do, it will be shared when
Apache forks, and sharing a database handle is bad for the same reasons
sharig a file handle is.
On Wed, Aug 22, 2001 at 09:42:59AM -0400, Perrin Harkins wrote:
Are you using Apache::DBI? Are you opening a connection in the parent
process (in startup.pl or equivalent)?
Yes, yes.
Don't open a connection during startup. If you do, it will be shared when
Apache forks, and sharing
After some time of work (about hundred of requests), I get
DBD::Oracle::db prepare failed: ORA-03113: end-of-file on communication
channel
(DBD: error possibly near * indicator at char 1 in '*select
slogan_text
from
slogans') at /usr/local/www/lib/SQL.pm line 221.
and all Oracle-using
On Wed, Aug 22, 2001 at 09:07:59AM -0400, Perrin Harkins wrote:
(DBD: error possibly near * indicator at char 1 in '*select
slogan_text
from
slogans') at /usr/local/www/lib/SQL.pm line 221.
Are you using Apache::DBI? Are you opening a connection in the parent
process (in startup.pl or
17 matches
Mail list logo