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\OrgIdService.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\OrgIdService.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","Test1234","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","Test1234","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
