Sachin Negi

Winston Gutkowski wrote:Sachin,

Please don't post in all bold. It's equivalent to shouting!!! and is considered bad manners. I've removed yours this time and for more information, please check the EaseUp (←click) page.

Winston

Thanks Winston..i got it.. Cheerzz

Hello to all the ranchers, i am fairly new in java and currently working in Struts 1.3. My question is more related with java.
Following is the scenario and i am not sure regarding the best approach to be followed.

I want to make a error reporting functionality in my project where in I'm copying stacktrace and inserting it in the database's table say "errorlog" table with type of exception,date, user etc and other fields. But now what i have to do is :
I have to identify the package name, file, method and line number in which the exception occurred with the help of server logs that i have when exception occurs.
But the problem is that the log gives you the exception, file and the line number but it also contains errors that are not in my packages as in HttpServlet.service(HttpServlet.java:710) etc given below:


java.lang.NullPointerException
com.candidate.query.CandSearchAction.execute(CandSearchAction.java:34)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.proc ess(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

In above case, i got a null pointer exception in my CandSearchAction.java line number 34.
Now i want to know how to differentiate or extract only the line that points to my java/jsp file, so that i can filter them accordingly.

Can anyone please help regarding this situation or how to approach this problem.. is there any library that i can use or anything that could help me.
Waiting for a response that would help me.

Hello to all the ranchers, i am fairly new in java and currently working in Struts 1.3. My question is more related with java.
Following is the scenario and i am not sure regarding the best approach to be followed.

I want to make a error reporting functionality in my project where in I'm copying stacktrace and inserting it in the database's table say "errorlog" table with type of exception,date, user etc and other fields. But now what i have to do is :
I have to identify the package name, file, method and line number in which the exception occurred with the help of server logs that i have when exception occurs.
But the problem is that the log gives you the exception, file and the line number but it also contains errors that are not in my packages as in HttpServlet.service(HttpServlet.java:710) etc given below:


java.lang.NullPointerException
com.candidate.query.CandSearchAction.execute(CandSearchAction.java:34)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.proc ess(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

In above case, i got a null pointer exception in my CandSearchAction.java line number 34.
Now i want to know how to differentiate or extract only the line that points to my java/jsp file, so that i can filter them accordingly.

Can anyone please help regarding this situation or how to approach this problem.. is there any library that i can use or anything that could help me.
Waiting for a response that would help me.

i have a scenario in JSP where i have to make a combo with a list containing 10 items say 1,2,3.... 10. now i select a combo. I also need to provide an add button that will add another combo with same elements except the one being selected in previous combo.

eg- if 1st combo selected value is 1 then in the next combo i'll have the list as 2,3,4.....10 i.e, having 9 elements and so on. the user can add 10 combos like this, each combo having the items that haven't been previously selected.

can anyone help me with this???
thanks in advance !!!

Thanks for your reply mohana..can you provide me some example of this..where i have to create this session thing
i am aware about sessions in servlets where we make session attributes in web.xml but i am not sure about struts2...please help!!!
thanks and regards :-)

hello everyone..can anyone tell me how can i use value from one jsp to all the others!!
i have a scenario where i have made a form for registration that inputs the "Candidate Id" and inserts it in the database through action!! now i want to display this "candidate Id" in all many other Jsp pages..
how can i achieve this???
i have used : <s:textfield label="Candidate ID" name="beanContactDetail.X1CandidateId" value="%{beanbasicdetails.X1CandidateId}" readonly="true" />
it is displaying the Candidate Id in this jsp page only as its possible to do this on concurrent jsp pages ...how can i get this "Candidate Id" in other jsp pages as well???
Thanks in advance!!! :-)

hello to all the ranchers
I have done AJAX validation in Struts 2.3 successfully using the dojo pluging's <sx:submit> tag...but i have a requirement where i have to do validation in the form without refreshing the form fields without clicking the Submit button..how can i achieve this validation???
i'll be thankful if anyone can provide me with the details on how can i start this thing..
Thank you..

thanks for your reply mate but this will become more complex because i have to make so many such forms for my project..is this any other way!! why i cannot divide one form from the same jsp..???
thanks for your help...

I have made a form in struts2 and i just want its layout to have three division but its notw working...i have tried so many things with this..but i am unable to find the answer...can't i use the simple<div> tag inside <s:form> ...
what should i do..please help me..

registration.jsp :

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@taglib uri="/struts-tags" prefix="s"%> <%@taglib uri="/struts-dojo-tags" prefix="sx" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Registration page</title> </head> <body> <h1><span style="background-color:#F5F5F5">Registration</span> </h1> <s:form action="insert" > <h2>Personal Details</h2> <div align="left"> <s:textfield label="First Name" name="firstname" tooltip="Enter the First Name of Candidate" > <s:param name="labelcolspan" value="%{2}"/> <s:param name="inputcolspan" value="%{2}"/></s:textfield> <s:textfield name="middlename" label="Middle Name" > <s:param name="labelcolspan" value="%{2}"/> <s:param name="inputcolspan" value="%{2}"/></s:textfield> <s:textfield name="lastname" label="Last Name"/> <s:textfield name="fathername" label="Father's Name"/> <s:textfield name="mothername" label="Mother's Name"/> <s:textfield name="spousename" label="Spouse Name"/> </div> <br> <div > <sx:head cache="false" compressed="false" /> <sx:datetimepicker name="dateBirth" displayFormat="dd-MMM-yyyy" value="today" label="Select Date(dd-MMM-Year):"/> <s:textfield name="placeofbirth" label="Birth Place" /> <s:combobox list="candidatedetailslistlist" name="candidatedetails" label="Marital Status" headerValue="--- Please Select ---" headerKey="1" listKey="maritalstatuscode" listValue="maritalstatusname" /> <s:combobox list="religiondetailslistlist" name="religion" label="Religion" headerValue="--- Please Select ---" headerKey="1" listKey="religioncode" listValue="religionname" /> </div> <br> <div> <s:combobox list="employmentstatusdetailslistlist" name="employmentstatus" label="Employment Status" headerValue="--- Please Select ---" headerKey="1" listKey="employemntstatuscode" listValue="employmentstatusname" /> <s:combobox list="castedetailslistlist" name="caste" label="Caste" headerValue="--- Please Select ---" headerKey="1" listKey="castecode" listValue="castename" /> <s:radio label="Rural Urban" name="rural" list="ruralurbanlistlist.{ruralurbanname}"/> <s:textarea label="Address1" name="address1" cols="35" rows="3" /> <s:textarea label="Address2" name="address2" cols="35" rows="3" /> <s:textfield name="city" label="City"/> <s:textfield name="pincode" label="Pincode"/> <s:submit value="submit" name="submit" /> </div> </s:form> </body> </html>

Thanks for your help..i have changed this a little bit and have called the action from the the jsp in which i had made the menu aND ITS WORKING FINE FOR ME AND i have used the format like you have told me and its working...
Thanks for your help..

Hello to all the ranchers n greenhorns like me.. i am making a form in Struts2 that takes values from database..and i am having problem in combo-box..
here's the content of mu project that is related to the current problem ...

stuts.xml :

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" "http://struts.apache.org/dtds/struts-2.0.dtd"> <struts> <constant name="struts.devMode" value="true"></constant> <package name="Basic" extends="struts-default" namespace=""> <action name="hello" class="nic.action.MenuListAction" method="execute"> <result name="success" >menujsp.jsp</result> </action> <action name="regaction" class="nic.action.DatePickerAction" method="execute"> <result name="success" >registration.jsp</result> </action> <action name="maritalstat" class="nic.action.PersonalDetailsAction" method="executeMaritalstatus"> <result name="success" >registration.jsp</result> </action> </package> </struts>



MaritalStatusList.java

package nic.forms; public class MaritalStatusList { String code; String name; String acronym; public MaritalStatusList() { super(); } public MaritalStatusList(String code,String name,String acronym) { super(); this.code=code; this.name=name; this.acronym=acronym; } public String getCode() { System.out.println("\n Inside getCode of MaritalStatusList class in nic.forms"); return code; } public void setCode(String code) { System.out.println("\n Inside setCode of MaritalStatusList class in nic.forms"); this.code = code; } public String getName() { System.out.println("\n Inside getName of MaritalStatusList class in nic.forms"); return name; } public void setName(String name) { System.out.println("\n Inside setName of MaritalStatusList class in nic.forms"); this.name = name; } public String getAcronym() { System.out.println("\n Inside getAcronym of MaritalStatusList class in nic.forms"); return acronym; } public void setAcronym(String acronym) { System.out.println("\n Inside setAcronym of MaritalStatusList class in nic.forms"); this.acronym = acronym; } }


PersonalDetailsAction.java:

package nic.action; import java.util.List; import com.opensymphony.xwork2.ActionSupport; import nic.db.DAOPersonalDetails; import nic.forms.*; public class PersonalDetailsAction extends ActionSupport{ /** * */ private static final long serialVersionUID = 1L; private MaritalStatusList maritalstatuslist; private List<MaritalStatusList> maritalstatuslistlist; public MaritalStatusList getMaritalstatuslist() { return maritalstatuslist; } public void setMaritalstatuslist(MaritalStatusList maritalstatuslist) { this.maritalstatuslist = maritalstatuslist; } DAOPersonalDetails daopersonaldetails=new DAOPersonalDetails(); public String executeMaritalstatus() { maritalstatuslistlist=daopersonaldetails.fetchmaritalstatus(); return "success"; } public List<MaritalStatusList> getMaritalstatuslistlist() { return maritalstatuslistlist; } public void setMaritalstatuslistlist(List<MaritalStatusList> maritalstatuslistlist) { this.maritalstatuslistlist = maritalstatuslistlist; } }


DAOPersonalDetails.java:

package nic.db; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.*; import nic.forms.*; public class DAOPersonalDetails { public List<MaritalStatusList>fetchmaritalstatus() { try { System.out.println("\n Inside fetchmaritalstatus..."); Connection con=ConnectionProviderEEDB.getEEDBConnection(); PreparedStatement stmt=con.prepareStatement("select * from refmaritalstat"); System.out.println("\nstatement Prepared...."); ResultSet rs=stmt.executeQuery(); System.out.println("\nExecuting query of EEDB database..."); MaritalStatusList maritalstatuslist; List <MaritalStatusList> list=new ArrayList<MaritalStatusList>(); while(rs.next()) { maritalstatuslist=new MaritalStatusList(); System.out.println("Inside fetchmaritalstatus setting code as.."+rs.getString(1)); maritalstatuslist.setCode(rs.getString(1)); System.out.println("Inside fetchmaritalstatus setting name as.."+rs.getString(2)); maritalstatuslist.setName(rs.getString(2)); System.out.println("Inside fetchmaritalstatus setting acronym as.."+rs.getString(3)); maritalstatuslist.setAcronym(rs.getString(3)); list.add(maritalstatuslist); } return list; } catch(Exception e) { System.out.println(e); } return null; } }


registration.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@taglib uri="/struts-tags" prefix="s"%> <%@taglib uri="/struts-dojo-tags" prefix="sx" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Registration page</title></head> <h1><span style="background-color:#FFFFcc">Registration Form </span></h1> <h2>Personal Details</h2> <body> <s:form> <table border="1"> <s:textfield name="firstname" label="First Name" tooltip="Enter the First Name of Candidate"/> <s:textfield name="middlename" label="Middle Name" /> <s:textfield name="lastname" label="Last Name"/> <s:textfield name="fathername" label="Father's Name"/> <s:textfield name="mothername" label="Mother's Name"/> <s:textfield name="spousename" label="Spouse Name"/> <s:textfield name="mothername" label="Mother's Name"/> <s:action name="regaction" ></s:action> <sx:head cache="false" compressed="false" /> <sx:datetimepicker name="date1" displayFormat="dd-MMM-yyyy" value="today" label="Select Date(dd-MMM-Year):"/> <s:textfield name="placeofbirth" label="Birth Place" /> <s:action name="maritalstat" ></s:action> <s:combobox label="Marital Status" headerValue="--- Please Select ---" headerKey="1" list="maritalstatuslistlist.{name}" name="maritalstatuslistlist" /> <s:submit value="submit" name="submit" /> </table> </s:form> </body> </html>



now the problem is that when its nor displaying the combobox..but when i am using the config-browser to see the action..the whole page is displayed correctly with combobox having list containing "name" from the MaritalStatusList class with values from the database!!!

i am getting the following errors on log:

Feb 16, 2012 8:10:14 PM com.opensymphony.xwork2.util.logging.commons.CommonsLogger warn
WARNING: No configuration found for the specified action: '/registration.jsp' in namespace: ''. Form action defaulting to 'action' attribute's literal value.

Here i am getting all the statements of System.out.println();

Feb 16, 2012 8:10:14 PM com.opensymphony.xwork2.util.logging.commons.CommonsLogger warn
WARNING: Caught an exception while evaluating expression 'maritalstatuslistlist.{name}' against value stack
java.lang.NullPointerException

Feb 16, 2012 8:10:14 PM com.opensymphony.xwork2.util.logging.commons.CommonsLogger warn
WARNING: NOTE: Previous warning message was issued due to devMode set to true.
Feb 16, 2012 8:10:14 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet jsp threw exception
tag 'combobox', field 'list', name 'maritalstatuslistlist': You must specify a collection/array/map/enumeration/iterator. Example: people or people.{name} - [unknown location]


i think there is a problem with my jsp...please help me figure it out..

Thanks in advance n Cheerzz!!!

so how can i correct myself??? can i do changes in JSP so that i can get submenuTitle under the menuId for which it is associated???

Hello Joe Ess ...
i have tried the following changes in my classes:


in DAO.java i have added a function that executes the 2nd query for submenus...

public List<MenuList> fetchsubmenu() { try{ Connection conSubMenu=ConnectionProvider.getConnection(); PreparedStatement stmtSubMenu=conSubMenu.prepareStatement("select * from menu "); ResultSet rsSubMenu=stmtSubMenu.executeQuery(); MenuList submenulist; List<MenuList> sublist=new ArrayList<MenuList>(); while(rsSubMenu.next()) { submenulist=new MenuList(); submenulist.setSubmenuTitle(rsSubMenu.getString(3)); System.out.println("\ninside while of DAO,setting submenu title as... "+rsSubMenu.getString(3)+" " +submenulist.getSubmenuTitle()); sublist.add(submenulist); } System.out.println("DAO reurns list...is this list empty??? "+sublist.isEmpty()); return sublist; } catch(Exception e) { System.out.println(e); } return null; }



in MenuListAction class i have added :

private List<MenuList> sublistlist;

in execute method i hv added the following :
sublistlist=dao.fetchsubmenu(); and have added the getter n setter for the same... : public List<MenuList> getSublistlist() { return sublistlist; } public void setSublistlist(List<MenuList> sublistlist) { this.sublistlist = sublistlist; }


and have added hetters n setthers for submenuTitle in MenuList class :

public String getSubmenuTitle() { return submenuTitle; } public void setSubmenuTitle(String submenuTitle) { this.submenuTitle = submenuTitle; }




and menujsp as:





<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@taglib uri="/struts-tags" prefix="s"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Home</title> <style> body { background:#FFFFE0; } table{font-size:80%;} a{color:black;text-decoration:none;font:bold} a:hover{color:#606060} </style> <script type="text/javascript"> function showmenu(elmnt) { document.getElementById(elmnt).style.visibility="visible"; } function hidemenu(elmnt) { document.getElementById(elmnt).style.visibility="hidden"; } </script> </head> <body> <h1>Employment Exchange</h1> <table width="100%"> <tr bgcolor="#F4C430"> <s:iterator value="menulistlist"> <td onmouseover="showmenu('<s:property value="menuId"/>')" onmouseout="hidemenu('<s:property value="menuId"/>')"> <a href="#"><s:property value="menuTitle"/></a><br /> <table class="menu" id="<s:property value="menuId"/>" width="120"> <s:iterator value="sublistlist"> <tr><td class="menu" id="<s:property value="menuId"/>"><a href="/html/default.asp"><s:property value="submenuTitle"/></a></td></tr> </s:iterator></table> </td> </s:iterator> </tr> </table> </body> </html>



now i am getting the submenus...but the problem is that i am getting all the submenuTitles under every menuTitle... is there a way that i can get the value ftom the JSP n pass it the query as an action...for a particular menuId n then i can execute the query for that menuId...select * from menu where menu_id in (select menu_id from applicationmenu where application_id="for that menuId")

and then com back to second iterator n display submenuTitle for that menuId on mouseover event
or is there any other way to achieve what i am trying....

this is what i want my menu to show:

menuTitle;- (Regsitration) (Renewal) (EMI) when i'll do mouse over on them they will show

(Direct regist) (Renew Registration) (ER1 From)
(Re registration) (Record of Renewal) (ER2 From)

i've done this successfully in single JSP in which evrything resides in JSP,following is that code of JSP:

<%@ page language="java" import="java.sql.*" import="java.util.*" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <style> body{ background-image:ur(C:\indian-flag-12.gif) no-repeat ; font-family:arial;} table{font-size:80%;background:black} a{color:black;text-decoration:none;font:bold} a:hover{color:#606060} td.menu{background:lightgrey} table.menu { font-size:100%; position:absolute; visibility:hidden; } </style> <script type="text/javascript"> function showmenu(elmnt) { document.getElementById(elmnt).style.visibility="visible"; } function hidemenu(elmnt) { document.getElementById(elmnt).style.visibility="hidden"; } </script> </head> <body> <h3>EMPLOYMENT EXCHANGE Test Page</h3> <table width="100%"> <tr bgcolor="#FG8080"> <% Class.forName("org.postgresql.Driver"); Connection con=DriverManager.getConnection("jdbc:postgresql://localhost:5433/labway","postgres","sachin"); System.out.println("Connection with database established"); ResultSet rs=null; Statement stmt=con.createStatement(); ResultSet rs2=null; Statement stmt2=con.createStatement();try { rs=stmt.executeQuery("select * from application where application_id in (select distinct application_id from applicationmenu order by application_id)"); } catch(Exception e){ System.out.println("Exception in getDBResultSet " + e); e.printStackTrace(); } while(rs.next()) { System.out.println("Inside 1st while..."); String str=rs.getString(3); System.out.println("string is: "+str); %> <td onmouseover="showmenu('<%=rs.getString(1)%>')" onmouseout="hidemenu('<%=rs.getString(1)%>')"> <a href="/default.asp"><%=rs.getString(3)%></a><br /> <table class="menu" id="<%=rs.getString(1)%>" width="120"> <% System.out.println(rs.getString(3)); try { rs2=stmt2.executeQuery("select * from menu where menu_id in (select menu_id from applicationmenu where application_id='"+rs.getString(1)+"')"); } catch(Exception e){ System.out.println("Exception in getDBResultSet " + e); e.printStackTrace(); } { while(rs2.next()) { System.out.println("Inside Rs 2"); %> <tr><td class="menu" id="<%=rs.getString(1)%>"><a href="/html/default.asp"><%=rs2.getString(3)%></a></td></tr> <% } } %> </table> </td> <% } rs.close(); stmt.close(); rs2.close(); stmt2.close(); con.close(); %> </tr> </table> <p>Log-out when your job is over!!!</p> </body> </html>


now i want this to do be implemented in STRUTS2....


Following are my tables :


application table

application_id title short_title

(0000000001) (Registration Module) (Registration)
(0000000002) (Renewal Module) (Renewal)
(0000000003) (EMI Module) (EMI)



menu table:

[b](menu_id) (title) (short_title) (menu_typecharacter)

(0000000001) (Direct Candidate Registration) (Direct Regist) (H)
(0000000002) (Re registration) (Re registration ) (H )
0000000003 Renew Registration Renew Registration H
0000000004 Record of renewal Record of Renewal H
0000000005 ER1 Form ER1 Form H
0000000006 ER2 Form ER2 Form H



applicationmenu table:

application_menu_id application_id menu_id

0000000001 0000000001 0000000001
0000000002 0000000001 0000000002
0000000003 0000000002 0000000003
0000000004 0000000002 0000000004
0000000005 0000000003 0000000005
0000000006 0000000003 0000000006


1ST QUERY: select * from application where application_id in (select distinct application_id from applicationmenu order by application_id)
RESULT: this goes in my ResultSet rs

application_id title short_title

0000000001 Registration Module Registration
0000000002 Renewal Module Renewal
0000000003 EMI Module EMI


2ND QUERY: "select * from menu where menu_id in (select menu_id from applicationmenu where application_id='"+rs.getString(1)+"')")

When rs.getString(1) will be 0000000001 then it will show the following result :

menu_id title short_title menu_typecharacter
0000000001 Direct Candidate Registration Direct Regist H
0000000002 Re registration Re registration H

Hence it will generate the sub-menu for menuId=0000000001

And so on for menuId=0000000002 and 0000000003


all this will be in another ResultSet...

this is what my project is all about...plzzzz if you can suggest me what should i do....
thanks a lot!!!

Hello Joe Ess ....you are right that i am iterating the submenus with same list of menuTitle..i did this just to check if my second iterator(the nested one) is working or not...
after that i will do the project that is given to me in which i have to add subMenuTitle in the list in DAO.java with the help of a new query...where i will add the subMenuTitle for the its corresponding menuId....
how will i do it i am aslo not sure about that as well!!!