helo, I have this code: ResultSet rs = stmt.executeQuery("SELECT attr FROM table WHERE id=1"); System.out.println(rs.getFetchSize()); rs.getFetchSize() everytime returns 0... why??? thanx, miso ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match