Apache::DBI connect

2013-11-06 Thread Xinhuan Zheng
Hi, I am using Apache+mod_perl and Apache::DBI with Oracle connection pooling feature. I noticed a problem with subroutine connect. Below code checks database connection: 200:if ($Connected{$Idx} and (!$needping or eval{$Connected{$Idx}-ping})) { debug(2, $prefix already connected

Re: Apache::DBI connect

2013-11-06 Thread Perrin Harkins
On Wed, Nov 6, 2013 at 4:07 PM, Xinhuan Zheng xzh...@christianbook.comwrote: 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

Re: Apache::DBI connect

2013-11-06 Thread Xinhuan Zheng
Hi Perrin, I am using Oracle Resident Connection Pool feature. The application randomly got ORA-03114 not connect to oracle database error. As per this document: http://search.cpan.org/~phred/Apache-DBI-1.12/lib/Apache/DBI.pm I have changed the DBD::Oracle to use the following ping instead of

svn commit: r1539487 - /perl/modperl/branches/httpd24threading/src/modules/perl/modperl_util.c

2013-11-06 Thread stevehay
Author: stevehay Date: Wed Nov 6 22:39:41 2013 New Revision: 1539487 URL: http://svn.apache.org/r1539487 Log: Provide a better return value from perl_parse_require_line() in the case where interp is NULL and add a comment to explain why we currently don't expect this to happen. Thanks again