Re: Apache::DBI connect
Perrin Harkins <[email protected]>
| Newsgroups | gmane.comp.apache.mod-perl |
|---|---|
| Message-ID | <CAC0_be1F1W_h+R3G8K6bf3Ry-U+xuZUCtiUmNWAK5JchomSbsw@mail.gmail.com> |
On Wed, Nov 6, 2013 at 4:07 PM, Xinhuan Zheng <[email protected]>wrote: > I wonder this line of code should be changed to 'DBI->connect(@args) if > ($@)'. If ping failed, that means the connection is already closed, $drh > may be no longer valid, will $drh->connect always return a valid new > connection? What's the difference between DBI->connect vs $drh->connect? The $drh there is a DBI driver, not a database handle. It should return a new connection every time. You can try putting in DBI->connect() there and see if it fixes the problem for you though. If not, I'd suggest reporting the problem as a DBD::Oracle issue. By the way, which Oracle pooling solution are you using and how is it working out for you, aside from this problem? - Perrin