Sam, sorry about replying only now, it seems that I've put you into some confusion...
1. The 'throws' clause tells the compiler that the declaring method may throw that
type of exception. If you plan to catch it, remove the throws.
2. The syntax for the try/catch/finally structure is:
try {
...
} catch (MyException e) {
...
} catch (OnotherException e) {
...
} finally {
...
}
On your specific case, let the code be:
public void dostuff (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
Connection con = null;
Statement stmt = null;
try {
//CODE
return;
} catch (SQLException e) {
//CODE
} finally {
if (stmt != null) stmt.close();
if (con != null) con.close();
}
}
The 'finally' code will get executed in any situation, including return's and
exceptions.
[]'s
Rog�rio Gatto
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's
> Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Sam
> Rose
> Sent: Friday, February 26, 1999 7:09 AM
> To: [EMAIL PROTECTED]
> Subject: Help please - as I'm going crazy
>
>
> Please could someone point out to me exactly where I am going wrong
> with this code. I am trying to put in a finally clause, but it doesn't
> compile, I have tried just about everything.
>
> I would be very grateful if someone could tell me where exactly I'm
> going wrong in my code.
>
>
>
> import java.io.*;
> import java.util.*;
> import java.sql.*;
> import javax.servlet.*;
> import javax.servlet.http.*;
>
> public class newlite extends HttpServlet {
>
> public void dostuff (HttpServletRequest req,
> HttpServletResponse res)
> throws SQLException, ServletException, IOException {
>
> HttpSession tsession=req.getSession(true);
> res.setContentType("text/html");
> PrintWriter os=res.getWriter();
>
> try { Class.forName( "oracle.jdbc.driver.OracleDriver" );
> os.println("<p>");
> }
> catch (java.lang.ClassNotFoundException e) {
> os.print("ClassNotFound: ");
> os.println(e.getMessage());
> }
> try {
> con = DriverManager.getConnection();
> stmt = con.createStatement();
>
> }//endtry
>
> catch (java.sql.SQLException ex) {
> os.println("SQLExcption: " + ex.getMessage());
> }//endcatch
>
> finally {
> if (con != null) {
> con.close(); }//endif
> if (stmt != null) {
> stmt.close();}//endif
> }//endfinally
>
>
> }//end dostuff
>
> public void doGet (HttpServletRequest req,
> HttpServletResponse res)
> throws ServletException, IOException {
> dostuff(req, res);
> }
>
> public void doPost (HttpServletRequest req,
> HttpServletResponse res)
> throws ServletException, IOException {
> dostuff(req, res);
> }
> }//end
>
> ______________________________________________________________
> _____________
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
