I should have mentioned that I'm using it with DBD::Oracle against an
11.2 database.
On Wed, Nov 4, 2009 at 3:58 PM, E R wrote:
> Hi,
>
> I am seeing segfaults when accessing $DBI::err and using the following:
>
> - DBI version 1.51
> - DBI::ProfileDump::Apache
> - mod-perl 1.3.41
> - perl 5.8.9
Hi,
I am seeing segfaults when accessing $DBI::err and using the following:
- DBI version 1.51
- DBI::ProfileDump::Apache
- mod-perl 1.3.41
- perl 5.8.9
Is this a known issue?
It's in a rather large mod-perl app, but I'll see if I can create a
small test case.
Merely accessing $DBI::err causes
7;t locate object method "selectcol_arrayref_i" via package "Apache::DBI::db"
The method name is not the issue, it's the name space being searched. This
method
is part of DBIx::Interp.
Maybe there is an easy bug in the new() or connect() methods of DBIx::Interp,
so I'
I sometimes get:
DBD driver has not implemented the AutoCommit attribute at
/usr/local/lib/perl5/site_perl/5.8.8/Apache/DBI.pm line 277.
On my HTML::Mason site. I'm using Apache 2.2/mod_perl 2.
I list
PerlModule Apache::DBI
before any other perl modules.
I connect with AutoCommit
On Mon, Jan 16, 2006 at 12:42:10PM -0800, Tyler MacDonald wrote:
> Jeremy Nixon <[EMAIL PROTECTED]> wrote:
> > It looks like it would work perfectly with connect_cached, which I hadn't
> > known about, but now that I do, I'm all excited to change my code to us
Jeremy Nixon <[EMAIL PROTECTED]> wrote:
> It looks like it would work perfectly with connect_cached, which I hadn't
> known about, but now that I do, I'm all excited to change my code to use
> it instead of Apache::DBI.
*instead*, eh... I'm using it as wel
> Here's the thing: if your database connection goes away, and Apache::DBI
> opens a new one, any prepared statement handles you might have become
> invalid, because prepared statements are per-connection.
>
> My way around it is to not use prepared statements.
Another, be
Tyler MacDonald <[EMAIL PROTECTED]> wrote:
> [Fri Jan 13 23:46:28 2006] [error] [client 192.168.99.112] DBD::Pg::db
> prepare_cached failed: FATAL: terminating connection due to administrator
Here's the thing: if your database connection goes away, and Apache::DBI
opens a new
Apache::DBI claims that it will reconnect to a database if it's gone away.
DBD::Pg claims that it supports the ping method. However, when I restart my
database server while apache2 is running, all mod_perl pages that are
database driven return internal server errors, no matter how many ti
Has anyone got any experience with Apache::DBI::Cache that they might
like to share?
Tim.
http://search.cpan.org/~opi/Apache-DBI-Cache/
n they happen in the critical part
of the booking process, it caused bad things to happen.
I suspected this could be because Apache::DBI connect to the server when
apache is started, but I read somewhere that it connects on 'init' stage.
So, how do I debug it? I have no idea of how
Paul Harrison wrote:
p5-DBD-mysql50-3.0002
p5-DBI-1.48
p5-Apache-DBI-0.94_1
[Tue Nov 8 10:41:04 2005] DBI.pm: Use of uninitialized value in numeric eq
(==) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 211.
[Tue Nov 8 10:41:04 2005] startup.perl: Use of uninitialized value in
p5-DBD-mysql50-3.0002
p5-DBI-1.48
p5-Apache-DBI-0.94_1
I upgraded the database server from the "4" version to "5", so I updated the
Perl database Drivers -> DBD,DBI, and Apache-DBI.
Once I updated the software, I get the following text in the Apache error
log -->
Ted Behling wrote:
Could somebody verify that this is a sane and future-proof approach?
I can't speak about the future of DBI, but your reading of the current source
code is correct.
--
END
What doesn't kill us can only make us
On Fri, Oct 21, 2005 at 12:57:19PM -0400, Ted Behling wrote:
> I have multiple mod_perl applications running within one Apache instance.
> For most of these applications, I want to use Apache::DBI, but I want to
> disable it for just one. According to various Web pages, this is not
&
I have multiple mod_perl applications running within one Apache instance. For
most of these applications, I want to use Apache::DBI, but I want to disable it
for just one. According to various Web pages, this is not possible, because
Apache::DBI attaches itself to all DBI->connect() calls.
:
>
> Perl 5.8.0
> DBI 1.46
> DBD::ODBC 1.13
> Apache::DBI 0.94
>
> The RDBMS is Mimer 8.2.5G (www.mimer.com), connecting via unixODBC 2.2.0.
>
> I get an unexpected transaction commit in the following example script:
>
> $dbh = DBI->connect('dbi:ODBC:myd
I have been experiencing some problems with the following configuration:
Solaris 5.7 on a Sun Ultra-250, running Apache 2.0.48, mod_perl 1.9913
(built as DSO)
I'm using the following perl modules:
Perl 5.8.0
DBI 1.46
DBD::ODBC 1.13
Apache::DBI 0.94
The RDBMS is Mimer 8.2.5G (www.mime
> From: angie ahl <[EMAIL PROTECTED]>
> Date: 2005/01/07 Fri PM 01:45:59 CST
> Is PerlSetVar the best way to pass values from httpd.conf to perl securely?
> Do I need to open/close the connection in each of the modules too or
> can I pass the $dbh object to each of my external subroutines, or is
>
Hi DBI using people
can anyone tell me whether the following will work. I've got myself
all confused over persistency (of every kind).
I'm using Mod_perl and apache (1.3)
I have a httpd.conf containing PerlSetVar for the DB's datasource,
username and password.
I get these values in my perl module
ricardo Guerra Flores wrote:
Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in start
Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in startup.pl
This is the
On Sep 13, 2004, at 8:30 AM, Martin Moss wrote:
All,
I'm trying to understand the Apache::DBI mechanism
which caches and returns $dbh handles. My concern is
that Apache DBI uses the connection options, like
AutoCommit=>1 as part of it's caching 'key' mechanism.
Yes it does,
All,
I'm trying to understand the Apache::DBI mechanism
which caches and returns $dbh handles. My concern is
that Apache DBI uses the connection options, like
AutoCommit=>1 as part of it's caching 'key' mechanism.
Thus would I be right in thinking that if I create a
$dbh w
On Sep 8, 2004, at 3:04 AM, Bart Lateur wrote:
Is there anything foreseen to disconnect a DBI connection, in a
mod_perl
(2) setup with Apache::DBI, in case nothing has been requested in
several minutes time? Do the connections stay open forever, or does the
database timeout all by itself? (I
On Wed, 2004-09-08 at 12:04, Bart Lateur wrote:
> Is there anything foreseen to disconnect a DBI connection, in a mod_perl
> (2) setup with Apache::DBI, in case nothing has been requested in
> several minutes time? Do the connections stay open forever, or does the
> database timeout a
Is there anything foreseen to disconnect a DBI connection, in a mod_perl
(2) setup with Apache::DBI, in case nothing has been requested in
several minutes time? Do the connections stay open forever, or does the
database timeout all by itself? (I suspect it does, anyway)
The only thing I see in
On Wed, Jun 16, 2004 at 12:00:32PM -0700, Kevin Moore wrote:
> Does anyone have a step by step procedure for configuring apache,
> mod_perl, and DBI for accessing an oracle database they'd be willing to
> share?
First make sure you can run any script (Perl or otherwise) from the
location you are
owser.
This is not a DBI issue per se, so if you'd like to continue off-line, feel free to
contact me directly.
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 12:08 PM
To: Kevin Moore; [EMAIL PROTECTED]
Subject: RE: Apache, DBI, Oracle
01 PM
To: [EMAIL PROTECTED]
Subject: Apache, DBI, Oracle
Experts,
Does anyone have a step by step procedure for configuring apache,
mod_perl, and DBI for accessing an oracle database they'd be willing to
share?
I've got Oracle and a simple perl script using dbi to extract data f
Experts,
Does anyone have a step by step procedure for configuring apache,
mod_perl, and DBI for accessing an oracle database they'd be willing to
share?
I've got Oracle and a simple perl script using dbi to extract data from
a database running from the command line but am receiving "server Err
On 20 May 2004, Keith Jackson wrote:
> Why is there another connection each time I reload the page? Any help
> would be appreciated.
Because you have more than 1 apache process. Each httpd process can cache a
connexion handle to each of the databases that it uses.
So if you have Max Clients set
I have a development server that I am the only one using it at the
moment. I've installed mod_perl (not 2.0) and Apache::DBI.
Using MySQL, I do a show processlist and there are no processes.
I hit a page that requests data from MySQL.
Processlist shows one process.
I reload that same pag
[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Oracle / Apache::DBI connection problems
This is a forward since the original message bounced. Figured it
would, the address was 5 years old. :^)
- Forwarded message from "Hartog C. de Mik" <[EMAIL PROTECTED]> -
From: &
I'm running a web application under Apache2/mod_perl2 using PostgreSQL
as a backend and DBI/Apache::DBI to connect to it. I'm still in
development of the system, so I have a couple of pages with invalid SQL
on them. The problem is that, once I go to one of these pages with
invalid
I'm trying to update my Perl installation. It says a new Apache::DBI is out; 0.92.
I've tried changing LANG from 'en_US.UTF-8' to 'en_US' and also just 'C' as I've seen
that help before.
I ran t/10mysql.t manually and it says it's faili
Can you put commit/rollback's into the END block ?
-Original Message-
From: Steve Baldwin [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 27, 2003 8:02 PM
To: [EMAIL PROTECTED]
Subject: Question regarding Apache::DBI
We're using Apache::DBI and running into problems with Ap
We're using Apache::DBI and running into problems with Apache child
processes not releasing locks. My current theory for how this happens
goes something like this ...
(Our DB is Oracle if that's relevant)
script issues an update which is successful, and locks the updated row
does o
I have encountered an installation problem with the Apache::DBI module
(version 0.91) from CPAN. I am running Linux Mandrake 9.1 with Perl
5.8.0 and CPAN version 1.70
cpan> install Apache::DBI
Running install for module Apache::DBI
Running make for A/AB/ABH/Apache-DBI-0.91.tar.gz
CPAN: Dig
This help request was originally sent to the Perl5-porters list, which
has directed me here.
Michael G Schwern wrote:
>On Sat, Jun 07, 2003 at 11:37:16PM -0400, Albert E. Whale, CISSP wrote:
>
>
>>I am installing the Apache-DBI-0.91 on a Linux Mandrake 9.1 server wi
On Mon, Jan 13, 2003 at 02:08:12PM -0500, Bob Showalter wrote:
> I'm using Apache::DBI under mod_perl to manage connections to a remote
> database using DBD::Proxy. My problem is that Apache::DBI is not properly
> issuing a rollback to DBD::Proxy handles in the PerlCleanupHan
I'm using Apache::DBI under mod_perl to manage connections to a remote
database using DBD::Proxy. My problem is that Apache::DBI is not properly
issuing a rollback to DBD::Proxy handles in the PerlCleanupHandler.
The relevant section from Apache/DBI.pm is (in sub cleanup):
if ($Rollback
I recently started using CGI::Fast along with caching
DBI connections to speed up DBI-based web pages. I
choose CGI::Fast over mod_perl it does not tie me to
any one webservers (although I do love my Apache!).
For persistent servers/DBI connections, is there any
reasons why someone would choos
On Fri, Aug 16, 2002 at 04:07:52PM -0700, Michael G Schwern wrote:
> On Tue, Aug 13, 2002 at 10:22:35PM +0100, Tim Bunce wrote:
> > > > But how about a new method:
> > > >
> > > > DBI->connect_method("connect");
> > > > DBI-
On Tue, Aug 13, 2002 at 10:22:35PM +0100, Tim Bunce wrote:
> > > But how about a new method:
> > >
> > > DBI->connect_method("connect");
> > > DBI->connect_method("Apache::DBI::connect"); # effectively what "use
> > But how about a new method:
> >
> > DBI->connect_method("connect");
> > DBI->connect_method("Apache::DBI::connect"); # effectively what "use
>Apache::DBI;" does now
> > DBI->connect_method("connect_cached&quo
On Mon, Aug 12, 2002 at 07:56:57AM +0100, Tim Bunce wrote:
> They (slightly) have different semantics so I'd be reluctant to
> transparently substitute one for another.
Fair nuff.
> But how about a new method:
>
> DBI->connect_method("connect");
> DBI-&
On Fri, Aug 09, 2002 at 01:47:55AM -0700, Michael G Schwern wrote:
> An Ima::DBI user recently pointed out that DBI->connect_cached is not using
> Apache::DBI like DBI->connect does and DBI->connect_cached has slightly
> different semantics from Apache::DBI.
>
>
An Ima::DBI user recently pointed out that DBI->connect_cached is not using
Apache::DBI like DBI->connect does and DBI->connect_cached has slightly
different semantics from Apache::DBI.
sub connect_cached {
# XXX we expect Apache::DBI users to still call connect()
m
On Tue, 18 Jun 2002, Tim Harsch wrote:
> Date: Tue, 18 Jun 2002 15:38:49 -0700
> From: Tim Harsch <[EMAIL PROTECTED]>
> To: "'William R. Mussatto'" <[EMAIL PROTECTED]>,
> "'Kotha, Nagaraju'" <[EMAIL PROTECTED]>
> Cc:
Looking at the docs it looks as if Apache::DBI is intended for mod_perl.
Nagaraju said:
>Does any one have experience with Apache::DBI with Perl (not mod_perl)?
Looks like maybe he is barking up the wrong tree then, or will it work
without mod_perl?
> -Original Message-
>
> | > I may be missing something, but with normal cgi, the program
> | > goes away
> | > when its done so the connection will go away as well. What
> | > would hold
> | > your persistent connection?
Apache holds the connection! That's the point of Apache
e CGI )...
However it like we are just trying to reinvent Fast::CGI ... I was
hoping someone with experience with a server that has Apache::DBI,
Fast::CGI and/or mod_perl might chime in and help explain the 3 a bit...
> -Original Message-
> From: Brian McCain [mailto:[EMAIL PROTECTE
gt;; "'Kotha, Nagaraju'"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 18, 2002 3:38 PM
Subject: RE: Apache::DBI question
| Yeah but what about if you combine it with Fast::CGI (which I've never
| done). But in theory wouldn't the CGI stay
--Original Message-
> From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 18, 2002 11:17 AM
> To: Kotha, Nagaraju
> Cc: [EMAIL PROTECTED]
> Subject: Re: Apache::DBI question
>
>
> I may be missing something, but with normal cgi, the program
> goes aw
lt;[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Apache::DBI question
>
> Hi,
>
> Does any one have experience with Apache::DBI with Perl (not mod_perl)?
>
> How good these are with persistence connections?
> Is there any issues for the large web sites?
>
>>>>> On Tue, 21 May 2002 12:56:03 -0500, Philip Molter <[EMAIL PROTECTED]> said:
PM> On Tue, May 21, 2002 at 01:43:40PM -0400, [EMAIL PROTECTED] wrote:
PM> :
PM> : My guess would be:
PM> :
PM> : use DBI;
PM> : use Apache DBI;
PM> :
PM> : my $per
On Tue, May 21, 2002 at 01:43:40PM -0400, [EMAIL PROTECTED] wrote:
:
: My guess would be:
:
: use DBI;
: use Apache DBI;
:
: my $persistant_dbh = Apache::DBI->connect(blah, blah, blah);
: my $non_persistant_dbh = DBI->connect(blah, blah, blah);
:
: But that's untested and offe
My guess would be:
use DBI;
use Apache DBI;
my $persistant_dbh = Apache::DBI->connect(blah, blah, blah);
my $non_persistant_dbh = DBI->connect(blah, blah, blah);
But that's untested and offered with no warranty whatsoever that it will
work.
jeff
***
I have a web application that for various reasons needs some database
connections to be persistent and some not to be. As far as I can
tell, if I use Apache::DBI, then everything is going to be persistent
under Apache::DBI. Is there a way to selectively disable the
connection caching with
On Friday, May 3, 2002, at 02:37 , Dave Mitchell wrote:
> On Thu, May 02, 2002 at 12:30:37PM -0400, Michael G Schwern wrote:
>> On Thu, May 02, 2002 at 05:08:49PM +0100, Tim Bunce wrote:
>>> That's a pity because local($h->{foo}) is very useful for DBI
>>> programs.
>>>
>>> Is anyone working on
On Thu, May 02, 2002 at 12:30:37PM -0400, Michael G Schwern wrote:
> On Thu, May 02, 2002 at 05:08:49PM +0100, Tim Bunce wrote:
> > That's a pity because local($h->{foo}) is very useful for DBI programs.
> >
> > Is anyone working on it?
>
> Dunno. My last perlbug of it got no response, and I
For what it's worth, I have a similar problem with a minimal Oracle client (no
ORACLE_HOME):
bind_param a NUMBER doesn't work with PL/SQL.
>From: Roland Lammel [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, May 02, 2002 9:02 AM
>Subject: Re: Apache::DBI and $dbh attributes
>
On Thu, May 02, 2002 at 05:08:49PM +0100, Tim Bunce wrote:
> On Thu, May 02, 2002 at 10:29:11AM -0400, Michael G Schwern wrote:
> > On Thu, May 02, 2002 at 02:37:36PM +0100, Tim Bunce wrote:
> > > > Is it a perl tie mechanism's problem or DBI's?
> > >
> > > Perl's.
> > >
> > > > what about 5.8.0
On Thu, May 02, 2002 at 10:29:11AM -0400, Michael G Schwern wrote:
> On Thu, May 02, 2002 at 02:37:36PM +0100, Tim Bunce wrote:
> > > Is it a perl tie mechanism's problem or DBI's?
> >
> > Perl's.
> >
> > > what about 5.8.0-tobe? Do you know of a version that doesn't leak?
> >
> > Not off-hand.
On Thu, May 02, 2002 at 05:08:49PM +0100, Tim Bunce wrote:
> That's a pity because local($h->{foo}) is very useful for DBI programs.
>
> Is anyone working on it?
Dunno. My last perlbug of it got no response, and I wouldn't even
begin to know where to start looking for the problem.
http://www.
On Thu, May 02, 2002 at 10:29:11AM -0400, Michael G Schwern wrote:
> On Thu, May 02, 2002 at 02:37:36PM +0100, Tim Bunce wrote:
> > > Is it a perl tie mechanism's problem or DBI's?
> >
> > Perl's.
> >
> > > what about 5.8.0-tobe? Do you know of a version that doesn't leak?
> >
> > Not off-hand.
On Thu, May 02, 2002 at 02:37:36PM +0100, Tim Bunce wrote:
> > Is it a perl tie mechanism's problem or DBI's?
>
> Perl's.
>
> > what about 5.8.0-tobe? Do you know of a version that doesn't leak?
>
> Not off-hand. Hopefully the latest doesn't. CC'd to perl5-porters
> as I'm sure someone there wi
Tim Bunce wrote:
> On Thu, May 02, 2002 at 07:03:06PM +0800, Stas Bekman wrote:
>
Is it possible to simply localize the hash elements? Will this work
properly?
{
my $dbh = DBI->connect(@connect) || die $DBI::errstr;
print "LongReadLen is: ", $dbh->{Long
On Thu, May 02, 2002 at 07:03:06PM +0800, Stas Bekman wrote:
> >>
> >>Is it possible to simply localize the hash elements? Will this work
> >>properly?
> >>
> >> {
> >> my $dbh = DBI->connect(@connect) || die $DBI::errstr;
> >>
> >> print "LongReadLen is: ", $dbh->{LongReadLen}, "\n"
Hi Tim,
I posted a workaround for a specific Oracle (hence DBD::Oracle) problem
to the list some weeks
ago which involved setting env-var NLS_LANG to be able to save long's
with more than 4k (or was it 8k?),
and now found some kind of pitfall this caused.
When using bind_param with NLS_LANG se
ified in the connect() call (including stuff like
>LongReadLen) if
>>>>>>dbi_connect_method = 'Apache'. that seems like the right thing, since with
>Apache::DBI
>>>>>>wat we want a "new" $dbh, just without the connect over
(including stuff like
>LongReadLen) if
> >>>>dbi_connect_method = 'Apache'. that seems like the right thing, since with
>Apache::DBI
> >>>>wat we want a "new" $dbh, just without the connect overhead. and DBI seems like
>a
> >>>>reaso
On Thu, 02 May 2002 16:56:02 +0800, Stas Bekman wrote:
>Is it possible to simply localize the hash elements? Will this work
>properly?
> local $dbh->{LongReadLen} = 40;
As Tim wrote a few months (?) ago: it will "work", but since a DBI
object is a tied hash, you'll get memory leaks.
--
that seems like the right thing, since with
>Apache::DBI
>>>>wat we want a "new" $dbh, just without the connect overhead. and DBI seems like a
>>>>reasonable place to do it, especially since DBI->connect is kinda
>action-at-a-distance
>>>>
> Have fun!
If you're going to do some heavy overhauling of Apache::DBI please
consider whether it will allow us to more easily plugin DBD specific
reauthenticate functions.
http://mathforum.org/epigone/modperl/khimfoplax/001101c004f0$937a1e90$c2cf180c@azathoth
Thanks,
John
[EMAIL PROTECTED]
been a long time :)
> >>
> >>Stas and I just ran across something interesting concerning Apache::DBI and $dbh
> >>attributes. I think it involves a both a bug and a place for enhancements.
> >>
> >>we all know how Apache::DBI works - it stashes away $
[ CC'ing Edmund on this thread in case he is not on the dbi-users list]
Tim Bunce wrote:
> On Tue, Apr 30, 2002 at 03:34:26PM -0400, Geoffrey Young wrote:
>
>>hi Tim and all - it's been a long time :)
>>
>>Stas and I just ran across something interesti
On Tue, Apr 30, 2002 at 03:34:26PM -0400, Geoffrey Young wrote:
> hi Tim and all - it's been a long time :)
>
> Stas and I just ran across something interesting concerning Apache::DBI and $dbh
> attributes. I think it involves a both a bug and a place for enhancements.
>
hi Tim and all - it's been a long time :)
Stas and I just ran across something interesting concerning Apache::DBI and $dbh
attributes. I think it involves a both a bug and a place for enhancements.
we all know how Apache::DBI works - it stashes away $dbh based on connect string info.
ho
I have some object oriented modules that use DBI's connect_cached
method. I'm porting these modules to mod_perl and I see that there is a
Apache::DBI module that seems like it is doing the same thing that would
happen under mod_perl using connect_cached, the only difference b
Hi Jaswant-
I have attached my diffs against Apache::DBI v0.88. However, I do not
believe this will
fix your problem. There may be 2 sources of your problem that I can think
of. One is
that you specified a very long ping time out with
Apache::DBI::setPingTimeOut for your
oracle connection
7;m using persistent connection
method using Apache::DBI in the startup script to open connection to the Oracle
database.
Will your fix listed in the message, address this problem. I'm
asking this question because I have MySQL & I wonder if it would affect
MySQL connection. Please help
Hello all,
We are using:
Apache 1.3.20
modperl 1.26
Apache::DBI 0.88
DBI 1.20
DBD::Oracle 1.12
We have come across an issue with Apache::DBI where it is making an incorrect
assumption about the need to ping a cached connection. The code is written such that
LastPingTIme and PingTimeOut
According to the subclassing posts that are out there, one of the things
that you're supposed to do when subclassing DBI is to call
__PACKAGE__->init_rootclass(). That works fine.
However, when you use Apache::DBI, Apache::DBI will be used to make
the connection, but an Apache:
If I have a subclass of DBI, say MyDBI, and I use that in a mod_perl
app, does Apache::DBI not recognize it an cache it? Can Apache::DBI
only cache handles generated from DBI itself?
I've loaded Apache::DBI with a PerlModule statement, but my subclassed
handle isn't persistent
Hi all,
I'm using Apache::DBI to maintain persistent connections to an Oracle db. There is a
case in my application where I would like to really disconnect from the database and
create a new connection. The problem of course, is that Apache::DBI overloads the
disconnect method and
This problem was fixed by upgrading Oracle to 8.1.7
-Steve
Robert Landrum wrote:
> At 2:15 AM +0100 8/2/01, Tim Bunce wrote:
> >On Mon, Jul 30, 2001 at 04:57:09PM -0400, Steven Schmidt wrote:
> >> The following problem came up in porting EnsEMBL to Oracle:
> >>
> >> Level 9 DBI trace:
> >>
hi,
I'm using Apache::DBI in a site using modperl and mason. Most of
my database connections use Apache::DBI, and I wnat to keep them
that way. However, I'm finding special cases where I need to be
able to open a database connection only temporarily- the standard
DBI way- as oppose
We are going from 8.1.5 to 8.1.7
Paul Edmondson wrote:
> On Wed, 8 Aug 2001, Steven Schmidt wrote:
>
> > We now believe this is an Oracle problem which we can solve by upgrading.
>
> What version of Oracle caused these errors and which version are you
> upgrading to?
>
> I apologise if this i
Hi there,
On Tue, 12 Jun 2001, Mark Vandenbroeck wrote:
> There seems to be some confusion and even incorrectness in this trail. Let's get
> some things straight :
Thanks for setting me straight!
73,
Ged.
Hi all,
There seems to be some confusion and even incorrectness in this trail. Let's get
some things straight :
* There is nothing wrong with NLS_LANG. In fact, it is extremely useful in an
international setting. Your value is fine.
* ORA_NLS33 is obsolete in 8.1.7 and should not be s
Hi again,
On Tue, 12 Jun 2001, Eric Kolve wrote:
> Yes, I have NLS_LANG set to AMERICAN_AMERICA.WE8ISO8859P1.
I seemed to get on better by removing NLS_LANG and ORA_NLS33 from
my environment altogether.
> BTW, I am also using the latest oracle client libs (8.17) if this
> makes any difference;
ite_perl/5.005/Apache/DBI.pm line 153.
> >
> > I am running Apache::DBI 0.88.
> >
> > I didn't see this error with DBI 1.14 + DBD::Oracle 1.06. Anyone have
> > any ideas?
>
> Have you done something else as well? I don't think it's necessaril
On Mon, Jun 11, 2001 at 04:15:15PM -0700, Eric Kolve wrote:
> I recently upgraded to DBI 1.18 + DBD::Oracle 1.07 and upon restarts
> with mod_perl, I get the following error:
>
> DBD::Oracle::db rollback failed: Error while trying to retrieve text for
> error ORA-03113 (DBD ERROR: OCITransRollbac
:
> >
> > DBD::Oracle::db rollback failed: Error while trying to retrieve text for
> > error ORA-03113 (DBD ERROR: OCITransRollback) at
> > /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 153.
> >
> > I am running Apache::DBI 0.88.
> >
> > I didn'
ansRollback) at
> /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 153.
>
> I am running Apache::DBI 0.88.
>
> I didn't see this error with DBI 1.14 + DBD::Oracle 1.06. Anyone have
> any ideas?
Have you done something else as well? I don't think it's necessarily
D
running Apache::DBI 0.88.
I didn't see this error with DBI 1.14 + DBD::Oracle 1.06. Anyone have
any ideas?
--eric
Probably a bug in DBD::mysql. Talk to the author.
Tim.
On Thu, Apr 05, 2001 at 01:27:13PM -0400, Alec Smith wrote:
> In my module I've got:
>
> use DBI;
> use Apache::DBI;
> $db = DBI->connect('DBI:mysql:dbname', 'username', 'password'
99 matches
Mail list logo
