Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jsp errror found

 
kanan devi
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
im in java beginers,i have found this error
[Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor position.
pliz tell me where is the mistake and how to solve it.
i have givn the stak trace here plize give me the solution

<%
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://logindatabase:1433","sa","smcc123");
Statement st3=conn.createStatement();
String sql3 = "SELECT * FROM news.dbo.polledresult";
ResultSet rs3=st3.executeQuery(sql3);
rs3.next();

question=rs3.getString("lastques");
bs=rs3.getString("res2");
cs=rs3.getString("res3");
ds=rs3.getString("res4");
as=rs3.getString("res1");

%>
<center><font color="#1010A5" size="2" face="Verdana, Arial, Helvetica, sans-serif">Last poll result</font></center>
<% if(question != null){%>
<font color="#1010A5" size="2"><%=question%></font>
<%}%>
<applet code="swiftchart.class" width="249" height="200">
<param name="chart_type" value="bar3d">
<param name="x_value" value="a,b,c,d">
<param name="s1_value" value="<%=as%>,<%=bs%>,<%=cs%>,<%=ds%>">
<param name="s1_label" value="poll">
</applet>
</td></tr>
</table>

<%
st3.close();
rs3.close();
conn.close();
}
catch(Exception ex)
{
System.err.println("Error: " + ex );
out.println(ex.getMessage());
}
%>
<% session.setAttribute("insertTag","false"); %>
</td></tr></table>
</body>
</html>
 
Seetharaman Venkatasamy
Ranch Hand
Posts: 5575
Eclipse IDE Java Windows XP
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
your code is difficult to read.please use UBB code tag to post your coding part.
 
Mourouganandame Arunachalam
Ranch Hand
Posts: 396
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

It looks like you are not on a valid row or the result set might have closed. You should check what rs3.next() returns before accessing result set contents. next() will return false if you are not in a valid row.
 
CharanZ Gowda
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
when multipple sets of data is returned you need to use loops to retrieve the entire data.
Use 'While(rs3.next()){}' instead of 'rs3.next();'
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Further, its not a good idea to do database stuff inside your JSP. If you are writing a test or something, then consider to use SQL tags.
 
ou yang
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
what is your version of sql 2000 db.maybe your database is missing to install something .
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic