try{
sql = \"selete trade_num,bidder_count from a\";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
PreparedStatement ps2 = null;
trade_num = rs.getInt(\"trade_num\");
bidder_count = rs.getInt(\"bidder_count\");
if(bidder_count != 0){
PreparedStatement ps3 = null;
ResultSet rs3 = null;
sql = \" select bid_num, bid_price, bidder_nid, bidder_char, top_bid_flag \" +
\" from b where trade_num = ?\";
ps3 = conn.prepareStatement(sql);
ps3.setInt(1,trade_num);
rs3 = ps3.executeQuery();
while(rs3.next()){
에러
}
if(ps3 != null){ps3.close();}
if(rs3 != null){rs3.close();}
}
}//while(rs.next()){
if(ps != null){ps.close();}
if(rs != null){rs.close();}
}catch(Exception ex){
ex.printStackTrace();
try{
conn.rollback();
}catch(Exception ex1){
ex1.printStackTrace();
}
}finally{
}
에러내용
cubrid.jdbc.driver.CUBRIDException: Attempt to access a closed ResultSet.
at unisql.jdbc.driver.UniSQLResultSet.checkIsOpen(UniSQLResultSet.java:1639)
at unisql.jdbc.driver.UniSQLResultSet.next(UniSQLResultSet.java:178)
at com.mgame.auction.WffmAuction.auction_data(WffmAuction.java:56)<-5번줄 while(rs.next()){ 이부분
at com.mgame.auction.WffmAuction.main(WffmAuction.java:156)
아무리봐도 못찾겠네요. ㅠㅠ
|