Hi there:
I'm a novice in
Java and my application keeps crashing with the same error. It looke I'm not closing something, and I just can't find the fix.
This is a sample of the code. Please, please someone tell me what is wrong with it:
<%@ page import = "javax.naming.*"%>
<%@ page import = "java.io.*"%>
<%@ page import = "java.lang.*"%>
<%@ page import = "java.sql.*"%>
<%@ page import = "javax.sql.*"%>
<%
String sMode = "";
String sSiteID = "";
String sAreaID = "";
String sAreaName = "";
String sJSP_Action= "";
if (request.getParameter("MODE") != null) {
sMode= request.getParameter("MODE").toString();
}else {
sMode= "0";
}
if (request.getParameter("fld_SiteID") != null) {
sSiteID= request.getParameter("fld_SiteID").toString();
}else {
sSiteID= "0";
}
if (request.getParameter("fld_AreaID") != null) {
sAreaID= request.getParameter("fld_AreaID").toString();
}else {
sAreaID= "0";
}
if (request.getParameter("txt_AreaName") != null) {
sAreaName= request.getParameter("txt_AreaName").toString();
}else {
sAreaName= "";
}
if (request.getParameter("JSP_ACTION") != null) {
sJSP_Action= request.getParameter("JSP_ACTION").toString();
}else {
sJSP_Action= "";
}
InitialContext ctxt = new InitialContext();
DataSource ds = (DataSource) ctxt.lookup("java
EMO_CARACAS");
Connection con = ds.getConnection();
Connection con0 = ds.getConnection();
Connection con1 = ds.getConnection();
Statement stmt = null;
ResultSet rs = null;
String sSQL = "";
int rows= 0;
try {
if (sJSP_Action.equals("Aceptar") || sJSP_Action.equals("Click_Accept")){
if (sMode.equals("ADDAREA")){
sSQL = "INSERT INTO tbl_Areas (SiteID, AreaName)";
sSQL = sSQL + " VALUES(" + sSiteID + ",'" + sAreaName + "')";
}else{
sSQL = "UPDATE tbl_Areas ";
sSQL = sSQL + " SET AreaName='"+ sAreaName+ "'";
sSQL = sSQL + " WHERE ID="+ sAreaID;
}
out.print(sSQL);
stmt= con.createStatement();
rows= stmt.executeUpdate (sSQL);
if(rs!=null) rs.close();
if(stmt!=null) stmt.close();
if(con!=null) con.close();
}else if (sJSP_Action.equals("Borrar") || sJSP_Action.equals("Click_Delete")){
sSQL = "DELETE FROM tbl_Areas WHERE ID=" + sAreaID;
stmt= con.createStatement();
rows= stmt.executeUpdate (sSQL);
if(rs!=null) rs.close();
if(stmt!=null) stmt.close();
if(con!=null) con.close();
sSQL = "DELETE FROM tbl_Rooms WHERE AreaID=" + sAreaID;
stmt= con0.createStatement();
rows= stmt.executeUpdate (sSQL);
if(rs!=null) rs.close();
if(stmt!=null) stmt.close();
if(con0!=null) con0.close();
sSQL = "DELETE FROM tbl_Elements WHERE AreaID=" + sAreaID;
stmt= con1.createStatement();
rows= stmt.executeUpdate (sSQL);
if(rs!=null) rs.close();
if(stmt!=null) stmt.close();
if(con1!=null) con1.close();
}
} finally {
con1.close();
con0.close();
con.close();
}
response.sendRedirect("survey_areas_list.jsp?SiteID=" + sSiteID);
%>