> I've been trying to compile my BLB (Business Logic Bean) and have been
> getting errors during compilation. I haven't a clue as to how I could
> debug this. Any assistance would be appreciated.
>
> Thanks in advance.
>
> - Mitesh
>
> Error Messages during compilation:
>
> [javac] Compiling 2 source files to
> C:\jakarta-tomcat-4.1.27\webapps\benchmark\WEB-INF\classes
> [javac]
> C:\jakarta-tomcat-4.1.27\webapps\benchmark\WEB-INF\src\net\reumann\OrgIdSe
> rvice.java:56: stmt is already defined in execute(net.reumann.DataHash)
> [javac] Statement stmt =
> conn.createStatement();
> [javac] ^
> [javac]
> C:\jakarta-tomcat-4.1.27\webapps\benchmark\WEB-INF\src\net\reumann\OrgIdSe
> rvice.java:57: rs is already defined in execute(net.reumann.DataHash)
> [javac] ResultSet rs =
> stmt.executeQuery("SELECT FACIL_ID, FACIL_NAME, FACIL_NAME_SHORT, ORG_ID
> FROM FACILITY WHERE FACIL_ID = '" + facilId + "'");
> [javac] ^
> [javac] 2 errors
>
> Here is the code from my BLB:
>
> package net.reumann;
>
> import java.io.*;
> import java.util.ArrayList;
> import javax.servlet.*;
> import javax.servlet.http.*;
> import java.sql.*;
> import javax.sql.*;
> import net.reumann.*;
> import org.apache.struts.action.Action;
> import org.apache.struts.action.ActionForward;
> import org.apache.struts.action.ActionMapping;
> import org.apache.struts.action.ActionForm;
> import org.apache.log4j.*;
> import org.apache.commons.beanutils.BeanUtils;
>
>
> public class OrgIdService implements Serializable {
>
> //Declare and initialize variables
> Connection conn = null;
> Statement stmt = null;
> ResultSet rs = null;
> ArrayList facilList = new ArrayList();
>
> //The execute() method of OrgIdService is called by OrgIdAction to
> execute a query against the SS Test DB
> public ArrayList execute(DataHash beanHash) {
>
> //Get mode from DataHash
> int mode = beanHash.getMode();
>
> try{
> switch (mode) {
> case 0:
>
> Class.forName("oracle.jdbc.driver.OracleDriver");
> conn =
> DriverManager.getConnection("jdbc:oracle:thin:@sources:1521:TEST","Test123
> 4","Test1234");
> Statement stmt =
> conn.createStatement();
> ResultSet rs =
> stmt.executeQuery("SELECT DISTINCT FACIL_ID FROM FACILITY");
>
> //Read ResultSet into instance of
> FacilBean and add to facilList Array object
> while (rs.next()) {
> FacilBean facil = new
> FacilBean();
>
> facil.setFacilId(rs.getString("FACIL_ID"));
> facilList.add(facil);
> }
>
> //Close ResultSet and Connection
> objects
> rs.close();
> conn.close();
> case 1:
> //Extract the facilId from the
> DataHash to query the FACILITY table
> String facilId = (String)
> beanHash.get("FacilId");
>
>
> Class.forName("oracle.jdbc.driver.OracleDriver");
> conn =
> DriverManager.getConnection("jdbc:oracle:thin:@sources:1521:TEST","Test123
> 4","Test1234");
> Statement stmt =
> conn.createStatement();
> ResultSet rs =
> stmt.executeQuery("SELECT FACIL_ID, FACIL_NAME, FACIL_NAME_SHORT, ORG_ID
> FROM FACILITY WHERE FACIL_ID = '" + facilId + "'");
>
> //Read ResultSet into instance of
> FacilBean and add to facilList Array object
> while (rs.next()) {
> FacilBean facil = new
> FacilBean();
>
> facil.setFacilId(rs.getString("FACIL_ID"));
>
> facil.setFacilName(rs.getString("FACIL_NAME"));
>
> facil.setFacilName(rs.getString("FACIL_NAME_SHORT"));
>
> facil.setOrgId(rs.getString("ORG_ID"));
> facilList.add(facil);
> }
>
> //Close ResultSet and Connection
> objects
> rs.close();
> conn.close();
> default:
> return null;
> }//end Switch
> }//end try
> catch (Exception e) {
> return null;
> e.printStackTrace();
> }//end catch
>
> //Return facilList Array Object to OrgIdAction
> return facilList;
> }//end Execute () method
> }//end class
