在JSP中抛出的异常，很烦！

[fly_ya]

在JSP中，联接数据库后，新开了一个IE时，就会抛出很长的异常，不知道怎么回事，但是页面还是可以正常访问。

StandardWrapperValve[default]: Servlet.service() for servlet default threw exception

java.net.SocketException: Software caused connection abort: socket write error

java.net.SocketException: Software caused connection abort: socket write error

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)

at java.net.SocketOutputStream.write(SocketOutputStream.java:136)

at org.apache.catalina.connector.ResponseBase.flushBuffer(ResponseBase.java:674)

at org.apache.catalina.connector.HttpResponseBase.flushBuffer(HttpResponseBase.java:764)

at org.apache.catalina.connector.ResponseBase.write(ResponseBase.java:647)

at org.apache.catalina.connector.ResponseStream.write(ResponseStream.java:312)

at org.apache.catalina.connector.http.HttpResponseStream.write(HttpResponseStream.java:189)

at org.apache.catalina.servlets.DefaultServlet.copyRange(DefaultServlet.java:1921)

at org.apache.catalina.servlets.DefaultServlet.copy(DefaultServlet.java:1670)

at org.apache.catalina.servlets.DefaultServlet.serveResource(DefaultServlet.java:1215)

at org.apache.catalina.servlets.DefaultServlet.doGet(DefaultServlet.java:525)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)

at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)

at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)

at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)

at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)

at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)

at java.lang.Thread.run(Thread.java:534)

[delphiseabird]

Software caused connection abort: socket write error
是不是网络断了 造成你访问网络资源失败了.
网页正常显示,估计是因为你捕获了这个错误

----------------------------------------------
www.coderpub.com

[lmjzw]

呵呵，是你的网络连接错误呀！可能是你的权限没有给够的哈！

[flywithmoon]

java.net.SocketException: Software caused connection abort: socket write error。这个应该是socket的问题，一般就是mssql没有打补丁。代码一般很少问题的，不行就换数据库或者数据库的驱动。

[fly_ya]

什么意思啊？怎么让它不抛这些错误。

[dongsheng_9234]

用try/catch把数据库操作这一段代码，扩起来，不让他显示，或在打印输出异常的前后加入
<!-- 和--> 以注释的形式打印。

[cuiyingfeng]

你的代码在那里，贴出来大家分析一下，应该不是核心业务吧

[fly_ya]

1. 这是bean.
package myweb;

public class PhotoInfo {

private String id;
private String smallIcon;
private String bigIcon;

public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getSmallIcon() {
return smallIcon;
}
public void setSmallIcon(String smallIcon) {
this.smallIcon = smallIcon;
}
public String getBigIcon() {
return bigIcon;
}
public void setBigIcon(String bigIcon) {
this.bigIcon = bigIcon;
}
}

2. 这是连接数据库的。

package myweb;

import java.sql.*;

public class DBAccess {
private String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
private String url = "jdbc:odbc:photo";
private Connection conn = null;

public DBAccess() throws ClassNotFoundException, SQLException {
Class.forName(driver);
conn = DriverManager.getConnection(url);
}

public Connection getConnection() {
return conn;
}
}

3. 这是操作数据库的，现在不知道是哪里报错？

package myweb;

import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.sql.Connection;

public class PhotoInfo_2 {

public ArrayList getPhoto(String type) throws SQLException, ClassNotFoundException {
DBAccess db = new DBAccess();
Connection conn = db.getConnection();
Statement sm = conn.createStatement();
ResultSet resultSet = null;
String sql = "select * from photo where type = '" + type + "'";
resultSet = sm.executeQuery(sql);

ArrayList list = new ArrayList();

while (resultSet.next()) {
PhotoInfo info = new PhotoInfo();
info.setId(resultSet.getString("id"));
list.add(info);
}
resultSet.close();
sm.close();
conn.close();

return list;
}
}

[fly_ya]

我先用SQL的数据库，后又用了access的，都一样。如果要打补丁，应打什么样的？

[terry_yip]

DBAccess中的url怎么会没有用户名跟密码的？

[fly_ya]

我后来用的access的数据库，不用用户名和密码的。

[yunqing1028]

打sp3的补丁，可到微软网站去下载