this way, I jumptoo quick on 'too much connection'...
Any chance that you misuse Apache::DBI?
http://perl.apache.org/guide/databases.html#When_should_this_module_be_used_
Emmanuel
--
EDENJOB / APR-Job
Email: [EMAIL PROTECTED]Home:www.apr-job.com
Phone: +33
a database server that contains multiple databases, and you're accessing 2
different databases on the same server with your mod_perl/DBI/Apache-DBI apps, you're
going to have double the number of persistent connections to your databases then
you're going to have child processes.
Additionally, if you use
From: Geoffrey Young [mailto:[EMAIL PROTECTED]]
you need both, DBI and Apache::DBI, with DBI loaded first...
I tried this, but I still get the same error.
see the Apache::DBI manpage for more detail
That man page is the same as the DBI manpage- it doesn't include
any modperl specific
From: Geoffrey Young [mailto:[EMAIL PROTECTED]]
you need both, DBI and Apache::DBI, with DBI loaded first...
I tried this, but I still get the same error.
sorry, I gave you bad information - Apache::DBI needs to be
loaded first...
it was late :)
That's okay- I've tried it both
-Original Message-
From: Brad Howerter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 12:42 PM
To: ''[EMAIL PROTECTED]' '
Subject: RE: Apache::DBI::connect problem, please help
From: Geoffrey Young [mailto:[EMAIL PROTECTED]]
you need both, DBI and Apache
-Original Message-
From: Brad Howerter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 12:57 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Apache::DBI::connect problem, please help
[snip]
So Apache/DBI.pm must be installed incorrectly on my system.
It's supposed
Emmanuel Pierre wrote:
Hi all,
on my DB server I have 245 "idle" postmasters process for 130 httpd
persistant DB connections alive.
make sure you use the same connect attributes each time you invokes
DBI-connect().
eg, a connect() with {RaiseError=1} and another connect with
{Ra
you need both, DBI and Apache::DBI, with DBI loaded first...
see the Apache::DBI manpage for more detail
HTH
--Geoff
-Original Message-
From: Brad Howerter
To: '[EMAIL PROTECTED]'
Sent: 2/19/01 6:54 PM
Subject: Apache::DBI::connect problem, please help
I'm getting this error:
[error
.
Thanks,
-Eric.
Eric Peters wrote:
Hi all-
I'm really having a problem I hope I might be able to get some help
with. I'm using Apache 1.3.14, mod_perl 1.24, DBI 1.14, MySQL Modules 1.2215,
Perl 5.6.0, and MySQL 3.22.32. (I think that's all that's relevant)
In my httpd.conf
Hi all-
I'm really having a problem I hope I might be able to get some help
with. I'm using Apache 1.3.14, mod_perl 1.24, DBI 1.14, MySQL Modules 1.2215,
Perl 5.6.0, and MySQL 3.22.32. (I think that's all that's relevant)
In my httpd.conf I have the following
Hi there,
I am new to mod_perl and currently trying to make use of Apache::DBI.
This is my enviroment:
Suse Linux 6.3, Apache 1.3.12, mod_perl 1.24 and Oracle 8i. I am using
HTML:Mason as well, as a templating system. Everything works.
Apache::DBI is loaded via httpd.conf by Apache properly
Hi there,
I am new to mod_perl and currently trying to make use of Apache::DBI.
This is my enviroment:
Suse Linux 6.3, Apache 1.3.12, mod_perl 1.24 and Oracle 8i. I am using
HTML:Mason as well, as a templating system. Everything works.
Apache::DBI is loaded via httpd.conf by Apache properly
On Thu, Feb 08, 2001 at 11:57:50PM +0100, Caroline Kliegl wrote:
[..]
With my other script, updating data, I get the following error :
Rebuild with -DPERL_STACKED_HANDLERS to $r-push_handlers at
/usr/local/lib/perl5/site_perl/5.6.0/Apache/DBI.pm line 93.
[..]
You need to compile mod_perl
Hi there,
On Thu, 8 Feb 2001, Caroline Kliegl wrote:
I am new to mod_perl and currently trying to make use of Apache::DBI.
I get the following error :
Rebuild with -DPERL_STACKED_HANDLERS to $r-push_handlers at
/usr/local/lib/perl5/site_perl/5.6.0/Apache/DBI.pm line 93.
I think
Apache::DBI will call push_handlers on to issue a rollback if AutoCommit=0
in your connect string...
but the problem may not be with you... looks like a bug (somewhere):
if(!$Rollback{$Idx} and $needCleanup and Apache-can('push_handlers'){
...
}
looks like calling Apache-can('push_handlers
8/01 7:52 PM
Subject: RE: Newbie question to mod_perl and Apache::DBI
Apache::DBI will call push_handlers on to issue a rollback if
AutoCommit=0
in your connect string...
but the problem may not be with you... looks like a bug (somewhere):
if(!$Rollback{$Idx} and $needCleanup and Apach
Hi everybody,
I have just removed
RaiseError = 1,
AutoCommit = 0
out of my DBI-connect. No more errors, ORA works!
Next, I will recompile mod_perl with PERL_STACKED_HANDLERS = 1.
Will come up with the result today.
Thanks
[EMAIL PROTECTED] wrote:
Does any body have an idea how to access MSsql server using DBI or
other method.
I've to build an application and I don't want to go to IIS so is
there any way to work with Apache+Modperl in gnu-Linux and querying
a NT box running MSsql.
http://www.xray.mpe.mpg.de
tabase via DBI. Using the above configuration information the
script does what its supposed to, and everything is right with the world.
But if I add in:
SetHandler perl-script
to the middle of the Directory directive above, the script blows up.
error_log says:
DBI-connect(::xx
We have a ground floor opening for a perl programmer for a
TELECOMMUTING situation for web/wireless/telecom system development.
Requirements:
Strong Perl 5 experience
SQL database knowledge
Experience:
CGI is a big plus
Unix/Linux is a plus
mod_perl apache servers are a plus
DBI database
A post office box in FL?
CargoTel, Inc.
PO Box 660572
Oviedo, FL 32766
Doesn't sound very professional...
"Greg Balfanz, CargoTel" wrote:
We have a ground floor opening for a perl programmer for a
TELECOMMUTING situation for web/wireless/telecom system development.
Thank you,
Greg
Hi Buddy,
On Tue, 30 Jan 2001, Buddy Lee Haystack wrote:
A post office box in FL?
CargoTel, Inc.
PO Box 660572
Oviedo, FL 32766
Doesn't sound very professional...
With $85M I guess he doesn't worry too much about that.
'Course if I had $85M I think I'd go on holiday for a while.
73,
I guess so, but I find it a bit difficult to imagine why someone successful enough to
sell 3 sites for a total of $85M uses a PO Box; pays to list the domain name for only
1 year; is located in an area that is 98% rural where the median housing value is
under $90,000; doesn't list an actual
Hi there!
Does any body have an idea how to access MSsql server using DBI or
other method.
I've to build an application and I don't want to go to IIS so is
there any way to work with Apache+Modperl in gnu-Linux and querying
a NT box running MSsql.
Thanks in advance
Regards
Jose Albert
[EMAIL PROTECTED] writes:
Hi there!
Does any body have an idea how to access MSsql server using DBI or
other method.
I've to build an application and I don't want to go to IIS so is
there any way to work with Apache+Modperl in gnu-Linux and querying
a NT box running MSsql.
One
I tend to write my apps in a modular fashion, so that each module
connects to the database and fetches its data and then disconnects.
Often, a program will require data from several modules resulting in a
lot of wasted connect/disconnect ops. Apache::DBI does solve this
issue, but I don't want
::DBI does solve this
issue, but I don't want nor need to keep lingering connections for a
lightly-used application. (The DB is not used for the majority of
hits to the site.)
I use a singleton for the database connection:
sub get_dbh {
my $dbh = Apache-request()-pnotes('dbh');
if (!$dbh
? Or is there something
else causing the child to stop running?
Scott
Hi,
Why do I see this in the log
13402 Apache::DBI need ping: yes
13402 Apache::DBI new connect to
'my_dbmy_usermy_passwdAutoCommit=1PrintError=1'
when I have in the startup.pl file
Apache::DBI
On Thu, 11 Jan 2001, R. K . Mallah wrote:
Stas , I do not face the problem anymore and Apache::DBI is loading
without any problem. But i remember of facing problem at one point of time.
may be with some older version.
Ok
Could u please explain me what does Apache-module do and where
Scott Alexander wrote:
Hi,
Why do I see this in the log
13402 Apache::DBI need ping: yes
13402 Apache::DBI new connect to
'my_dbmy_usermy_passwdAutoCommit=1PrintError=1'
when I have in the startup.pl file
Apache::DBI-connect_on_init
with some data,
manipulated and finally read out with a join. These
temporary tables are deleted automatically when the
database connection is closed. However if I move from
DBI to Apache::DBI, the connection won't be closed and
the temporary tables will stay.
So what is the best way to handle
-Original Message-
From: Joe Grastara [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 09, 2001 7:02 PM
To: [EMAIL PROTECTED]
Subject: Can't get DBI to work with mod_perl
I'm having trouble getting a script that uses the DBI module
to work under
mod_perl. It works fine
I faced the same problem and had posted similar email
but I found an workaround that is there in the posting.
I get following error when i do
perl -e 'use Apache::Status;use Apache::DBI'
Can't locate object method "module" via packa
Alexander Farber (EED) writes:
So what is the best way to handle it? I could add
drop table #temp1
drop table #temp2
to the SQL statements of my script, but what happens if
the user presses STOP or the script times out? Should I
move this SQL-code to $r-register_cleanup()?
HI,
I'm using a AuthAny handler to authenticate for every script. Today
for the first time the production server was put thru it's paces. I had
about 80 users at the same time. Checking the apache error log
there were a lot of
DBI-connect failed: Too many connections at
/systems/humakpro
few temporary
tables (#temp1, #temp2) which are filled with some data,
manipulated and finally read out with a join. These
temporary tables are deleted automatically when the
database connection is closed. However if I move from
DBI to Apache::DBI, the connection won't be closed
On Wed, 10 Jan 2001, R. K . Mallah wrote:
I faced the same problem and had posted similar email
but I found an workaround that is there in the posting.
I get following error when i do
perl -e 'use Apache::Status;use Apache::DBI
Foskett Roger wrote:
Hi, when using Apache::DBI, it keeps re-connecting even though the database
and user is the same:
I am using ApacheDBI-0.87, DBD-Oracle-1.06, DBI-1.14, perl5.6.0 on an 8.1.5
Oracle database (perl -v -V further below)
My httpd.conf is setup as:
PerlModule
On Wed, 10 Jan 2001, Scott Alexander wrote:
HI,
I'm using a AuthAny handler to authenticate for every script. Today
for the first time the production server was put thru it's paces. I had
about 80 users at the same time. Checking the apache error log
there were a lot of
DBI-connect
On Wed, 10 Jan 2001, Scott Alexander wrote:
It really peaked at 14:38:41 and then in the error_log
Ouch! malloc failed in malloc_block()
DBI-connect failed: Too many connections at
/systems/humakpro/lib/library.pm line 213
[Wed Jan 10 14:38:41 2001] [error] Can't call method "pr
Hi, when using Apache::DBI, it keeps re-connecting even though the database
and user is the same:
I am using ApacheDBI-0.87, DBD-Oracle-1.06, DBI-1.14, perl5.6.0 on an 8.1.5
Oracle database (perl -v -V further below)
My httpd.conf is setup as:
PerlModule Apache::DBI Apache Apache
Stas , I do not face the problem anymore and Apache::DBI is loading
without any problem. But i remember of facing problem at one point
of time.
may be with some older version.
Could u please explain me what does Apache->module do and where
is
it defined ?
and Edmar could you please p
Hi,
Why do I see this in the log
13402 Apache::DBI need ping: yes
13402 Apache::DBI new connect to
'my_dbmy_usermy_passwdAutoCommit=1PrintError=1'
when I have in the startup.pl file
Apache::DBI-connect_on_init
("DBI:mysql:my_db",
Hi,
I use apache1.3.12 with mod_perl 1.24 and I've been using it in several
programs with DBI (version 1.13). This is the first time I get an error
like this, other programs that uses DBI are still working.
In command line everything is working ok, but when I run my
I'm having trouble getting a script that uses the DBI module to work under
mod_perl. It works fine at the command line or as a normal cgi script.
I've included the code below. When I try to run from the browser under
mod_perl the only only output is the first portion of HTML. I've tried
"BLH" == Buddy Lee Haystack [EMAIL PROTECTED] writes:
BLH There are two components to DBI. The perl module is required for
BLH database access, but the Apache DBI module is not. Although you
BLH really should use the Apache DBI module to maintain persistent
BLH connections to you
Bad generic advice. You should use persistent connections when it
makes sense to use them.
BLH Whether or not you use mod_perl is irrelevant.
It is relevent if you want to use Apache::DBI.
Ouch!
I was a bit more specific in my follow-up email which I sent direct since I didn't
think
I have a question concerning database access under mod_perl.
Can the stardard DBI.pm module be use with mod_perl or does the
Apache::DBI module have to be used instead?
Thanks in advance for any help.
Joe Grastara
Project Assistant
Digital Media Center
The Skirball Institute Of Biomolecular
the cause of the problem. Initially I
blamed Apache::DBI and therefore I disabled it, adding $dbh-disconnect
statements to my code. However this has not solved the problem.
My server runs the following software:
FreeBSD 4.0 or FreeBSD 4.2 stable
Apache 1.3
ModPerl
Apache::DBI (disabling this doesn't
table has filled up.
As of today I have no idea about the cause of the problem. Initially I
blamed Apache::DBI and therefore I disabled it, adding $dbh-disconnect
statements to my code. However this has not solved the problem.
My server runs the following software:
FreeBSD 4.0 or FreeBSD
t (where x is some large number, I use 4096) makes this
easy and unforgettable.
Does the file descriptor problem occur when you run as a regular CGI?
FSAs of today I have no idea about the cause of the problem. Initially I
FSblamed Apache::DBI and therefore I disabled it, adding $dbh-
Greetings,
I'm getting grief while trying to run DBI/DBD::mysql (running through Apache::ASP if
that matters). Pages which work fine on another development server spew the following
when run on the new install:
DBD::mysql object version 2.0415 does not match bootstrp
parameter 2.0413
On Wed, 27 Dec 2000, Andrew Koebrick wrote:
Greetings,
I'm getting grief while trying to run DBI/DBD::mysql (running through Apache::ASP if
that matters). Pages which work fine on another development server spew the
following when run on the new install:
DBD::mysql object version
while trying to run DBI/DBD::mysql (running through Apache::ASP if
that matters). Pages which work fine on another development server spew the
following when run on the new install:
DBD::mysql object version 2.0415 does not match bootstrp
parameter 2.0413 at /usr/lib/perl5/5.6.0/i386
On Wed, 27 Dec 2000, Andrew Koebrick wrote:
Stas [et al.],
I wiped all of the prior DBD files and reinstalled as per advice:
It's possible that you have DBD files duplicated in different directories
and the older version is coming first in @INC. Remove them all and
reinstall.
For
hi all...
I was wondering if anyone has found a good way around persistent connections
and package recompiles. With Apache::DBI, on occasion when someone
recompiles a package and doesn't tell me, I see
ORA-04061: existing state of package body "FOO.BAR" has been invalidated
.
However, this leaves the current request in a lurch...
I was thinking that maybe something like Apache::DBI::reconnect() was
needed
- call DBI-disconnect then DBI-connect again.
If you change the ping() method to check whether or not your package still
works, Apache::DBI will automatically get
-Original Message-
From: jared still [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 22, 2000 11:52 AM
To: Geoffrey Young
Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: Re: Apache::DBI and altered packages
Geoff,
I'm going to make a non-technical suggestion
-Original Message-
From: Perrin Harkins [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 22, 2000 11:55 AM
To: Geoffrey Young; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Apache::DBI and altered packages
If you change the ping() method to check whether or not your
of a management and logistics problem than a Perl
or Apache or Oracle problem
On Fri, 22 Dec 2000, Geoffrey Young wrote:
I was wondering if anyone has found a good way around persistent connections
and package recompiles. With Apache::DBI, on occasion when someone
recompiles a package and doesn't
I get following error when i do
perl -e 'use Apache::Status;use Apache::DBI'
Can't locate object method "module" via package "Apache" at /usr/lib/perl5/site_perl/5.6.0/Apache/DBI.pm
line 202.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e
I was in the process of updating the Apache::DBI section of the guide with
the notes from the latest version of this package, and there is a new
section about Transactions. Since I use mysql, it doesn't have
transactions so I cannot it's not absolutely clear to me. For example why
the script
Stas Bekman writes:
I was in the process of updating the Apache::DBI section of the guide with
the notes from the latest version of this package, and there is a new
section about Transactions. Since I use mysql, it doesn't have
transactions so I cannot it's not absolutely clear to me
ests,
just to be safe :)
--Chris
On Thu, 14 Dec 2000, Stas Bekman wrote:
I was in the process of updating the Apache::DBI section of the guide with
the notes from the latest version of this package, and there is a new
section about Transactions. Since I use mysql, it doesn't have
transactions s
es without an explicit rollback,
Stas the CApache::DBI module uses a CPerlCleanupHandler to
Stas issue a rollback at the end of every request.
I believe this paragraph spells it out, to my satisfaction anyway. If a
script exits without committing (or rolling back) a transaction that is
On Thursday, December 14, 2000, Stas Bekman wrote the
following about "Apache::DBI and transactions"
SB In general it is good practice to perform an explicit commit or
SB rollback at the end of every script.
True, but this is truly a style issue. IMHO, relying on something to comm
ck at both the beginning and the end of all requests,
just to be safe :)
Ok, thanks everybody, I've got. You do rollback just to be sure that you
don't leave things open... That's an interesting technique.
On Thu, 14 Dec 2000, Bruce W. Hoylman wrote:
Interesting behavior ... I did not know Apach
Bas,
thanks for your comments. They are a first step to solve the problem.
[DBI script problem skipped]
The error_log from Apache shows some problems, which
*could* be related to
mod_perl
[Tue Dec 5 09:42:31 2000] [crit] (13)Permission denied:
make_sock: could
not bi
nd
The server restarts clean now:
good
Second, you should make your code more debug friendly. Replace:
$dbh = DBI-connect('dbi:mysql:vip;host=', '###', '###');
with
$dbh = DBI-connect('dbi:mysql:vip;host=', '###', '###')
or die $DBI::errstr;
what error do you get?
I
I installed the latest version of mod_perl (1.24), linked it statically to
apache 1.3.12. (use perl 5.6). I simply want to access a MySQL database
via the DBI package (v 1.14). I installed ApacheDBI 0.87
I wrote a simple script to access a mysql database. This script works fine,
both from
[DBI script problem skipped]
The error_log from Apache shows some problems, which *could* be related to
mod_perl
[Fri Dec 1 18:47:08 2000] [crit] (13)Permission denied: make_sock: could
not bi
nd to port 80
[Fri Dec 1 18:56:06 2000] [crit] (13)Permission denied: make_sock: could
Hi,
I've been working with HTML::Mason and have been unable to connect
to mysql with DBI. There is a problem with the configuration on my
machine
such that perl won't check
/usr/local/lib/perl5/site_perl/5.6.0/i586-linux/ for
modules unless it's explicitly asked to. I don't really know why
Edmar Edilton da Silva wrote:
I still didn't solve the problem of the Apache::DBI. It can not be
loaded into the apache's startup.pl file because happens a error during
the starting of the apache, the child processes are not created. For
using the Apache::DBI I had to add the "use A
Hi folks,
I am not sure if my perl scripts are running under Apache::DBI.
How can I check if they are using database connections which was already
openned. Is there any command that I can add to the perl script for it
tell me if was opens a new connection
On Sat, 2 Dec 2000, Edmar Edilton da Silva wrote:
Hi folks,
I am not sure if my perl scripts are running under Apache::DBI.
How can I check if they are using database connections which was already
openned. Is there any command that I can add to the perl script
to get back to
regular DBI and DBD::Oracle (and Oracle::OCI) work early next year.
Meanwhile, I'll happily guide someone who's willing and mostly able to
create a patch for DBI internals. It's shouldn't be too hard.
Tim
for the better workwise now and I hope to get back to
regular DBI and DBD::Oracle (and Oracle::OCI) work early next year.
You said that at TPC :-)
--
Matt/
/||** Director and CTO **
//||** AxKit.com Ltd ** ** XML Application Serving **
// ||** http://axkit.org
to Tim to decide when if ever
this should go in :)
Things are changing for the better workwise now and I hope to get back to
regular DBI and DBD::Oracle (and Oracle::OCI) work early next year.
You said that at TPC :-)
Yeah, well... there are plans and there are plans :)
I recently gave
hacking, but that's up to Tim to decide when if ever
this should go in :)
Things are changing for the better workwise now and I hope to get back to
regular DBI and DBD::Oracle (and Oracle::OCI) work early next year.
You said that at TPC :-)
Yeah, well... there are plans
On Fri, Dec 01, 2000 at 12:23:26PM +, Greg Cope wrote:
Tim Bunce wrote:
Although a bit OT, but I am sure everyone is interested, what changes
are you planning for DBI ?
There's a ToDo file in the dist. I've probably a few others rattling
around in my head.
Tim
An:mod_perl list [EMAIL PROTECTED]
Betreff: RFC: DBI::Prof
Nachrichtentext:
I have a huge project with lots of tables, and the performance wasn't that
well. So I've started to review the tables definitions and have found that
some indices were missing. I was sick from doing the tracing of all
any of us
doing the overloading hacking, but that's up to Tim to decide when if ever
this should go in :)
Michael Jacob
Datum: 28.11.2000 21:12
An:mod_perl list [EMAIL PROTECTED]
Betreff: RFC: DBI::Prof
Nachrichtentext:
I have a huge project with lots
JAm_pH -- Just Another mod_perl Hacker
http://stason.org/ mod_perl Guide http://perl.apache.org/guide
mailto:[EMAIL PROTECTED] http://apachetoday.com http://jazzvalley.com
http://singlesheaven.com http://perl.apache.org http://perlmonth.com/
package DBI::Prof;
use Apache
On Tue, 28 Nov 2000, Stas Bekman wrote:
I have a huge project with lots of tables, and the performance wasn't that
well. So I've started to review the tables definitions and have found that
some indices were missing. I was sick from doing the tracing of all
possible SQL calls manually, so I
On Tue, 28 Nov 2000, Stas wrote:
possible SQL calls manually, so I wrote this simple profiler. Take a look
and tell me if you think it worths releasing on CPAN...
Definitely release it! It is a very elegant solution to a problem that I'm
guessing many of us have dealt with. I've always
, so I wrote this simple profiler. Take a look
and tell me if you think it worths releasing on CPAN...
Try DBIx::Profile. I've had great success with it.
Ouch, I was checking the wrong namespace DBI:: and that's why I've missed
it. Why DBIx?
Looks like it does pretty much the same but returns
On Tue, 28 Nov 2000, Stas Bekman wrote:
Or is there any reason for not using DBI::?
Tim mandates it. DBI:: is reserved for DBI only. DBD::* is reserved for
DBD drivers only, anything else goes in DBIx.
--
Matt/
/||** Director and CTO **
//||** AxKit.com Ltd ** ** XML
Hi Folks,
Everything is working great but I can't make a connection to my Oracle database (which
is on another server) using mod_perl.
-Perl 5.005_03 is working great.
-mod_perl 1.24_01 is working great with apache 1.3.14
-DBI 1.14 connections are working great with DBD Oracle 1.06
I can
It would be nice if Tim Bunce simply added it as a parameter
to DBI's existing methods. Why not ask him?
Fabrice
Aaron Ross wrote:
On Tue, 28 Nov 2000, Stas wrote:
possible SQL calls manually, so I wrote this simple profiler. Take a look
and tell me if you think it worths releasing on
On Wed, 29 Nov 2000, Fabrice Scemama wrote:
It would be nice if Tim Bunce simply added it as a parameter
to DBI's existing methods. Why not ask him?
I think most people would prefer to see it as a separate module. Generally
people do their query optimisations outside of DBI (and Perl), using
data and then sift through it in perl.
You could probably modify DBIx::Profile to support a flag for turning this
off.
The only problem with DBIx::Profile is that you have to turn Apache::DBI
off, since DBIx::Profile overrides disconnect() as well.
I didn't turn Apache::DBI off and things still
their query optimisations outside of DBI (and Perl), using the
database's in-built profilers.
This one is not about optimizing the database, but finding the missing
indices mostly and seeing which queries might need to be rewritten to make
a better use of the driver/db. I don't know how can you do
From: Perrin Harkins [mailto:[EMAIL PROTECTED]]
On Tue, 28 Nov 2000, Stas Bekman wrote:
And fetch()es are quite irrelevant for performance
improvements since they
never change unless you compare TCP/IP vs UNIX sockets or one driver
against the other.
I find the fetch information
00 5:40 AM
To: [EMAIL PROTECTED]
Subject: Problem with Apache::DBI under mod_perl!!
Hi all,
I have installed on the my machine the following modules:
apache 1.3.12-2
perl-5.00503-10
mod_perl 1.21-10
DBI 1.14
Apache::DBI 0.87
For enable the mod_perl module, I added the
Hi all,
I am sending again the previous message because I still didn't know how
to resolve the below problem. Can anyone any idea how help me?
I have installed on the my machine the following modules:
apache 1.3.12-2
perl-5.00503-10
mod_perl 1.21-10
DBI 1.14
DBD::Oracle
Apache
mod_perl 1.21-10
DBI 1.14
DBD::Oracle
Apache::DBI 0.87
Oracle Client Software
For enable the mod_perl module, I added the below code in the
configuration file of apache ("httpd.conf"):
# If the perl module is installed, this will be enabled.
IfModule mod_perl.c
PerlFr
Hi all,
I have installed on the my machine the following modules:
apache 1.3.12-2
perl-5.00503-10
mod_perl 1.21-10
DBI 1.14
Apache::DBI 0.87
For enable the mod_perl module, I added the below code in the
configuration file of apache ("httpd.conf"):
# If the perl module is
Hello
Don't you need a DBD module?
Or did I miss something?
Ruben
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Sorry, but I forgot, I also have installed a DBD module for the
Oracle ( the "DBD::Oracle" ). Do you have any idea to resolve this
problem?
Thanks,
Sapphire Software wrote:
Hello
Don't you need a DBD module?
Or did I miss something?
Ruben
#!/usr/bin/perl
use strict;
# Extend @INC if needed
use lib qw(/dir/foo /dir/bar);
# ok, setup the Oracle and (optionally) the debug DBI environment
BEGIN {
$ENV{'ORACLE_HOME'}='/highway/to/orac/hell';
$ENV{DBI_TRACE}="3=/var/tmp/dbitrace.log";
}
# Make sure we are
401 - 500 of 856 matches
Mail list logo
