how to resolve org.postgresql.util.PSQLException: ResultSet notpositioned properly, perhaps you need to call next.
От | Karen Goh |
---|---|
Тема | how to resolve org.postgresql.util.PSQLException: ResultSet notpositioned properly, perhaps you need to call next. |
Дата | |
Msg-id | 932079842.712590.1567405714491@mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: how to resolve org.postgresql.util.PSQLException: ResultSet notpositioned properly, perhaps you need to call next.
Re: how to resolve org.postgresql.util.PSQLException: ResultSet notpositioned properly, perhaps you need to call next. Re: how to resolve org.postgresql.util.PSQLException: ResultSet notpositioned properly, perhaps you need to call next. |
Список | pgsql-jdbc |
Hi experts, I have been trying to find a solution in the internet but there is only 1 solution offered by stackoverflow in which theuser uses if it is not there then use a else to print out there is no more data/row that appeared in that column. Basically, I was trying to get a List<String> which meet certain search condition so the data will come from 2 tables - oneof which is a column from a join table and the List<String> falls under this table. So, here's the code that I attempt to get the data out but keep getting ResultSet not positioned properly. String[] subjectNames = request.getParameterValues("txtsubjects"); String zipcode = request.getParameter("location"); List<String> subjList = new ArrayList<String>(Arrays.asList(subjectNames)); List<tutor> myList = new ArrayList<>(); ArrayList<String> subList = new ArrayList<>(); CopyOnWriteArrayList<String>newSub = new CopyOnWriteArrayList<String>(); tutor t = new tutor(); String sql1 = "select t.tutor_contact_no, t.zipcode, t.tutor_id, t2.subject_name FROM s_tutor t JOIN tutor_subjectt2 ON t.tutor_id = t2.tutor_id where t.zipcode = ? And t2.subject_name = Any((?))"; PreparedStatement ps2 = connection.prepareStatement(sql1); ps2.setString(1, zipcode); for (int i = 0; i < subjectNames.length; i++) { Array array = connection.createArrayOf("text", subjList.toArray()); ps2.setArray(2, array); } ResultSet rs = ps2.executeQuery(); while (rs.next()) { t.setContactNo(rs.getString("tutor_contact_no")); t.setZipcode(rs.getString("zipcode")); t.settutor_id(rs.getInt("tutor_id")); for (String s: subjList) if (s.contains(rs.getString("subject_name"))) subjList.add(rs.getString("subject_name")); newSub.addAll(subjList); } myList.add(t); request.setAttribute("tutors", myList); request.setAttribute("sub", newSub); Please. I hope someone can tell me what's wrong with the code or how to overcome this error...I have been struggling for2 weeks already. Thanks. } myList.add(t); request.setAttribute("tutors", myList); request.setAttribute("sub", newSub);
В списке pgsql-jdbc по дате отправления: