2 forespørgsler (queries) i jsp

Rettelse:
Hej
Jeg får problemer når jeg prøver at oprette 2 forespørgsler i jsp.

Først opretter jeg 2 databaseconnection i filen "databaseConnection.jsp":
    Class.forName( dbDriver ).newInstance();
      // Open connection to the database
      dbConn = DriverManager.getConnection(dbUrl, dbUser, dbPassword);
      ny = DriverManager.getConnection(dbUrl, dbUser, dbPassword);

Herefter vil jeg gerne i filen reneDBconn lave 2 sql-forespørgsler:

    Statement stmt = ny.createStatement();
        Statement stat = dbConn.createStatement();

.
.
.

        //    OK!!!!!!!!!!!!
          ResultSet rs = stat.executeQuery(sql);

.
.
.
.
.
          // IKKE OK
  ResultSet kurer = stmt.executeQuery("select vtype, beskrivelse, adr from vogntype where vtype = 'kurer' ");             


M.a.o. Hvad gør man, når man vil lave 2 stk sql-forespørgsler i jsp-kode

Umiddelbart ser det OK ud - hvilken fejl får du ?

TROR DET ER DENNE
javax.servlet.ServletException: Before start of result set
javax.servlet.ServletException: Before start of result set
.
.
.

C:\JBuilderX\jdk1.4\bin\javaw -classpath "C:\JBuilderX\thirdparty\jakarta-tomcat-4.0.6-LE-jdk14\bin\bootstrap.jar;C:\JBuilderX\jdk1.4\lib\tools.jar"  -Dcatalina.home="C:/JBuilderX/thirdparty/jakarta-tomcat-4.0.6-LE-jdk14"  org.apache.catalina.startup.Bootstrap -config C:\Minitrans\MINITRANS\Tomcat\conf\server8080.xml start
HttpConnector Opening server socket on all host IP addresses
Starting service Tomcat-Standalone
Apache Tomcat/4.0.6
WebappLoader[/MinitransWeb]: Deploying class repositories to work directory C:\Minitrans\MINITRANS\Tomcat\work\MinitransWeb
WebappLoader[/MinitransWeb]: Reloading checks are enabled for this Context
StandardManager[/MinitransWeb]: Seeding random number generator class java.security.SecureRandom
StandardManager[/MinitransWeb]: Seeding of random number generator has been completed
ContextConfig[/MinitransWeb]: Added certificates -> request attribute Valve
StandardWrapper[/MinitransWeb:default]: Loading container servlet default
StandardWrapper[/MinitransWeb:invoker]: Loading container servlet invoker
HttpConnector[8080] Starting background thread
SELECT hoejde, laengdeudv, laengdeind, totalvaegt, lasteevne, vogn.vtype, adr FROM vogn, vogntype WHERE adr = 0 AND vogn.vtype = vogntype.vtype ORDER BY vogn.vtype
StandardWrapperValve[debugjsp]: Servlet.service() for servlet debugjsp threw exception
javax.servlet.ServletException: Before start of result set
javax.servlet.ServletException: Before start of result set
    at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:471)
    at org.apache.jsp.reneDBconn$jsp._jspService(reneDBconn$jsp.java:584)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
    at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
    at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
    at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
    at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
    at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
    at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
    at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
    at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
    at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
    at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
    at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
    at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
    at java.lang.Thread.run(Thread.java:534)

Den fejl lyder bare som du har glemt at kalde:

rs.next()

og

kurer.next()

Det var lige præcist hvad det var.
Jeg takker...

så ligger jeg et svar

nu ved jeg ikke om du allerede har gjort det men en god idet er at inkapsle det er i try catch
try{
  DB udtræk etc
}
catch(Exception e){
  out.println(e.getMessage());
}

Det har jeg. Fejlen var - som Arne allerede har svaret - at jeg havde glemt at kalde rs.next() og kurer.next().

Jep det ved jeg det var bare hvis du ikke var opmærksom på try catch :)