Re: Oracle ping

2012-11-09 Thread David E. Wheeler
On Nov 9, 2012, at 4:13 AM, John Scoles 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 a query can be r

RE: Oracle ping

2012-11-09 Thread John Scoles
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 a query can be run then no, if you are going for 100% work alike betweeen

Re: Oracle ping

2012-11-09 Thread David E. Wheeler
On Nov 5, 2012, at 7:59 AM, Martin J. Evans 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 Oracle's OCIPing whi

Re: Oracle ping

2012-11-09 Thread David E. Wheeler
On Nov 5, 2012, at 8:57 AM, Greg Sabino Mullane 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 like this. B

Re: Oracle ping

2012-11-09 Thread David E. Wheeler
On Nov 5, 2012, at 5:52 AM, John Scoles 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 > > http://dev.mysql.com/doc/con