aspose file tools*
The moose likes JSP and the fly likes tomcat jsp question to ask Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "tomcat jsp question to ask" Watch "tomcat jsp question to ask" New topic
Author

tomcat jsp question to ask

albert sie
Ranch Hand

Joined: Jan 15, 2006
Posts: 108
my problem is i have three classes file that all is javabean package file
which is bgoc, common, mrs.
when i run on the tomcat 5.5, error detected on my few of jsp file. the error
detected is like this:
"org.apache.jasper.JasperException: Cannot find any information on property
'EmpName' in a bean of type 'common.InfoBean'"

is it the page cannot get my javabean file? i put the javabean file in the
$CATALINA_HOME$/common/classes is it the right way?
how can i make the system can detect my javabean file?

hope those the expert can give the way to solve this problem.... thank you

regards,
albert


JAVA the only can called technology
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14688
    
  16

Could you please post your jsp:useBean and jsp:getProperty tags ?
(the ones where you are using common.InfoBean)
You may have misstyped EmpName with empName.


[My Blog]
All roads lead to JavaRanch
albert sie
Ranch Hand

Joined: Jan 15, 2006
Posts: 108
<jsp:useBean id="info" class = "common.InfoBean" scope="request"/>
<jsp:getProperty name="info" property="EmpName" />
this is my bean file:
package common;

public class InfoBean {
private String employeeName;
private String onlineMrNo;
private String reqDate;
private String trckDesc;
private String authoriserName;
private String offlineMrNo;

public InfoBean(){}

public String getEmpName(){
return employeeName;
}

public void setEmpName(String employeeName){
this.employeeName = employeeName;
}

public String getAuthoriser(){
return authoriserName;
}

public void setAuthoriser(String authoriserName){
this.authoriserName = authoriserName;
}

public String getTrackDescription(){
return trckDesc;
}

public void setTrackDescription(String trckDesc){
this.trckDesc = trckDesc;
}

public String getReqDate(){
return reqDate;
}

public void setReqDate(String reqDate){
this.reqDate = reqDate;
}

public String getOnlineMR() {
return onlineMrNo;
}

public void setOnlineMr(String onlineMrNo) {
this.onlineMrNo = onlineMrNo;
}

public String getOfflineMR(){
return offlineMrNo;
}
public void setOfflineMR(String offlineMrNo){
this.offlineMrNo = offlineMrNo;
}
}



can you help me to solve out.
another situation all my page i put inside the resin server to run but no such problem occur by using resin server. but the error occur when i using tomcat to run my jsp page. is it something not compatible in tomcat and how to solve it? thank for ur help...

regards,
albert
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14688
    
  16

You should access the employee name property via :
<jsp:getProperty name="info" property="empName" />
not
<jsp:getProperty name="info" property="EmpName" />

Try to follow the JavaBeans' naming rules too.
For the sake of readability.
I mean having :
String empName;
String getEmpName();
void setEmpName(String empName);
albert sie
Ranch Hand

Joined: Jan 15, 2006
Posts: 108
ya, this one solve my problem thank you
but one of my page hav another problem which is:
org.apache.jasper.JasperException: Unable to compile class for JSP

actually what is this error talking about???
Christophe Verré
Sheriff

Joined: Nov 24, 2005
Posts: 14688
    
  16

Could you post the rest of the error message ?
albert sie
Ranch Hand

Joined: Jan 15, 2006
Posts: 108
i found that three problem of the unable to compile jsp class

that's:An error occurred at line: 219 in the jsp file: /mrs/mr/preview.jsp
Generated servlet error:
The method display_on_mr(String, String, int) in the type dbs_connection is not applicable for the arguments (String, String, int, int, String, String)

An error occurred at line: 219 in the jsp file: /mrs/mr/preview.jsp
Generated servlet error:
The method display_all_on_mr(String, String, String, String) in the type dbs_connection is not applicable for the arguments (String, String, String, String, int, String, String)

An error occurred at line: 290 in the jsp file: /mrs/mr/preview.jsp
Generated servlet error:
The method countForTotalReject(Vector) is undefined for the type dbs_connection

this is my bean file:
package mrs.PrintingManager;
import java.sql.*;
import java.lang.String;
import java.io.*;
import java.util.*;
import java.text.*;

public class dbs_connection{

private Vector group_format_date1 = new Vector();
private Vector group_format_date2 = new Vector();
private Vector group_desc_date = new Vector();
private Vector group_asdesc_date = new Vector();
private Vector group_desc_mr = new Vector();
private Vector group_asdesc_mr = new Vector();

/*****************************************************************************************************************************/
private Vector company = new Vector();
private Vector online = new Vector();
private Vector offline = new Vector();
private Vector sub = new Vector();
private Vector requester = new Vector();
private Vector request_date = new Vector();
private Vector cost = new Vector();
private Vector la = new Vector();
private Vector project = new Vector();

/*****************************************************************************************************************************/
private Vector material = new Vector();
private Vector extra = new Vector();
private Vector quantity =new Vector();
private Vector um =new Vector();
private Vector price = new Vector();
private Vector expect_date = new Vector();
private Vector delivery_date = new Vector();
private Vector purpose = new Vector();
private Vector remark = new Vector();
private Vector store_mat = new Vector();

/*****************************************************************************************************************************/
private Vector approved1 = new Vector();
private Vector approved2 = new Vector();
private Vector approved3 = new Vector();
private Vector bottom = new Vector();

/*****************************************************************************************************************************/

//database connection
public Connection get_connection(){
try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/mrs";
Connection conn = DriverManager.getConnection(url);
return (conn);
}
catch(Exception e){
System.out.println("Error : " + e.toString() + e.getMessage());
return(null);
}
}

/*****************************************************************************************************************************/

//format asdenc date
public Vector format_date1(){
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String date_format = "SELECT mrh_req_dte FROM mrrqhf WHERE mrh_sts = 'A' GROUP BY mrh_req_dte ORDER BY mrh_req_dte DESC";
ResultSet rs_format_date = stmt.executeQuery(date_format);
String capture_format_date;
while(rs_format_date.next()){
java.util.Date format_date = rs_format_date.getDate("mrh_req_dte");
SimpleDateFormat simple_date = new SimpleDateFormat("dd/MM/yyyy");
capture_format_date = simple_date.format(format_date);
this.group_format_date1.addElement(capture_format_date);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
System.out.println("SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState());
}
return(this.group_format_date1);
}

/*****************************************************************************************************************************/

//retrieve desc date
public Vector date_desc_order(){
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String date_desc = "SELECT mrh_req_dte FROM mrrqhf WHERE mrh_sts = 'A' GROUP BY mrh_req_dte ORDER BY mrh_req_dte DESC";
ResultSet rs_desc_date = stmt.executeQuery(date_desc);
String capture_desc_date;
this.group_desc_date = new Vector();
while(rs_desc_date.next()){
capture_desc_date = rs_desc_date.getString("mrh_req_dte");
this.group_desc_date.addElement(capture_desc_date);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
System.out.println("SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState());
}
return(this.group_desc_date);
}

//retrieve desc MR
public Vector mr_desc_order(){
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String mr_desc = "SELECT mrh_req_num FROM mrrqhf GROUP BY mrh_req_num ORDER BY mrh_req_num DESC";
ResultSet rs_desc_mr = stmt.executeQuery(mr_desc);
String capture_desc_mr;
this.group_desc_mr = new Vector();
while(rs_desc_mr.next()){
capture_desc_mr = rs_desc_mr.getString("mrh_req_num");
this.group_desc_mr.addElement(capture_desc_mr);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
System.out.println("SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState());
}
return(this.group_desc_mr);
}

/*****************************************************************************************************************************/

//2nd part rice
public Vector display_price(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String price = "SELECT mrd_list_prc FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_ln_num";
ResultSet rs_price = stmt.executeQuery(price);
this.price = new Vector();
while(rs_price.next()){
capture = rs_price.getString("mrd_list_prc");
this.price.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.price);
}
//2nd part elivery date
public Vector display_delivery_date(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String delivery_date = "SELECT mrd_due_dte FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_ln_num";
ResultSet rs_delivery_date = stmt.executeQuery(delivery_date);
this.delivery_date = new Vector();
while(rs_delivery_date.next()){
java.util.Date del = rs_delivery_date.getDate("mrd_due_dte");
SimpleDateFormat simple2 = new SimpleDateFormat("dd/MM/yyyy");
capture = simple2.format(del);
this.delivery_date.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.delivery_date);
}

//2nd part urpose
public Vector display_purpose(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String purpose = "SELECT mrd_purpose FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_ln_num";
ResultSet rs_purpose = stmt.executeQuery(purpose);
this.purpose = new Vector();
while(rs_purpose.next()){
capture = rs_purpose.getString("mrd_purpose");
this.purpose.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.purpose);
}

//2nd part:remark
public Vector display_remark(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String remark = "SELECT mrd_rmks FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_ln_num";
ResultSet rs_remark = stmt.executeQuery(remark);
this.remark = new Vector();
while(rs_remark.next()){
capture = rs_remark.getString("mrd_rmks");
this.remark.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.remark);
}

//2nd part:expected date
public Vector display_expect_date(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String expect_date = "SELECT mrd_delvry_instr FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts='A' ORDER BY mrd_req_ln_num";
ResultSet rs_expect_date = stmt.executeQuery(expect_date);
this.expect_date = new Vector();
while(rs_expect_date.next()){
capture = rs_expect_date.getString("mrd_delvry_instr");
this.expect_date.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.expect_date);
}

//2nd part:um
public Vector display_um(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String um = "SELECT mrd_um FROM mrrqdf, mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_num";
ResultSet rs_um = stmt.executeQuery(um);
this.um = new Vector();
while(rs_um.next()){
capture = rs_um.getString("mrd_um");
this.um.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.um);
}

//2nd part:extra material
public Vector display_extra(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String extra = "SELECT in_desc_2 FROM mrrqdf, mrrqhf, inmast WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' AND mrd_item_num = in_num ORDER BY mrd_req_ln_num";
ResultSet rs_extra = stmt.executeQuery(extra);
this.extra = new Vector();
while(rs_extra.next()){
capture = rs_extra.getString("in_desc_2");
this.extra.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.extra);
}

//2nd part:quantity
public Vector display_qty(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String qty = "SELECT mrd_qty FROM mrrqhf, mrrqdf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' ORDER BY mrd_req_ln_num";
ResultSet rs_qty = stmt.executeQuery(qty);
this.quantity = new Vector();
while(rs_qty.next()){
capture = rs_qty.getString("mrd_qty");
this.quantity.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.quantity);
}

//2nd part:material
public Vector display_material(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String material = "SELECT in_desc_1 FROM mrrqdf, mrrqhf, inmast WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_num = mrd_req_num AND mrd_req_sts = 'A' AND mrd_item_num = in_num ORDER BY mrd_req_ln_num";
ResultSet rs_material = stmt.executeQuery(material);
this.material = new Vector();
while(rs_material.next()){
capture = rs_material.getString("in_desc_1");
this.material.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(this.material);
}

/*****************************************************************************************************************************/

//1st part:company name
public String display_company(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String company = "SELECT sdet_alpha_srch FROM mrrqhf, sysdet WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_co_no = sdet_co_no ";
ResultSet rs_company = stmt.executeQuery(company);
while(rs_company.next()){
capture = rs_company.getString("sdet_alpha_srch");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return(capture);
}

//1st part ffline Mr
public String display_off_mr(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String offline = "SELECT mrh_mr_num FROM mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' ";
ResultSet rs_offline = stmt.executeQuery(offline);
while(rs_offline.next()){
capture = rs_offline.getString("mrh_mr_num");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part roject description
public String display_proj_desc(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String project = "SELECT ps_desc FROM mrrqhf, poshp WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_proj_cde = ps_cde ";
ResultSet rs_project = stmt.executeQuery(project);
while(rs_project.next()){
capture = rs_project.getString("ps_desc");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part:cost center
public String display_cost(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String cost = "SELECT ps_desc FROM mrrqhf, poshp WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_proj_cde = ps_cde";
ResultSet rs_cost = stmt.executeQuery(cost);
while(rs_cost.next()){
capture = rs_cost.getString("ps_desc");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part:requester
public String display_requester(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String requester = "SELECT em_name FROM mrrqhf, emmast WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_req_by = em_num";
ResultSet rs_requester = stmt.executeQuery(requester);
while(rs_requester.next()){
capture = rs_requester.getString("em_name");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part:requested date
public String display_req_date(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String request_date = "SELECT mrh_req_dte FROM mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' ";
ResultSet rs_req_date = stmt.executeQuery(request_date);
while(rs_req_date.next()){
java.util.Date req1 = rs_req_date.getDate("mrh_req_dte");
SimpleDateFormat simple = new SimpleDateFormat("dd/MM/yyyy");
capture = simple.format(req1);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part:la no
public String display_la(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String la_no = "SELECT mrh_la_no FROM mrrqhf WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' ";
ResultSet rs_la = stmt.executeQuery(la_no);
while(rs_la.next()){
capture = rs_la.getString("mrh_la_no");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part:sub contractor
public String display_sub(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String sub = "SELECT pv_supl_nme FROM mrrqhf, povend WHERE mrh_req_num = '"+wat+"' AND mrh_sts = 'A' AND mrh_supl_cde = pv_supl_cde ";
ResultSet rs_sub = stmt.executeQuery(sub);
while(rs_sub.next()){
capture = rs_sub.getString("pv_supl_nme");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//1st part nline mr
public Vector display_on_mr(String date1, String date2){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String online = "SELECT mrh_req_num FROM mrrqhf WHERE mrh_sts = 'A' AND mrh_req_dte BETWEEN '"+date1+"' AND '"+date2+"' ORDER BY mrh_req_num ";
ResultSet rs_online = stmt.executeQuery(online);
this.online = new Vector();
while(rs_online.next()){
capture = rs_online.getString("mrh_req_num");
this.online.addElement(capture);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (this.online);
}

/*****************************************************************************************************************************/

//request, approved description
public String find1(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String approved = "select dfk_track_desc, em_name, dff_ent_dte from emmast, dftrck, dfdflw, dftran" +
" where dff_track_num != '1' and dff_auth_emp_id = em_num and dft_ref_no = '"+wat+"' and dfk_track_num = dff_track_num and dff_seq_no = dft_ref_no and dff_track_sts = 'A' group by dff_track_num, dff_seq_no";
ResultSet rs_approved1 = stmt.executeQuery(approved);
while(rs_approved1.next()){
capture = rs_approved1.getString("dfk_track_desc");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//approver, request name
public String find2(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String approved = "select dfk_track_desc, em_name, dff_ent_dte from emmast, dftrck, dfdflw, dftran" +
" where dff_track_num != '1' and dff_auth_emp_id = em_num and dft_ref_no = '"+wat+"' and dfk_track_num = dff_track_num and dff_seq_no = dft_ref_no and dff_track_sts = 'A' group by dff_track_num, dff_seq_no";
ResultSet rs_approved2 = stmt.executeQuery(approved);
while(rs_approved2.next()){
capture = rs_approved2.getString("em_name");
}
stmt.close();
newconn.close();
}
catch (SQLException s){
capture = "SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState();
}
return (capture);
}

//format bottom date
public String format_bottom(String wat){
String capture = "no data";
try{
Connection newconn = get_connection();
Statement stmt = newconn.createStatement();
String bot = "select dfk_track_desc, em_name, dff_ent_dte from emmast, dftrck, dfdflw, dftran" +
" where dff_track_num != '1' and dff_auth_emp_id = em_num and dft_ref_no = '"+wat+"' and dfk_track_num = dff_track_num and dff_seq_no = dft_ref_no and dff_track_sts = 'A' group by dff_track_num, dff_seq_no";
ResultSet rs_bottom = stmt.executeQuery(bot);
while(rs_bottom.next()){
java.util.Date bottom_date = rs_bottom.getDate("dff_ent_dte");
SimpleDateFormat simple_bottom = new SimpleDateFormat("dd/MM/yyyy");
capture = simple_bottom.format(bottom_date);
}
stmt.close();
newconn.close();
}
catch (SQLException s){
System.out.println("SQL Error: " + s.toString() + "" + s.getErrorCode() + " " + s.getSQLState());
}
return(capture);
}

}
this is the line come out the problem:

get_online = printing.display_on_mr(conditionSelect1,conditionSelect2,condition,curStatus,typeCondition,compemployeeId);
else
get_online = printing.display_all_on_mr(date1,date2,online1,online2,curStatus,typeCondition,compemployeeId);


if(curStatus == 2)// record rejected
countForReject = printing.countForTotalReject(get_online);
else if(curStatus == 5)// record rejected
countForReject = printing.countForTotalReject(get_online);

thank you

regards,
albert
albert sie
Ranch Hand

Joined: Jan 15, 2006
Posts: 108
i already solve that problem. just the internal problem encounter.
thank you Satou kurinosuke
can u giv me you e-mail and can we be a fren where you come from??
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: tomcat jsp question to ask