Value is not reflected in the language drop down while calling the ejb bean in the modify user

[sumanta panda]

Dear All,

I am facing a issue while calling a ejb method in my jsp file.

I have a create/Modify user form.In the form i have select drop down called language.
LOCALE_CODE LOCALE_LANGUAGE_DESCRIPTION
en_US English
fr_CA French Canadian

In the language drop down the "LOCALE_LANGUAGE_DESCRIPTION" displayed is { English,French Canadian}

But while creating user/modify user its code is updated in LOGIN_USER i.e either en_US(if you have select English) else fr_CA(if selected French Canadian)

Properly the language value is updated in the database while creating/updating user.

The problem i am facing is in the edit screen while edit the user details bydefault "English" is comming first value in the dropdown.But it should be happen like if
login name belongs en_US then first value of the drop down English.Else login name belongs fr_CA then first value in the drop down should be French Canadian.
But it is not happening.Always English IS comming first value while the modify user. But database level the value is properly updated.

I tried to print the system.out.println.SOP's comming properly upto java level.

Lets my flow like for edit the user "updateuser.jsp->CrudUserAction.java(populateMasterData())->UserManagerBean.java(getUserMasterByLogin())"
Letus consider for the loginname i am chosing its value is fr_CA in the database.See my system.out.println comment in the below program marked as red.

I am getting proper value in my action and ejb class.

But while call same thing in my jsp it is bydefault changing English file.

Please suggest me how i fix this issue.
updateuser.jsp

<%@ page import="java.util.Locale, java.util.ArrayList, java.util.Iterator,java.util.*,com.siemens.ssl.abc.web.common.OptionLabelValue" %>
<%@ page import="com.siemens.ssl.sas.common.EzSuiteBusinessFunctions" %>
<bean:define id="abcUser" name="<%= Constants.USER_KEY%>" type="com.siemens.ssl.abc.ejb.user.data.AbcUserValue"/>
<tr>
		<td class="textContent" nowrap><bean:message key="admin.chooseDefaultLan"/></td>
			<td class="profileValue" ><SPAN class="textContent"></SPAN>
 			<%	UserManagerBean uma = new UserManagerBean();  			
				ArrayList prefLan = (ArrayList)uma.getAllLanguages(); 			
 				Iterator itrt  = null;
 				itrt  = prefLan.iterator(); 	
 				System.out.println("The language in update::"+abcUser.getPrefLangauge());			
 			%>   
 			    <SELECT name="prefLangauge" class="textContent">
				<!--<OPTION value="" selected>Please Select</OPTION>-->
				<% while (itrt.hasNext()) { 
			        OptionLabelValue languageList = (OptionLabelValue) itrt.next();	
			        System.out.println("The language in label::"+languageList.getLabel());	
			        System.out.println("The language in label value::"+languageList.getValue());					          
			 %>
			<option value="<%= languageList.getLabel() %>" ><% if (languageList.getLabel().equals(abcUser.getPrefLangauge())){ %> SELECTED <% } %> ><%= languageList.getValue() %></option>
			<% } %>
			
			</SELECT>
			</td>
		</tr>

The language in updateen_US
The language in labelen_US
The language in label valueEnglish
The language in labelfr_CA
The language in label valueFrench Canadian


CrudUserAction.java

if (crudForm.getAction().equals("populate"))
            {
            	 System.out.println("Edit user called ......................>>>Called");
                  logger.debug("Edit user called ...");
                  id = request.getParameter("id");
                  if (!populateMasterData(crudForm, id))
                  {
                        ActionErrors errors = new ActionErrors();
                        errors.add(ActionErrors.GLOBAL_ERROR, new ActionError("error.user.unknown"));
                        request.setAttribute(Action.ERROR_KEY, errors);
                        return (new ActionForward(mapping.getInput()));
                  
private boolean populateMasterData(CrudUserForm form, String id)
      {
            logger.debug("Populate user master data ...");
            System.out.println("Edit user called RETRIVE DATA......................>>>Called");
            System.out.println("Populate user master data ...------->>>>>"+id);
            
            try
            {
try
            {
                  SimpleDateFormat df = new SimpleDateFormat("MM-dd-yy");
                  form.resetData();
                  AbcUserValue abcUser = uma.getUserMasterByLogin(id);
                  form.setAbcUser(abcUser);
                  form.setLoginName(abcUser.getLoginName());
                  form.setEmail(abcUser.getEmail());
                   form.setPrefLangauge(abcUser.getPrefLangauge()); 
                  System.out.println("Hello the langugae is LOGIN USER LANGUAGE populateMasterData()"+ abcUser.getPrefLangauge()); 
}

/*Hello the langugae is ABC USER LANGUAGE populateMasterData()fr_CA*/


UserManagerBean.java

public AbcUserValue getUserMasterByLogin(String loginName) throws AbcUserException {
            if (log.isDebugEnabled()) log.debug("getUserMasterDataByLogin called for user " + loginName);
            AbcUserValue user = null;
            Connection con = null;
            PreparedStatement ps = null;
            String sql = "SELECT * FROM LOGIN_USER WHERE LOGIN_NAME = ?";
            try
            {
                  con = DbUtil.fetchConnection();
                  ps = con.prepareStatement(sql);
                  ps.setString(1, loginName);
                  ResultSet rs = ps.executeQuery();
                  if (rs.next())
                  {
                        user = new AbcUserValue();
                        user.setLoginName(rs.getString("LOGIN_NAME"));
                        user.setPasswd(rs.getString("PASSWORD"));
                        user.setEmail(rs.getString("EMAIL"));
                        user.setPrefLangauge(rs.getString("PROFILE_LANGUAGE"));
						 
 System.out.println("The language is getUserMasterByLogin()"+rs.getString("PROFILE_LANGUAGE"));[color=red] 
}


public ArrayList getAllLanguages() throws AbcUserException {
						 	
Connection con = null;
PreparedStatement ps = null;
        
String sql = " select LOCALE_CODE,LOCALE_LANGUAGE_DESCRIPTION from LOCALE ";
  
 ArrayList allLanguages = new ArrayList();
 try
 {
 con = DbUtil.fetchConnection();
 ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
 OptionLabelValue ov = null;
while (rs.next())
 {
 ov = new OptionLabelValue(rs.getString("LOCALE_CODE"),rs.getString("LOCALE_LANGUAGE_DESCRIPTION"));
 allLanguages.add(ov);
	 }
	 rs.close();
}
}

/*The language is getUserMasterByLogin()fr_CA*/



Thanks for your time.

Regards,
Sumanta

[sumanta panda]

Dear All,

Please suggest me the needful.

Thanks a lot in advance.

Regards,
Sumanta

[sumanta panda]

Dear All,

Please suggest me how i fix this error.

Regards,
Sumanta