I can run the following code with DBI
but in Apache::DBI.
#!/usr/bin/perl -w
use DBI;
sub connect{
$dbh = DBI->connect("dbi:Pg:dbname=test", "canis",$password);
$sth = $dbh->prepare("SELECT clave, denominacion FROM Marca")
|| die $dbh->errstr;
$sth
ll md5
or make it IP based:
host allall1.2.3.4255.255.255.255 md5
you get the idea. That way, it'll obey the username/password that you supply.
On Thursday 28 August 2003 04:28 pm, wrote:
> Hello, every body
>
> I can run the following subroutine in DBI, bu
Hello, every body
I can run the following subroutine in DBI, but Apache::DBI...
use DBI;
sub connect{
$dbh = DBI->connect("dbi:Pg:dbname=test", "canis","3dsadasz");
$sth = $dbh->prepare("SELECT clave, denominacion FROM Marca")
> >I've set Apache::DBI::DEBUG to 2, and I'm not seeing _any_ messages
> >(from it) in the error log. Apache::Status lists Apache DBI, but
> >lists no database connections.
>
> A long time ago, one problem used to be that if your connect to
> Postgres
[EMAIL PROTECTED] wrote:
I've got a case where my DBI connections appear to be timing out and not
reconnecting. Google just points to the old timeout problem that should
be solved.
I've set Apache::DBI::DEBUG to 2, and I'm not seeing _any_ messages
(from it) in the error log.
I've got a case where my DBI connections appear to be timing out and not
reconnecting. Google just points to the old timeout problem that should
be solved.
I've set Apache::DBI::DEBUG to 2, and I'm not seeing _any_ messages
(from it) in the error log. Apache::Status lists Apache
On Mon, 18 Aug 2003, wrote:
> Date: Mon, 18 Aug 2003 16:57:13 -0700
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Apache::DBI
>
> What's the diference between DBI and Apache::DBI?
Have you bothered to read the docs at all?
http://s
What's the diference between DBI and Apache::DBI?
--
Reporting bugs: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
On Mon, 2003-08-18 at 11:33, K Old wrote:
> My problem was that I was not declaring "PerlModule Apache::DBI" in
> httpd.conf BEFORE my "PerlRequire /etc/httpd/conf/startup.pl". Also, I
> was doing a "use Apache::DBI" in my startup.pl file, which I sho
On Sun, 2003-08-17 at 11:41, Perrin Harkins wrote:
> On Fri, 2003-08-15 at 10:34, K Old wrote:
> > What's happening is that with "use Apache::DBI" uncommented in either
> > the httpd.conf or startup.pl Apache does not start.
>
> Do you have something in y
On Fri, 2003-08-15 at 10:34, K Old wrote:
> What's happening is that with "use Apache::DBI" uncommented in either
> the httpd.conf or startup.pl Apache does not start.
Do you have something in your code that connects to a database during
startup? That could be a problem. A
I left out my version of Perl. I'm using 5.6.1 from RPM.
Kevin
On Fri, 2003-08-15 at 10:34, K Old wrote:
> Hello everyone,
>
> I've set mod_perl up with Apache::DBI on several servers, both with
> mod_perl from RPM's and building it myself, but I am having a horrib
Hello everyone,
I've set mod_perl up with Apache::DBI on several servers, both with
mod_perl from RPM's and building it myself, but I am having a horrible
time with a new server I've just built. Go easy, I'm still new at it,
though. And I welcome any and all constructive cri
ast_wvr) VALUES(?,?,?,?);");
Then in a member function, called later:
call execute on the by_name handle to see if new name already exists
if it doesn't
call execute on the insert handle with the new row data
then call the select by name handle to get the id that was used to creat
what would happen. If two processes incremented the
sequence at the same time, what would the function return, the value
for that connection's insert, or the value of the other session?
Especially when I added Apache::DBI to the mix where db connections appear
to be pooled and shared. This way I k
added.
But when I do it from my mod_perl app, it sometimes jumps by two. I know the sequence will advance even if there's an error, but I'm not getting any error messages back from DBI.
Has anyone else run across something like this? I know this is kind of off topic, but it maybe
Hi,
Over the past few months I have posted a couple of fixes in relation to how
Apache::DBI handles are cleaned up. This however is the most complete fix in
that it covers the following issues :-
TimeOut = 0 :
Should always ping even when multiple requests are made in
On Tue, 22 Jul 2003 14:15:41 -0700
Michael A Nachbaur <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I know from a DBI perspective, when using PostgreSQL, if I create a
> temporary database table it will automatically go *poof* and be
> deleted when the database connection i
On Tue, 2003-07-22 at 17:15, Michael A Nachbaur wrote:
> If I do a $dbh->disconnect, I know it will be ignored by Apache::DBI, but is
> it smart enough to pass something back to the database server telling it that
> it can purge temporary data?
No. If you come up with a way to do t
Hello all,
I know from a DBI perspective, when using PostgreSQL, if I create a temporary
database table it will automatically go *poof* and be deleted when the
database connection is closed (or when the transaction is finished...I can't
remember which). Anyway, what will happen if code
Beau E. Cox wrote:
Hi -
I am running Apache 2.0.47/mod_perl 1.99-dev-10-cvs
on SuSE Linux 8.2. I am trying to install and use
Apache::DBI.
[...]
2) The documentation says to configure mod_perl with:
perl Makefile.PL PERL_CHILD_INIT=1 PERL_AUTHEN=1 PERL_AUTHZ=1
PERL_CLEANUP
- Original Message -
From: "Haroon Rafique" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 3:23 AM
Subject: Re: [mp2] Apache::DBI
> On Yesterday at 10:01pm, BEC=>Beau E. Cox <[EMAIL PROTECTED]> wrote:
>
> BEC>
> B
i Beau,
I'm using apache 2.0.46, mod_perl 1.9909, perl v5.8.0, Apache::DBI 0.91 on
a Gentoo kernel 2.4.20-ck6 without any problems in production. I have had
no problems with using connect_on_init either. I have:
use Apache::compat ();
as my first use statement in my mod_perl startup.pl file
Hi -
I am running Apache 2.0.47/mod_perl 1.99-dev-10-cvs
on SuSE Linux 8.2. I am trying to install and use
Apache::DBI.
1) I get this error in make test:
is($thread_1, $thread_2, "got the same connection both times");
It seems the I do not get the same connection.
2) The doc
Hi,
Came accross a bug when when trying to reduce creation of handles on a site.
Currently Apache::DBI makes the assumption that it AutoCommit => 1 then the handle
does not need cleaning up. This is not neccessariliy true as begin_work switches off
the AutoCommit for one transaction.
Fi
Patrick Mulvany wrote:
Hi,
Came accross an issue when trying to reduce creation of handles on a site.
Currently Apache::DBI makes the assumption that it AutoCommit => 1 then the handle does not need cleaning up. This is not neccessariliy true as begin_work switches of the AutoCommit for
Patrick Mulvany wrote:
> On Tue, Jun 10, 2003 at 04:27:17PM +1000, Stas Bekman wrote:
>> connect_on_init() should probably be not used.
>
>
> connect_on_init() pushs to a list of connection strings to start on child
> creation. &childinit should be called as a PerlChildInitHandler (not sure
> when
Hi,
Came accross an issue when trying to reduce creation of handles on a site.
Currently Apache::DBI makes the assumption that it AutoCommit => 1 then the handle
does not need cleaning up. This is not neccessariliy true as begin_work switches of
the AutoCommit for one transaction.
To be s
--- Stas Bekman <[EMAIL PROTECTED]> wrote:
> Perrin Harkins wrote:
> > On Tue, 2003-06-10 at 01:45, Stas Bekman wrote:
> >
> >>mp2+winFU => winnt MPM => no forking, only threads
> => Apache::DBI is useless
> >>there. not only useless, bu
On Tue, Jun 10, 2003 at 04:27:17PM +1000, Stas Bekman wrote:
> Perrin Harkins wrote:
> >On Tue, 2003-06-10 at 01:45, Stas Bekman wrote:
> >
> >>mp2+winFU => winnt MPM => no forking, only threads => Apache::DBI is
> >>useless there. not only useless, but
Perrin Harkins wrote:
On Tue, 2003-06-10 at 01:45, Stas Bekman wrote:
mp2+winFU => winnt MPM => no forking, only threads => Apache::DBI is useless
there. not only useless, but also wasteful, since it's going to do work that
has no added value.
But how is this any different
On Tue, 2003-06-10 at 01:45, Stas Bekman wrote:
> mp2+winFU => winnt MPM => no forking, only threads => Apache::DBI is useless
> there. not only useless, but also wasteful, since it's going to do work that
> has no added value.
But how is this any different from separate
Perrin Harkins wrote:
On Mon, 2003-06-09 at 21:02, Stas Bekman wrote:
Paul Simon wrote:
So, according to the docs,
http://perl.apache.org/docs/2.0/user/performance/mpm.html#Work_with_DataBases_under_Threaded_MPM,
using Apache::DBI doesn't do anything under
mp2+windows2000 ...
That'
On Mon, 2003-06-09 at 21:02, Stas Bekman wrote:
> Paul Simon wrote:
> > So, according to the docs,
> > http://perl.apache.org/docs/2.0/user/performance/mpm.html#Work_with_DataBases_under_Threaded_MPM,
> > using Apache::DBI doesn't do anything under
> > mp2+win
Paul Simon wrote:
So, according to the docs,
http://perl.apache.org/docs/2.0/user/performance/mpm.html#Work_with_DataBases_under_Threaded_MPM,
using Apache::DBI doesn't do anything under
mp2+windows2000 ...
That's correct. Since Apache::DBI does per-process pooling, and apache 2.0 on
w
So, according to the docs,
http://perl.apache.org/docs/2.0/user/performance/mpm.html#Work_with_DataBases_under_Threaded_MPM,
using Apache::DBI doesn't do anything under
mp2+windows2000 ... What is the status of DBI::Pool?
These modules deal mainly with persistent database
connections. Is
We've been having some problems with our Oracle 8.1.5 database on AIX, which has
highlighted what looks like a problem with Apache::DBI. To cut a very long story
short, due to an Oracle problem database handles are becoming invalid reasonably
frequently. In this case, we would expect Apache
On Wed, May 14, 2003 at 10:48:45AM -0400, Eric Sammer wrote:
> Not really a problem (yet), but out of curiousity...
>
> I'm using Apache::DBI with postgres and while not serving requests, all
> the postgres processes are listed as "idle in transaction." Obviously,
&
[please keep the threads on the list unless requested otherwise]
Georg Botorog wrote:
Thanks. But I still have not understood how I avoid to include
Apache::DBI in the current version of Apache (2). In mp1, there was an
explicit inclusion statement in httpd.conf, which I could leave out. I
have
Georg Botorog wrote:
Hello,
In mod_perl1, using persistent (Apache::DBI) and dedicated, per-user
connections (DBI) on the same machine required running two Apache
instances, one with Apache::DBI and the other without it.
Has anything about that changed in mod_perl2?
Moreover, how does Apache2
> Hello,
>
> In mod_perl1, using persistent (Apache::DBI) and dedicated, per-user
> connections (DBI) on the same machine required running two Apache
> instances, one with Apache::DBI and the other without it.
>
> Has anything about that changed in mod_perl2?
>
> More
parts of $dbh, because of the constraints of
sharing Perl datastructures and underlying C structs.
Apache::DBI explicitly calls $dbh->rollback (when things are
configured so it makes sense). Or maybe I am completely
misunderstanding you.
All I was saying is, that whatever worked for Apache::
t rips off only parts of $dbh, because of the constraints of
> sharing Perl datastructures and underlying C structs.
Apache::DBI explicitly calls $dbh->rollback (when things are
configured so it makes sense). Or maybe I am completely
misunderstanding you.
> > ps. yes, your DBI::Pool wo
f the constraints of
sharing Perl datastructures and underlying C structs.
ps. yes, your DBI::Pool work is great. Thank you. :-)
My pleasure. Thanks for the kind words. It's quite challenging, though you
stop getting excited about segfaults and ddd (gdb frontend) is nowadays my
b
uch to change for this feature.
If the physical connection is still there, would the database server
do a rollback?
- ask
ps. yes, your DBI::Pool work is great. Thank you. :-)
--
ask bjoern hansen, http://www.askbjoernhansen.com/ !try; do();
Perrin Harkins wrote:
Stas Bekman wrote:
FWIW, we are discussing the internal DBI pooling mechanism at the
dbi-dev list and having already a sort-of-working prototype. So
hopefully there will be no need for Apache::DBI in the near future, as
DBI will be able to handle pooling internally
Stas Bekman wrote:
FWIW, we are discussing the internal DBI pooling mechanism at the
dbi-dev list and having already a sort-of-working prototype. So
hopefully there will be no need for Apache::DBI in the near future, as
DBI will be able to handle pooling internally. However it may take some
Ask Bjoern Hansen wrote:
On Wed, 5 Mar 2003, Stas Bekman wrote:
Great. I've already committed that patch.
Perhaps Ask could load 'Apache::compat' inside Apache::DBI if mp2 is used. Or
to use the mp2 API if mp2 is used.
That seems like it'll be an easy solution. I th
On Wed, 5 Mar 2003, Stas Bekman wrote:
> Great. I've already committed that patch.
>
> Perhaps Ask could load 'Apache::compat' inside Apache::DBI if mp2 is used. Or
> to use the mp2 API if mp2 is used.
That seems like it'll be an easy solution. I thought loading
Haroon Rafique wrote:
On Today at 11:16am, SB=>Stas Bekman <[EMAIL PROTECTED]> wrote:
SB> FWIW, we are discussing the internal DBI pooling mechanism at the
SB> dbi-dev list and having already a sort-of-working prototype. So
SB> hopefully there will be no need for Apache::DBI
On Today at 11:16am, SB=>Stas Bekman <[EMAIL PROTECTED]> wrote:
SB> FWIW, we are discussing the internal DBI pooling mechanism at the
SB> dbi-dev list and having already a sort-of-working prototype. So
SB> hopefully there will be no need for Apache::DBI in the near future, as
SB
FWIW, we are discussing the internal DBI pooling mechanism at the dbi-dev list
and having already a sort-of-working prototype. So hopefully there will be no
need for Apache::DBI in the near future, as DBI will be able to handle pooling
internally. However it may take some time, as the drivers
My setup is as follows:
Apache/2.0.44 (Gentoo/Linux) mod_perl/1.99_08 Perl/v5.8.0
mod_perl was built from CVS.
I was interested in getting Apache::DBI to run under mp2. I did read
Ask's message at
http://marc.theaimsgroup.com/?l=apache-modperl&m=104225578207460&w=2
which l
> This is the only error line that appears in the error_log.
> [Sun Mar 2 20:10:19 2003] [notice] caught SIGTERM, shutting down
>
Perhaps it's me, but could you please create a copy-n-paste mail
with the (correct) relevant code snippets (httpd.conf, startup.pl,
etc.). This might help.
Best rega
Richard Clarke wrote:
As soon as I activate the line identified as 'trouble line', my apache
server dies.
Can you elaborate on this.. how does it die?, what is the error msg? etc..
(That is assuming it's still a problem after upgrading to latest
DBI/Apache::DBI as Stas
> As soon as I activate the line identified as 'trouble line', my apache
> server dies.
Can you elaborate on this.. how does it die?, what is the error msg? etc..
(That is assuming it's still a problem after upgrading to latest
DBI/Apache::DBI as Stas suggested).
Ric.
Feite Brekeveld wrote:
Richard Clarke wrote:
PerlModule Apache::DBI;<<-- trouble line
This line belongs in your httpd.conf file.
PerlModule is an apache configuration directive, not a perl 'command'.
http://perl.apache.org/docs/1.0/g
Richard Clarke wrote:
PerlModule Apache::DBI;<<-- trouble line
This line belongs in your httpd.conf file.
PerlModule is an apache configuration directive, not a perl 'command'.
http://perl.apache.org/docs/1.0/guide/config.html#PerlModule_and_PerlReq
> PerlModule Apache::DBI;<<-- trouble line
This line belongs in your httpd.conf file.
PerlModule is an apache configuration directive, not a perl 'command'.
http://perl.apache.org/docs/1.0/guide/config.html#PerlModule_and_PerlRequire
_Directives
Ric.
Hi,
I'm trying to configure mod_perl for use with persistent database
connections with Apache::DBI
RedHat 7.3
Apache 1.3.23
mod_perl 1.26
I've configured the following 'startup.pl' file:
-
#!/usr/bin/perl
BEGIN {
use Apach
ot thickens. Loading mod_perl statically gets rid of this
problem.
> Even with otherwise-identical configure arguments.
>
> Yet, the DSO mod_perl works fine except when I preload DBI.
>
> I'm _quite_ confused. I'd really like the DSO method to work, as then I
>
On Wed, Feb 26, 2003 at 02:05:24PM -0500, Dan Brosemer wrote:
> This is not the problem I'm seeing at all. You'll note from this thread
> http://monkey.org/openbsd/archive/misc/0302/msg01943.html
> that I see this same problem when using the sources from apache.org (no
> chroot available to be a p
On Wed, Feb 26, 2003 at 11:45:32AM -0700, [EMAIL PROTECTED] wrote:
> On Wed, Feb 26, 2003 at 01:09:46AM -0500, Dan Brosemer wrote:
> > Here's the thread to date:
> > http://marc.theaimsgroup.com/?l=apache-modperl&m=104586287823510&w=2
> helo;
> I am seeing problems with mod_perl in OpenBSD 3.2
On Wed, Feb 26, 2003 at 01:09:46AM -0500, Dan Brosemer wrote:
> Here's the thread to date:
> http://marc.theaimsgroup.com/?l=apache-modperl&m=104586287823510&w=2
helo;
I am seeing problems with mod_perl in OpenBSD 3.2
chroot env. This has me twiddling my thumbs after tailing my
error_log:) An
cal configure arguments.
Yet, the DSO mod_perl works fine except when I preload DBI.
I'm _quite_ confused. I'd really like the DSO method to work, as then I
wouldn't have to modify the OpenBSD source tree (any more than I normally
do, anyway). Does anyone have suggestions?
Even po
On Sun, Feb 23, 2003 at 04:26:51PM +0100, Dr. Helmut Zeilinger wrote:
> Hi Dan,
>
> i had a similar problem with DBI. Did you reinstall (recompile) the
> DBI module after you installed Perl 5.80 from a previous Perl version (and
> maybe all DBD drivers)?
No. This was a fresh ins
Hi Dan,
i had a similar problem with DBI. Did you reinstall (recompile) the
DBI module after you installed Perl 5.80 from a previous Perl version (and
maybe all DBD drivers)?
Helmut
--On Friday, February 21, 2003 16:28:19 -0500 Dan Brosemer
<[EMAIL PROTECTED]> wrote:
Hi. I'm ne
DBD::mysql? Did
No. This is the initial version of both mysql and postgresql.
> DBD::mysql pass all tests when you installed it?
When I 'make test', Msql-Mysql-modules-1.2219 reports:
All tests successful, 1 test and 14 subtests skipped.
Since my test program runs fine outside of a
On Fri, 21 Feb 2003, Dan Brosemer wrote:
> Hi. I'm new here, and hoping someone can help me. I've installed the
> latest -current version of OpenBSD, and loaded mod_perl as a DSO. That gets
> me Apache 1.3.27, Perl 5.8.0, and mod_perl 1.27.
[...]
> These are taken using DBD::mysql. I'd be happ
Hi. I'm new here, and hoping someone can help me. I've installed the
latest -current version of OpenBSD, and loaded mod_perl as a DSO. That gets
me Apache 1.3.27, Perl 5.8.0, and mod_perl 1.27.
Apache starts fine, but when I try to access any script that does
DBI->connect(...), i
This is the last piece in my implementation. If anyone can help with how to
debug this or what is wrong with my configuration, I'd really appreciate it!
I'm trying DBI::Auth against a Postgresql database for authentication. It's
not working. My postgres debug log shows no acti
I'm trying DBI::Auth against a Postgresql database for authentication. It's
not working. My postgres debug log shows no activity as well as this error
regarding my configuration. I don't know how to debug this. Anyone able to
help?
Error Log from Apache shows:
[Tue Feb 1
[EMAIL PROTECTED] wrote:
> Any plans to make Apache::FakeRequest work well enough to make this
> possible?
[EMAIL PROTECTED] wrote:
> As for mod_perl 1.0, I'm not sure, but if you can make it useful
> that would be cool.
A while back Andrew Ho posted his script, apr, that is similar to
Apache::Fa
[EMAIL PROTECTED] wrote:
Any plans to make Apache::FakeRequest work well enough to make this
possible?
There are plans. Here is an entry from modperl-2.0/todo/api.txt:
Apache::FakeRequest:
since APR can be used outside of httpd, and we can alloc request_rec
and similar structures, it should be
rl"
<[EMAIL PROTECTED]>
Subject:RE: Apache::DBI and mod_perl 2
>> Also remember, that you can't test modules that require mod_perl
>> to run from
>> the command line. You'd have the same result with mod_perl 1.0
>>
Thanks, I didn't k
>> Also remember, that you can't test modules that require mod_perl
>> to run from
>> the command line. You'd have the same result with mod_perl 1.0
>>
Thanks, I didn't know that at all as I test all my modules that way and have
never had a problem.. Of course most are not mod_perl specific.
-Ch
Chris Faust wrote:
Hey Helmut,
Yes, I'm sure its Apache::DBI - when I try to check for it directly via
"perl -MModule::Name", I get the error..
Where is a copy paste from the command line.
[chrisf@web1 chrisf]$ perl -MApache::DBI -e 0
Can't locate Apache/Constants.pm in
t; To: Chris Faust
>> Cc: Modperl
>> Subject: RE: Apache::DBI and mod_perl 2
>>
>>
>> On Fri, 14 Feb 2003, Chris Faust wrote:
>>
>> > Maybe that is the problem?
>> >
>> > I'm using 0.89 which is the newest from CPAN and that shows
On Fri, 14 Feb 2003, Chris Faust wrote:
> Maybe that is the problem?
>
> I'm using 0.89 which is the newest from CPAN and that shows Jun 18..
> Is there a later version available?
You can always search the archives of this list at
http://marc.theaimsgroup.com/?l=apache-modperl&r=1&w=2
The mess
gt;> To: Chris Faust
>> Cc: Modperl
>> Subject: Re: Apache::DBI and mod_perl 2
>>
>>
>>
>>
>> Do you have the latest Apache::DBI ? Ask made a new one a couple of weeks
>> ago to run with mp2.
>>
>>
>> On Fri, 14 Feb 2003, Chris Fa
Hey Helmut,
Yes, I'm sure its Apache::DBI - when I try to check for it directly via
"perl -MModule::Name", I get the error..
Where is a copy paste from the command line.
[chrisf@web1 chrisf]$ perl -MApache::DBI -e 0
Can't locate Apache/Constants.pm in @INC (@INC contains:
Do you have the latest Apache::DBI ? Ask made a new one a couple of weeks
ago to run with mp2.
On Fri, 14 Feb 2003, Chris Faust wrote:
> Hi,
>
> My problem seems like one that would be well documented, but I can't find
> anything in any of the docs and even goggle gr
Hi Chris,
are you shure that is is the Apache::DBI, that needs the Apache::Constants
or is it another module?
For me Apache::DBI loads without problems (2.044/1.9908/5.8) even without
the
"use compat();" compatibility layer.
Helmut
--On Friday, February 14, 2003 09:00:31 -0500 C
Hi,
My problem seems like one that would be well documented, but I can't find
anything in any of the docs and even goggle groups only had one message and
the solution didn't relate.
Anyway, I've updated to RedHat 8.0 and Apache 2.0.44 with Mod_Perl 1.99.08
and if I try to us
could use mod_macro. I'm sure it would work to put
them in DBI (although you'd better close that connection before Apache
forks!), but then you have a bunch of config data that can only be
changed by messing with SQL and can no longer be easilly viewed, diffed,
versioned, etc.
- Perrin
Has anyone any information on success/horror stories for using DBI in apache config
files. I have a number of
PerlModule Library::Module
SetHandler Perl-Script
PerlHandler Library::Module
Type configs.
I can very easily extract this information from a database. Is using DBI
ctive.
So, you are using 1.x on NT. With 1.x, all requests are handled
serially on NT, which explains the behavior you're getting. It's
actually not related to DBI at all.
See http://perl.apache.org/docs/1.0/os/win32/multithread.html for the
full story.
- Perrin
ously. However, Oracle has only one session for the
job.
Each thread has its own Perl interpreter and each one of those will have
a persistent DBI connection when using Apache::DBI. Nothing is shared
between threads unless you explicitly make it shared.
There is currently no way to share DBI ha
nt: Friday, January 24, 2003 7:30 PM
> To: Georg Botorog
> Cc: [EMAIL PROTECTED]
> Subject: Re: Connection pool with Apache::DBI and Oracle
>
> Georg Botorog wrote:
> > More precisely, I am using Apache::DBI to create and cache the
> > connection to the DB. As
Georg Botorog wrote:
More precisely, I am using Apache::DBI to create and cache the
connection to the DB. As this connection uses a single Oracle session,
it is obvious that it becomes a bottleneck.
Apache::DBI uses one connection per process. There is no bottleneck
there. Each process only
Hi,
I would like to know if there is a module that implements a pool of
connections to an Oracle database.
More precisely, I am using Apache::DBI to create and cache the
connection to the DB. As this connection uses a single Oracle session,
it is obvious that it becomes a bottleneck. On the
Daryl Lee wrote:
Should I expect DBI to work with mod_perl2? I have a simple script that
just connects to a MySQL database and reports success or faiure. When I
run it from cgi-bin as a regular CGI script, it succeeds. When I put it in
my mod_perl script directory, it runs, but fails to
Should I expect DBI to work with mod_perl2? I have a simple script that
just connects to a MySQL database and reports success or faiure. When I
run it from cgi-bin as a regular CGI script, it succeeds. When I put it in
my mod_perl script directory, it runs, but fails to connect. My mod_perl
On Fri, 10 Jan 2003, Beau E. Cox wrote:
> I had heard moving A:DBI to 2 was going to be very difficult!
> I've been waiting...
As Stas said, it really wasn't. You might even have been able to
with Apache::compat; I did not try.
The harder part is to make the database handles shared across a poo
has a pool per proc/thread, no sharing.
But you still benefit from the per-process cache just as in mod_perl 1.0.
[...]
0.90_02 January 10, 2003
- Changes to make Apache::DBI load and function under mod_perl
2.0.
_
CTED]
Subject: [ANNOUNCE] Apache::DBI 0.90_02
Last night I spent a bit of time making a proper test for
Apache::DBI and make it work without Apache.pm. Just now I made it
work with mod_perl 2.0. I have only tested that very briefly.
Until it hits your CPAN mirror, get it from:
http://develooper.co
Last night I spent a bit of time making a proper test for
Apache::DBI and make it work without Apache.pm. Just now I made it
work with mod_perl 2.0. I have only tested that very briefly.
Until it hits your CPAN mirror, get it from:
http://develooper.com/code/Apache::DBI/
Or from CVS
On Mon, 6 Jan 2003, Paul Simon wrote:
> --- Randy Kobes <[EMAIL PROTECTED]> wrote:
>
> > Are you using the latest versions of DBI and
> > DBD::ODBC?
> > If not, does an upgrade help?
>
> Those modules are - whatever was bundled with your
> first, warmly
Paul Simon wrote:
I wasn't sure if Apache::DBI was screwing with ORACLE,
especially with persistent connections...
The Apache::DBI code is really short and easy to read. Basically, it
just doesn't close connections when you call disconnect. It also does
automatic rollbacks at
--- Randy Kobes <[EMAIL PROTECTED]> wrote:
> On Thu, 2 Jan 2003, Paul Simon wrote:
>
> > Hi all
> >
> > I have a feeling this may be [OT], "take it to the
> DBI
> > list..." But I'm hoping to eliminate as much as
> > possible any susp
1 - 100 of 1020 matches
Mail list logo