Chinaunix

标题: [求助]连接占线,在用JBuilder连接SQL时提示的 [打印本页]

作者: 灵兽小白 时间: 2008-02-05 04:42
标题: [求助]连接占线,在用JBuilder连接SQL时提示的
抛出的异常e1为：java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]连接占线导致另一个 hstmt.L
这代码是我从学校里COPY的,在学校就能用,在我家里就出错;
我把查询结果一个个的COPY到查询分析器里试了下,代码里的两条数据库语句没错,它们就是不生效!

代码:
public static void addTree(DefaultMutableTreeNode t) {
      Connection con = null;
      PreparedStatement pstCate = null;
      PreparedStatement pstSubCate = null;
      ResultSet rsCate = null;
      ResultSet rsSubCate = null;
      try {
         con = DBManager.getCon();
         pstCate = con.prepareStatement(
                  "select distinct cateid,catename from category");
         rsCate = pstCate.executeQuery();
         DefaultMutableTreeNode dmt = null;
         DefaultMutableTreeNode dmtSub = null;
         while (rsCate.next()) {
            String abc1 = rsCate.getString(1);
            String abc = rsCate.getString(2);
            dmt = new DefaultMutableTreeNode(abc);
            t.add(dmt);
            pstSubCate = con.prepareStatement(
                     "select subcatename from category where cateid=?");
            pstSubCate.setString(1, abc1);
            try {
                  rsSubCate = pstSubCate.executeQuery();
                  while (rsSubCate.next()) {
                     String bcd = rsSubCate.getString(1);
                     dmtSub = new DefaultMutableTreeNode(bcd);
                     dmt.add(dmtSub);
                  }
            } catch (Exception e1) {
                     System.out.println(e1);
            }
         }
         rsCate.close();
         rsSubCate.close();
         pstCate.close();
         pstSubCate.close();
         con.close();
      } catch (Exception e) {
         System.out.println(e);
      }
}

作者: 野火烧不尽 时间: 2008-02-20 22:52
提示: 作者被禁止或删除内容自动屏蔽

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)