the store proc works fine from oracle. i get data back as john,23,56,67,543 wells way, etc....
but when i am calling it from the bean i am getting an error back on TPRO_J= P_TPRO.executeQuery();
now do i call the name of the fields as in the database or use the variables to call. help please and i wonder if i should be giving alias for the columns
----------here is the bean-------------------------------------------- public Vector getRecordJ(String ProjectID){ ResultSet TPRO_J=null; try{ System.out.println("a"); CallableStatement P_TPRO=conOrcl.prepareCall("{call getJrecord(?)}"); //assign the ? to the argument passed System.out.println("b"); P_TPRO.setString(1,ProjectID); //execute the query System.out.println("c"); TPRO_J= P_TPRO.executeQuery(); //looping through the resultSet System.out.println("d"); while (TPRO_J.next()){ System.out.println("e");
//create an instance of the class Conn JItems = new Conn(); // set it to the Bean JItems.setCounty(TPRO_J.getString("county")); JItems.setCountyPct(TPRO_J.g etInt("county_pct")); JItems.setexistingLane(TPRO_J.getInt("existing_lane_cnt")) ; JItems.setproposed_lane(TPRO_J.getInt("proposed_lane_cnt")); JItems.setcomnt(T PRO_J.getString("comnt")); JItems.setcomntType(TPRO_J.getString("comnt_typ")); / /add the object to the vector V_itemsJ.addElement(JItems); }
Previous Topic
