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: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
