javax.servlet.ServletException请帮忙看看.

Question

把你出exception的代码贴一下,估计又是配置的问题

Answer 1

public Vector getList(String astring, Connection conn) throws SQLException {
  Vector list = new Vector();
  String sql = "select * from Article" + astring;
  if (astring == null) {
    return list;
  }
  PreparedStatement pstmt = conn.prepareStatement(sql);
  ResultSet rs = pstmt.executeQuery();
  try{
    while (rs.next()) {      ArticleData artdata = new ArticleData();
      artdata.setArtId(new Integer(rs.getInt("ArtId")));
      artdata.setArtTitle(rs.getString("ArtTitle"));
      artdata.setArtCreateDate(rs.getString("ArtCreateDate"));
      artdata.setArtAuthor(rs.getString("ArtAuthor"));
      artdata.setArtSource(rs.getString("ArtSource"));
      artdata.setArtDisplayTitle(rs.getString("ArtDisplayTitle"));
      artdata.setArtContent(rs.getString("ArtContent"));
      artdata.setArtRelKey(rs.getString("ArtRelKey"));
      artdata.setArtSecretClass(rs.getString("ArtSecretClass"));
      artdata.setArtDigest(rs.getString("ArtDigest"));
      artdata.setArtPicture(rs.getString("ArtPicture"));
      artdata.setArtHeat(rs.getString("ArtHeat"));
      artdata.setArtNews(rs.getString("ArtNews"));
      artdata.setArtTop(rs.getString("ArtTop"));
      artdata.setArtAddDate(rs.getString("ArtAddDate"));
      artdata.setArtModel(rs.getString("ArtModel"));
      artdata.setArtTypeClass(rs.getString("ArtTypeClass"));
      artdata.setArtPath(rs.getString("ArtPath"));
      artdata.setArtStatus(rs.getString("ArtStatus"));
      artdata.setArtMotif(rs.getString("ArtMotif"));
      artdata.setArtPoint(rs.getString("ArtPoint"));
      artdata.setArtMemo(rs.getString("ArtMemo"));
      artdata.setAdductionID(rs.getString("AdductionID"));
      artdata.setArtTypeSubClass(rs.getString("ArtTypeSubClass"));
      artdata.setArtAboutKeyWord(rs.getString("ArtAboutKeyWord"));
      artdata.setArtAdductionNumbers(rs.getString("ArtAdductionNumbers"));
      artdata.setUserId(new Integer(rs.getInt("UserId")));
      list.add(artdata);
      System.out.println(rs.getRow());
    }
  }catch(Exception e){
    System.out.println(e.getMessage());
    e.printStackTrace();
  }
  rs.close();
  pstmt.close();
  basedao.closeConnection(conn);
  rs=null;
  pstmt=null;
  return list;
}

Answer 2

问题就出在这个方法里,在while中,如果我想要装入10万条记录到Vector中,在装入到1933条的时候就会抛出异常.奇怪的是:如果我只初始化而不给artdata的属性赋值,则什么问题都没有,即:
while (rs.next()) {      ArticleData artdata = new ArticleData();
      list.add(artdata);
}