Since you have already Defined the conn and stmt you no need to defined
again .
public class OrgIdService implements Serializable {
//Declare and initialize variables
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ArrayList facilList = new ArrayList();
Just remove Statement and ResultSet from line 56 and 57
Compile again it will work fine.
Eg :
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT
Thanks
Nazeer
-----Original Message-----
From: Kapadia Mitesh-C23457 [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 24, 2003 2:21 PM
To: [EMAIL PROTECTED]
Subject: Java Question
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\OrgId
Service.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\OrgId
Service.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","Test1
234","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","Test1
234","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
