Re: DBD::oracle question about auto reconnecting

2008-11-12 Thread Patrick Galbraith
John Scoles wrote: Not that I am aware of. Is auto-reconnect a specific MYSQL command of some sort or is a PERL base command or some sort? Can you give me an example of how it is used? cheers John Scoles Patrick Galbraith wrote: Hi there, Is there the equivalent of an auto-reconnect

Re: DBD::oracle question about auto reconnecting

2008-11-12 Thread Tim Bunce
On Tue, Nov 11, 2008 at 11:27:59AM -0500, Patrick Galbraith wrote: John, Hi! DBD::mysql uses mysql_auto_reconnect to connect back to MySQL if the connection drops $dbh= DBI-connect('DBI:mysql:test:mysql_auto_reconnect=1', $foo, $fee)...; or of course $dbh-{mysql_auto_reconnect}; In

Re: DBD::oracle question about auto reconnecting

2008-11-12 Thread Steve Baldwin
I echo Tim's comments. We looked into implementing auto reconnect for our applications (e.g. in the case of the DB going down) and unless you have a *very* simple scenario it was just too much work to save and restore state. For example, you could lose the connection between a -prepare and an

DBD::oracle question about auto reconnecting

2008-11-11 Thread Patrick Galbraith
Hi there, Is there the equivalent of an auto-reconnect with DBD::Oracle as DBD::mysql has (appended in the connect DSN) ? Thanks! Patrick

Re: DBD::oracle question about auto reconnecting

2008-11-11 Thread John Scoles
Not that I am aware of. Is auto-reconnect a specific MYSQL command of some sort or is a PERL base command or some sort? Can you give me an example of how it is used? cheers John Scoles Patrick Galbraith wrote: Hi there, Is there the equivalent of an auto-reconnect with DBD::Oracle as