On Nov 5, 2012, at 5:52 AM, John Scoles byter...@hotmail.com wrote:
Does it automatically reconnect? That certainly seems like the wrong thing
to do, especially in light of the docs for connect_cached.
got that from the MySql doc it can be set up to reconnect if ping fails
On Nov 5, 2012, at 8:57 AM, Greg Sabino Mullane g...@turnstep.com wrote:
Ah, so Oracle still requires an actual table? Thought they might
have joined the rest of us by now in allowing things like
'SELECT 2+2;' :)
No, it always requires a FROM clause, which is typically `FROM dual` for stuff
On Nov 5, 2012, at 7:59 AM, Martin J. Evans martin.ev...@easysoft.com wrote:
Just to reiterate what I eventually said. I don't want ping changed in
DBD::Oracle.
All I was saying is you should only read anything useful into ping returning
false and not true unless your only purpose is like
betweeen all DBDs then no again and I am
sure H.Merijn would like that.
An option would be nice as well
Cheers
John
Subject: Re: Oracle ping
From: da...@justatheory.com
Date: Mon, 5 Nov 2012 10:26:52 -0800
CC: c...@cam.ac.uk; dbi-dev@perl.org
On Nov 9, 2012, at 4:13 AM, John Scoles byter...@hotmail.com wrote:
Well I made that ping patch for DBIx::Connector a few months ago on one of my
production boxes with no impact but then again I am not doing anything fancy
(no rac raid etc).
If it is critical to DBDx::Connector to ensure
On Nov 2, 2012, at 4:46 AM, John Scoles byter...@hotmail.com wrote:
David if you have a repeatable test or set of conditions or recipe of how you
get into this state where DBD::Oracle pings but cannot run queries my buddies
over at Oracle would love to get it.
I don’t, I only know what
From: g...@turnstep.com
To: dbi-dev@perl.org
Subject: Re: Oracle ping
Date: Mon, 5 Nov 2012 02:47:06 +
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Also by the time an application does execute some SQL, the the
connection/node/server
On 05/11/12 02:47, Greg Sabino Mullane wrote:
Also by the time an application does execute some SQL, the the
connection/node/server/network could have dropped and so the application
'will have to check recover from write failures at that point anyway.
This is a bit of a red herring. You
On 05/11/12 15:35, Charles Jardine wrote:
On 05/11/12 02:47, Greg Sabino Mullane wrote:
Also by the time an application does execute some SQL, the the
connection/node/server/network could have dropped and so the application
'will have to check recover from write failures at that point
I would tend to think that such a ping would be a special case, but I agree
with you to keep it as is:
Simply because overloading ping() with a complete eval'ed select statement
would be trivial. And the opposite isn't.
---
Henri Asseily
henri.tel
On Nov 5, 2012, at 4:35 PM, Charles Jardine
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I rather strongly disagree. It is possible to do useful work over a
connection in situations when a 'simple select' is not possible.
My production Oracle database is protected by a physical standby database.
Ah, well in that case I
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Also by the time an application does execute some SQL, the the
connection/node/server/network could have dropped and so the application
'will have to check recover from write failures at that point anyway.
This is a bit of a red herring.
On 31/10/12 16:06, David E. Wheeler wrote:
Fellow DBIers,
When I wrote DBIx::Connector, I borrowed this code from DBIx::Class to “work
around an issue”:
sub ping {
my ($self, $dbh) = @_;
eval {
local $dbh-{RaiseError} = 1;
$dbh-do('select 1
Subject: Re: Oracle ping
On 31/10/12 16:06, David E. Wheeler wrote:
Fellow DBIers,
When I wrote DBIx::Connector, I borrowed this code from DBIx::Class to
“work around an issue”:
sub ping {
my ($self, $dbh) = @_;
eval {
local $dbh-{RaiseError} = 1;
$dbh-do('select 1 from dual
@perl.org
Subject: Re: Oracle ping
On 31/10/12 16:06, David E. Wheeler wrote:
Fellow DBIers,
When I wrote DBIx::Connector, I borrowed this code from DBIx::Class to “work
around an issue”:
sub ping {
my ($self, $dbh) = @_;
eval {
local $dbh-{RaiseError} = 1;
$dbh-do('select 1 from dual
Fellow DBIers,
When I wrote DBIx::Connector, I borrowed this code from DBIx::Class to “work
around an issue”:
sub ping {
my ($self, $dbh) = @_;
eval {
local $dbh-{RaiseError} = 1;
$dbh-do('select 1 from dual');
};
return $@ ? 0 : 1;
16 matches
Mail list logo