Pokusavam da napravim aplikaciju koristeci servlete, JSP i mySQL. Na jednoj JSP strani imam sledeci kod:
Code:
<%
pcon=(PooledConnection)config.getServletContext().getAttribute("conPool");
con=pcon.getConnection();
threadID=new Integer(request.getParameter("threadID"));
PreparedStatement ps=con.prepareStatement("SELECT * FROM threads WHERE id=?");
ps.setInt(1,threadID.intValue());
ResultSet rs=ps.executeQuery();
user=rs.getString("postedby");
topic=rs.getString("topic");
time=rs.getTimestamp("time");
text=rs.getString("txt");
rs.close();
%>
<%
pcon=(PooledConnection)config.getServletContext().getAttribute("conPool");
con=pcon.getConnection();
threadID=new Integer(request.getParameter("threadID"));
PreparedStatement ps=con.prepareStatement("SELECT * FROM threads WHERE id=?");
ps.setInt(1,threadID.intValue());
ResultSet rs=ps.executeQuery();
user=rs.getString("postedby");
topic=rs.getString("topic");
time=rs.getTimestamp("time");
text=rs.getString("txt");
rs.close();
%>
Kad se ova strana pokrene, dobijam izuzetak tipa
Code:
java.sql.SQLException: Before start of result set
java.sql.SQLException: Before start of result set
problem je sto nemam pojma sta ovaj izuzetak treba da znaci, tako da ako neko ima ideju, bio bih veoma zahvalan.