DO NOT REPLY [Bug 21132] New: - Broken pipe despite validation query set

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21132>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21132

Broken pipe despite validation query set

           Summary: Broken pipe despite validation query set
           Product: Commons
           Version: 1.0 Final
          Platform: All
        OS/Version: Other
            Status: NEW
          Severity: Critical
          Priority: Other
         Component: Dbcp
        AssignedTo: commons-dev@jakarta.apache.org
        ReportedBy: xucheng_chn@yahoo.com.sg


I got a broken pipe error sometimes when trying to
execute a prepared statement. I am using DBCP 1.0 and
I set the validation query as "select sysdate from
dual". However, I still get the error. What I do is:
prst = conn.prepareStatement(strbuff.toString());
prst.setInt(1, extSysCode);
prst.setString(2, extSysTxnID);
rs = prst.executeQuery();
The error occurs when I call executeQuery, but no
error when I call prepareStatement. 
The error is SQLException: Io exception: Broken pipe
The error disappears after the application server is
restarted. But it occurs again later. Not sure about
the pattern yet, but this is in production, so need to
solve it asap.

Other facts: 
Application server: struts 1.1b2, tomcat 4.1.24,
Oracle JDBC driver 8.1.7 (classes12.zip), thin driver.
Solaris 8.
DB server: Oracle 8.1.7, Solaris 8.

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org