[OT]Broken pipe despite validation query set

[Cheng Xu <xu...@yahoo.com.sg>]

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: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org