Hi,
You spelled Exception wrong in 'catch (SQLExecption e) {}'
Mark
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of John Pallozzi
> Sent: Thursday, October 26, 2000 11:07 AM
> To: [EMAIL PROTECTED]
> Subject: Problem calling Oracle
>
>
> Hello,
>
> I am trying to do a "proof of concept" exercise where I am trying to call
> an Oracle DB and return one row of data, then print it out to the browser
> with JSP.
> Below is my JSP code, my Bean code, and the error I am receiving. Can
> anyone tell me what I am doing wrong?
>
> On a related note I am trying to debug this JSP page using Visual Cafe and
> Tomcat and I am receiving an error when the debugger tries to load
> org.apache.tomcat.startup.Tomcat.class, it essentially says it can't find
> the class. I followed the directions I found at :
>
> http://people.netscape.com/chanezon/tech/java/tomcat/debug_jsp_in_
> cafe.html
>
> To set up a debug environment for JSP with Visual Cafe and Tomcat, and
> still get the same error. Any help there would be greatly appreciated as
> well.
>
> JSP CODE:
>
> <%@ page import="java.sql.*" %>
> <%@ page import = "helloracle.HelloOracleBean" %>
> <jsp:useBean id="nline" class="helloracle.HelloOracleBean"
> scope="session">
> <%
> Connection connection = null;
> Statement statement = null;
> ResultSet results = null;
>
> HelloOracleBean line = new HelloOracleBean();
>
> try{
>
> Class.forName("oracle.jdbc.driver.OracleDriver");
> String url = "jdbc:oracle:[EMAIL PROTECTED]";
> String email_val = "[EMAIL PROTECTED]";
> String query = "SELECT EMAIL, FNAME, LNAME FROM MY_TABLE WHERE EMAIL = " +
> email_val;
> connection = DriverManager.getConnection(url,"userid","password");
> statement = connection.createStatement();
> results = statement.executeQuery(query);
> if(results.next()) {
>
> nline.setEmail(results.getString("EMAIL"));
> nline.setFname(results.getString("FNAME"));
> nline.setLname(results.getString("LNAME"));
>
> }
>
> connection.close();
> }
>
> catch (ClassNotFoundException e) {
>
> System.err.println("Could not load database driver!");
>
> }
>
> catch (SQLException e) {
>
> System.err.println("Could not connect to the database!");
>
> }
>
> finally{
>
> try { if (connection != null) connection.close(); }
> catch (SQLExecption e) {}
>
> }
>
> %>
> </jsp:useBean>
> <html>
> <body>
> <table>
> <TR>
> <TD>Email:</TD>
> <TD><jsp:getProperty name="nline" property="email"/></TD>
> </TR>
> <TR>
> <TD>First Name:</TD>
> <TD><jsp:getProperty name="nline" property="fname"/></TD>
> </TR>
> <TR>
> <TD>Last Name</TD>
> <TD><jsp:getProperty name="nline" property="lname"/></TD>
> </TR>
> </table>
> </body>
> </html>
>
> BEAN CODE:
>
> package helloracle;
>
> import java.util.*;
>
> public class HelloOracleBean {
>
> String passed_email;
> String passed_fname;
> String passed_lname;
>
> public void setEmail(String email) {
>
> passed_email = email;
>
> }
>
> public void setFname(String fname) {
>
> passed_fname = fname;
>
> }
>
> public void setLname(String lname) {
>
> passed_lname = lname;
>
> }
>
> public String getEmail() {
> return passed_email;
> }
>
> public String getFname() {
> return passed_fname;
> }
>
> public String getLname() {
> return passed_lname;
> }
>
>
> }
>
>
> ERROR:
>
> Location: /examples/jsp/helloracle/helloemail.jsp
> Internal Servlet Error:
> org.apache.jasper.JasperException: Unable to compile class for
> JSP/jakarta-tomcat/work/localhost_8080%2Fexamples/_0002fjsp_0002fh
> elloracle_0002fhelloemail_0002ejsphelloemail_jsp_0.java:124:
>
> Class jsp.helloracle.SQLExecption not found in type declaration.
> catch (SQLExecption e) {}
> ^
> 1 error
>
> at java.lang.Throwable.(Compiled Code)
> at java.lang.Exception.(Compiled Code)
> at javax.servlet.ServletException.(Compiled Code)
> at org.apache.jasper.JasperException.(Compiled Code)
> at org.apache.jasper.compiler.Compiler.compile(Compiled Code)
> at org.apache.jasper.runtime.JspServlet.loadJSP(Compiled Code)
> at
> org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNeces
> sary(Compiled
>
> Code)
> at
> org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(Compiled
> Code)
> at org.apache.jasper.runtime.JspServlet.serviceJspFile(Compiled
> Code)
> at org.apache.jasper.runtime.JspServlet.service(Compiled Code)
> at javax.servlet.http.HttpServlet.service(Compiled Code)
> at org.apache.tomcat.core.ServletWrapper.handleRequest(Compiled
> Code)
> at org.apache.tomcat.core.ContextManager.service(Compiled Code)
> at
> org.apache.tomcat.service.http.HttpConnectionHandler.processConnec
> tion(Compiled
>
> Code)
> at org.apache.tomcat.service.TcpConnectionThread.run(Compiled
> Code)
> at java.lang.Thread.run(Compiled Code)
>
>
> Thanks,
>
> John P.
>
> ==================================================================
> =========
> 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
===========================================================================
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
