Sorry about the re-post just that I didn't put down the right subject
:-)
Hi,
I was looking through this code(from gatto@widesoft) , and was
wondering where the catch code would go.
I am a newcomer to Java and am not sure if by having the throws clause
is as efficient/bad/or same as the try/catch syntax.
Would my code see below actually catch an SQL exception or not?
I was wondering you could shed some light on the matter for me please.
public class newlite extends HttpServlet {
public void dostuff (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException, SQLException {
Connection con = null;
Statement stmt = null;
CODE
return;
}
finally {
if (stmt != null) stmt.close(); if (con != null) con.close();
}
-----Original Message-----
From: Rogerio Meneguelli Gatto [SMTP:[EMAIL PROTECTED]]
Sent: Monday, February 22, 1999 9:45 PM
To: [EMAIL PROTECTED]
Subject: Re: JDBC & Oracle - max. open cursors exceeded
Hi guys,
We've been using, very succesfully, this strategy:
public void foo()
throws SQLException {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = getConnection();
stmt = conn.createStatement();
...
return;
} finally {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (conn != null) conn.close();
}
}
This guarantees that no connection, statement, or resultset will
remain open, regardless of exceptions or returns.
Regards,
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 Rhys
> Lewis
> Sent: Monday, February 22, 1999 6:17 PM
> To: [EMAIL PROTECTED]
> Subject: Re: JDBC & Oracle - max. open cursors exceeded
>
>
> Yes - I had this problem when I was not closing connections and
result
> sets properly.
>
> Rhys Lewis
>
> -----Original Message-----
> From: shaoming [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 22, 1999 2:44 PM
> Subject: JDBC & Oracle - max. open cursors exceeded
>
>
> Hi!
>
> I'm writing a servlet which, using JDBC, connect to a Oracle 8 DB
> (NT platform) to insert, update and delete records.
>
> It works fine for a while. After long usage or multiple user
access,
> the error
>
> "SQLException - ORA-01000: maximum open cursors exceeded"
>
> is shown.
>
> Anyone has this same problem? Please help.
>
> Thanks,
> /shaoming
>
> ______________________________________________________________
> _____________
> 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
___________________________________________________________________________
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
