Try to import only what you need, not the whole package. It can help you to
trouble shoot this problem
-D
----- Original Message -----
From: "Kapadia Mitesh-C23457" <[EMAIL PROTECTED]>
Newsgroups: Struts
Sent: Sunday, August 24, 2003 11:32 AM
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\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
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
