Re: Java Question

[Mark Lowe]

Read the messages its telling you what's going on..

You've got 2 errors..

1. stmt is already defined
2. that rs is already defined
I don't know how much simpler this could be..

On Sunday, August 24, 2003, at 07:32 PM, Kapadia Mitesh-C23457 wrote:

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","Tes 
t123
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","Tes 
t123
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]