Hi,
The variable rek is defined within the scope of the try{} block. Therefore it
cannot be recognised in the catch{} block.
Regards,
Stephen
Erwan TROEL wrote:
>
> <%@ page info="database handler"%>
> <%@ page import="java.io.*"%>
> <%@ page import="java.util.*"%>
> <%@ page import="java.sql.*"%>
> <%@ page import="javax.servlet.*"%>
> <%@ page import="javax.servlet.http.*"%>
> <%
> try
> {
>
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> String url="jdbc:odbc:test";
>
> Connection con=DriverManager.getConnection(url, "administrator",
> "password");
> Statement stmt = con.createStatement();
> ResultSet rek = stmt.executeQuery (
> "SELECT TOTAL FROM COFFEES WHERE COF_NAME='ARABICA'");
> }
> catch (Exception e) {}
>
> out.println(rek.getString());
> %>
> Does any body know the Pb? error 500:
> org.apache.jasper.JasperException: Unable to compile class for
> JSPC:\jakarta-tomcat\work\localhost_8080\_0002ftest_0002ejsptest_jsp_3.java:
> 98: Undefined variable or class name: rek out.println(rek.getString()); ^ 1
> error
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
--
._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._.
Stephen Redmond Logica (Mobile Networks)
Tel: +353-1-8193673 5 Custom House Plaza,
Fax: +353-1-8193401 Harbourmaster Place,
mailto:[EMAIL PROTECTED] Dublin 1,
http://www.logica.com/telecoms Ireland.
._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
