Hi. I posted this question to Commons-User but there is no reply to it. Since there are many Commons experts here...
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. Any reason why it happens? Anything to do with the fact that the validation query is a Statement, but the actual query is a PreparedStatement? 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. __________________________________________________ Do You Yahoo!? Send free SMS from your PC! http://sg.sms.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]