If you have a "normal" installation...in particular, your tnsnames.ora
and any whatever other .ora files reside in
$ORACLE_HOME/network/admin/. Then only $ORACLE_HOME need be supplied,
then you can create a connection for every database in your
tnsnames.ora file if you like. If tnsnames.ora resid
Lev Lvovsky wrote:
we're trying to simulate a database outage for an application which
needs to be able to fail gracefully, and come back up when the DB does.
These errors can also be seen when the mysql server is restarted
(connections get killed then too).
Yes, in both cases you no longer
On Wed, 29 Nov 2006, Michael Peters wrote:
Maybe you could have Apache::DBI issue a warning if it's being loaded
and DBI has already been loaded. Something as simple as the attached
patch should work.
+# we can only do our magic if DBI isn't already loaded
+warn "Apache::DBI must be
On Nov 29, 2006, at 2:46 PM, Philip M. Gollucci wrote:
Michael Peters wrote:
+# we can only do our magic if DBI isn't already loaded
+warn "Apache::DBI must be loaded after DBI to work correctly";
I like it -- any objects list ?
i REALLY like that idea.
it solves the problem AND te
On Mon, 27 Nov 2006 16:36:17 -0800
"Philip M. Gollucci" <[EMAIL PROTECTED]> wrote:
> Frank Wiles wrote:
> >Oh and yes, you can use your own login forms with these.
> (Custom AAA Handlers)
>
> I don't this is a widely known fact, so I'm resending it to emphasize
> it.
>
> It would be nice to
Keep it on list -- others have the same question 'trust me'
Lev Lvovsky wrote:
Philip, not sure if this is possible, but what happens if Apache::DBI is
loaded in the correct order the first time, but then afterwards loaded
again after DBI has been loaded - does the Perl loader make sure this
do
Michael Peters wrote:
--- DBI.pm.old 2006-11-29 14:30:56.0 -0500
+++ DBI.pm 2006-11-29 14:32:05.0 -0500
@@ -15,6 +15,10 @@
$modperl::VERSION < 1.99) {
require Apache;
}
+
+# we can only do our magic if DBI isn't already loaded
+warn "Apach
Philip M. Gollucci wrote:
> If you can suggest a documentation patch you feel clarify things, I'll
> read it over and commit for version 1.06 (sorry about that 1.05 is current)
Maybe you could have Apache::DBI issue a warning if it's being loaded and DBI
has already been loaded. Something as si
Lev Lvovsky wrote:
On Nov 28, 2006, at 11:03 PM, Philip M. Gollucci wrote:
is this mod_perl 1 or 2 ?
Setting $Apache::DBI::Debug = 2; and watching you're error log file
should tell you what its doing.
package X;
# database
our $host = 'mysql.x.y';
our $dsn = "dbi:mysql:db;host=$host";
our $u
On Nov 28, 2006, at 11:03 PM, Philip M. Gollucci wrote:
is this mod_perl 1 or 2 ?
Setting $Apache::DBI::Debug = 2; and watching you're error log file
should tell you what its doing.
package X;
# database
our $host = 'mysql.x.y';
our $dsn = "dbi:mysql:db;host=$host";
our $user = 'u';
our $pass
You could try specifying the host and sid in the connect string.
That way you only need ORACLE_HOME defined, nothing else.
Something like this:
my $dsn = 'dbi:Oracle:host=grill-name;sid=pork-roast;port=1525';
From: Malka Cymbalista [mailto:[EMAIL PROT
Lev Lvovsky wrote:
Once you reconnect, the connection is persistent again. At least,
that's been my experience with postgresql.
This is exactly what I've been thinking to do, but I've not seen
anything within Apache::DBI that allows me to reconnect per se. How do
I perform that action?
Al
I forgot to mention also that we're not using a startup.pl file, but
instead connecting to the DB several times using several different
accounts as a specific virtual host requires. At the risk of
pointing out the answer for myself, does this adversely affect anything?
thanks,
-lev
On Nov
On Tuesday 28 November 2006 22:37, Robert Landrum wrote:
> > On Tuesday 28 November 2006 21:31, Patrick Galbraith wrote:
> >> Quick question - how does one do a repost (using POST, not GET) form
> >> values? This would be in a redirect TransHandler.
> >
> > Your only chance is to proxy the request
http://apache.org/dist/perl/mod_perl-2.0.3.tar.gz
http://apache.org/dist/perl/mod_perl-2.0.3.tar.gz.asc (pgp sig)
The package is also available on CPAN:
file: $CPAN/authors/id/P/PG/PGOLLUCCI/mod_perl-2.0.3.tar.gz
size: 3714974 bytes
md5: b40e2adf67c6be15a0041af1c67b6997
Changes since 2.0
I am running Apache 2.0.55 with mod_perl 2.0.1 and Perl 5.8.1 on a Sun
Solaris machine. I am using DBI/DBD to connect to an Oracle database. I
am running DBI 1.39 and DBD-Oracle 1.16.
In order to connect to an oracle database on a different machine I have
a tnsnames.ora file with the appropriat
16 matches
Mail list logo
