hi,
Yes the class fast_procRow has the method getRowsWOPackGenerated (java.sql.Connection,java.lang.String,java.lang.String,java.lang.String). Here is the code for the class
package com.comcom.pubzone;
import com.comcom.Database.*;
import com.comcom.pubzone.tables.*;
import java.io.*;
import java.sql.*;
import java.util.*;
public class fast_procRow {
public fast_procRow() {}
public ArrayList getRowsWOPackGenerated(Connection connect,
String project_code, String pub_no, String rev_no) {
ArrayList al = new ArrayList();
StringBuffer query = new StringBuffer(1400);
query.append("select NVL(primkey,0) primkey,project_code,NVL(pack_list,0) pack_list,wip_date,wip_time,back_date,back_time,");
query.append("jcom_date,jcom_time,hist_date,hist_time,process_status,prev_status,inv_pull_code,");
query.append("NVL(order_number,0) order_number,order_date,order_recd_by,order_ref,cust_cci_id,order_ref2,order_ref3,");
query.append("order_ref4,prefix_over_code,prefix_over_flag,po_numb,order_op_code,cust_ship_via,");
query.append("NVL(seq_no,0) seq_no,pub_no,rev_no,desc,NVL(qty,0) qty,NVL(price,0) price,NVL(line_cost,0) line_cost,NVL(handle_cost,0) handle_cost,NVL(adjust_amt,0) adjust_amt,NVL(ship_cost,0) ship_cost,");
query.append("NVL(est_ship_cost,0) est_ship_cost,zone,NVL(weight,0) weight,NVL(tax_amt,0) tax_amt,cust_paymnt_type,taxable,cust_ship_flag,");
query.append("cust_ship_date,NVL(pub_docs8,0) pub_docs8,NVL(pub_sheets8,0) pub_sheets8,NVL(pub_docs11x17,0) pub_docs11x17,NVL(pub_sheets11x17,0) pub_sheets11x17,NVL(pub_docs11x22,0) pub_docs11x22,");
query.append("NVL(pub_sheets11x22,0) pub_sheets11x22,NVL(pub_docs17x24,0) pub_docs17x24,NVL(pub_sheets17x24,0) pub_sheets17x24,NVL(pub_docs5x8,0) pub_docs5x8,NVL(pub_sheets5x8,0) pub_sheets5x8,pub_tabs,");
query.append("pub_binding,pub_cover_spine,pub_foldouts,stock_at_cci,due_date,NVL(job_id,0) job_id,NVL(cci_order_number,0) cci_order_number,");
query.append("cybercash_order_id,NVL(invoice_no,0) invoice_no,kit_pub_no,kit_rev_no,NVL(original_line_item,0) original_line_item,NVL(order_proc_fee,0) order_proc_fee,");
query.append("division_num,branch_order_num,order_prefix_num,production_code,NVL(group_no,0) group_no,NVL(tax_pct,0) tax_pct,");
query.append("cust_bill_type,tax_exempt_no,NVL(containers,0) containers,NVL(qty_per_ctn,0) qty_per_ctn,NVL(cci_lookup,0) cci_lookup,NVL(line_item_no,0) line_item_no,");
query.append("pub_mast_type,jobid,NVL(allocated_qty,0) allocated_qty,NVL(shipped_qty,0) shipped_qty,NVL(backorder_qty,0) backorder_qty,process_date ,nvl(service_id, 0) service_id, shipper_number, consolodate, address_id ");
query.append("from ffdb1:fast_proc ");
query.append("where project_code = ? ");
query.append("and pub_no = ? ");
query.append("and rev_no = ? ");
query.append("and process_status in ('wip','pend') ");
query.append("and pack_list = 0 ");
query.append("order by 15,28");
try {
PreparedStatement pst = connect.prepareStatement(query.toString());
pst.setString(1, project_code);
pst.setString(2, pub_no);
pst.setString(3, rev_no);
ResultSet rs = pst.executeQuery();
while(rs.next()) {
fast_proc tmp = new fast_proc();
tmp.setPrimkey(rs.getInt("primkey"));
tmp.setProject_code(rs.getString("project_code"));
tmp.setPack_list(rs.getInt("pack_list"));
tmp.setWip_date(rs.getDate("wip_date"));
tmp.setWip_time(rs.getTime("wip_time"));
tmp.setBack_date(rs.getDate("back_date"));
tmp.setBack_time(rs.getTime("back_time"));
tmp.setJcom_date(rs.getDate("jcom_date"));
tmp.setJcom_time(rs.getTime("jcom_time"));
tmp.setHist_date(rs.getDate("hist_date"));
tmp.setHist_time(rs.getTime("hist_time"));
tmp.setProcess_status(rs.getString("process_status"));
tmp.setPrev_status(rs.getString("prev_status"));
tmp.setInv_pull_code(rs.getString("inv_pull_code"));
tmp.setOrder_number(rs.getInt("order_number"));
tmp.setOrder_date(rs.getDate("order_date"));
tmp.setOrder_recd_by(rs.getString("order_recd_by"));
tmp.setOrder_ref(rs.getString("order_ref"));
tmp.setCust_cci_id(rs.getString("cust_cci_id"));
tmp.setOrder_ref2(rs.getString("order_ref2"));
tmp.setOrder_ref3(rs.getString("order_ref3"));
tmp.setOrder_ref4(rs.getString("order_ref4"));
tmp.setPrefix_over_code(rs.getString("prefix_over_code"));
tmp.setPrefix_over_flag(rs.getString("prefix_over_flag"));
tmp.setPo_numb(rs.getString("po_numb"));
tmp.setOrder_op_code(rs.getString("order_op_code"));
tmp.setCust_ship_via(rs.getString("cust_ship_via"));
tmp.setSeq_no(rs.getInt("seq_no"));
tmp.setPub_no(rs.getString("pub_no"));
tmp.setRev_no(rs.getString("rev_no"));
tmp.setDesc(rs.getString("desc"));
tmp.setQty(rs.getInt("qty"));
tmp.setPrice(rs.getDouble("price"));
tmp.setLine_cost(rs.getDouble("line_cost"));
tmp.setHandle_cost(rs.getDouble("handle_cost"));
tmp.setAdjust_amt(rs.getDouble("adjust_amt"));
tmp.setShip_cost(rs.getDouble("ship_cost"));
tmp.setEst_ship_cost(rs.getDouble("est_ship_cost"));
tmp.setZone(rs.getString("zone"));
tmp.setWeight(rs.getDouble("weight"));
tmp.setTax_amt(rs.getDouble("tax_amt"));
tmp.setCust_paymnt_type(rs.getString("cust_paymnt_type"));
tmp.setTaxable(rs.getString("taxable"));
tmp.setCust_ship_flag(rs.getString("cust_ship_flag"));
tmp.setCust_ship_date(rs.getDate("cust_ship_date"));
tmp.setPub_docs8(rs.getInt("pub_docs8"));
tmp.setPub_sheets8(rs.getInt("pub_sheets8"));
tmp.setPub_docs11x17(rs.getInt("pub_docs11x17"));
tmp.setPub_sheets11x17(rs.getInt("pub_sheets11x17"));
tmp.setPub_docs11x22(rs.getInt("pub_docs11x22"));
tmp.setPub_sheets11x22(rs.getInt("pub_sheets11x22"));
tmp.setPub_docs17x24(rs.getInt("pub_docs17x24"));
tmp.setPub_sheets17x24(rs.getInt("pub_sheets17x24"));
tmp.setPub_docs5x8(rs.getInt("pub_docs5x8"));
tmp.setPub_sheets5x8(rs.getInt("pub_sheets5x8"));
tmp.setPub_tabs(rs.getString("pub_tabs"));
tmp.setPub_binding(rs.getString("pub_binding"));
tmp.setPub_cover_spine(rs.getString("pub_cover_spine"));
tmp.setPub_foldouts(rs.getString("pub_foldouts"));
tmp.setStock_at_cci(rs.getString("stock_at_cci"));
tmp.setDue_date(rs.getDate("due_date"));
tmp.setJob_id(rs.getInt("job_id"));
tmp.setCci_order_number(rs.getInt("cci_order_number"));
tmp.setCybercash_order_id(rs.getString("cybercash_order_id"));
tmp.setInvoice_no(rs.getInt("invoice_no"));
tmp.setKit_pub_no(rs.getString("kit_pub_no"));
tmp.setKit_rev_no(rs.getString("kit_rev_no"));
tmp.setOriginal_line_item(rs.getInt("original_line_item"));
tmp.setOrder_proc_fee(rs.getDouble("order_proc_fee"));
tmp.setDivision_num(rs.getString("division_num"));
tmp.setBranch_order_num(rs.getString("branch_order_num"));
tmp.setOrder_prefix_num(rs.getString("order_prefix_num"));
tmp.setProduction_code(rs.getString("production_code"));
tmp.setGroup_no(rs.getInt("group_no"));
tmp.setTax_pct(rs.getDouble("tax_pct"));
tmp.setCust_bill_type(rs.getString("cust_bill_type"));
tmp.setTax_exempt_no(rs.getString("tax_exempt_no"));
tmp.setContainers(rs.getInt("containers"));
tmp.setQty_per_ctn(rs.getInt("qty_per_ctn"));
tmp.setCci_lookup(rs.getInt("cci_lookup"));
tmp.setLine_item_no(rs.getInt("line_item_no"));
tmp.setPub_mast_type(rs.getString("pub_mast_type"));
tmp.setJobid(rs.getString("jobid"));
tmp.setAllocated_qty(rs.getInt("allocated_qty"));
tmp.setShipped_qty(rs.getInt("shipped_qty"));
tmp.setBackorder_qty(rs.getInt("backorder_qty"));
tmp.setProcess_date(rs.getDate("process_date"));
tmp.setService_id(rs.getInt("service_id"));
tmp.setShipper_number(rs.getString("shipper_number"));
tmp.setConsolodate(rs.getString("consolodate"));
tmp.setAddress_id(rs.getInt("address_id"));
al.add(tmp);
}
pst.close();
}
catch(SQLException ex) {
System.out.println(ex.getMessage());
}
return al;
}
}
The same code works fine in a different system which has Tomcat5.0 but not in our server.
Thanks
Viji