<%@page contentType=“text/html”%>
<%@page pageEncoding=“UTF-8”%>
<%@
include file=“ServerConfiguration.jsp”
%>
<%@
page import=“org.firebirdsql.jdbc.,org.firebirdsql.logging.Logger,java.sql.”
%>
<%
Class.forName(“org.firebirdsql.jdbc.FBDriver”);
Connection aConnection = DriverManager.getConnection(DatabaseAddr,UserName, Password);
Statement stmt = aConnection.createStatement();
%>
<%–
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library… action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
–%>
<%–
<%@taglib uri=“http://java.sun.com/jsp/jstl/core” prefix=“c”%>
–%>
<h1>JSP Page</h1>
<%
Class.forName(“org.firebirdsql.jdbc.FBDriver”);
Connection asql = DriverManager.getConnection(DatabaseAddr,UserName, Password);
Statement stmt1 = asql.createStatement();
String v_nome=(request.getParameter(“atendimento”));
String select=“Select idcidade from cidade where nomecidade=’”+v_nome+"’";
ResultSet aselect=stmt1.executeQuery(select);
v_id = (aselect.getString(“idcidade”));
%>
nome
<%--
This example uses JSTL, uncomment the taglib directive above.
To test, display the page like this: index.jsp?sayHello=true&name=Murphy
--%>
<%--
<c:if test="${param.sayHello}">
<!-- Let's welcome the user ${param.name} -->
Hello ${param.name}!
</c:if>
--%>
</body>
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: The resultSet is not in a row, use next
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.inclui_jsp._jspService(inclui_jsp.java:126)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)
root cause
java.sql.SQLException: The resultSet is not in a row, use next
org.firebirdsql.jdbc.FBResultSet.getField(FBResultSet.java:334)
org.firebirdsql.jdbc.FBResultSet.getString(FBResultSet.java:383)
org.apache.jsp.inclui_jsp._jspService(inclui_jsp.java:106)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.
Esta dando erro na seguinte linha:
v_id = (aselect.getString(“idcidade”));
Como eu faco para tirar esse erro?
Evandro
