[jboss-user] [JBoss Seam] - ejb-ql join and h:dataTable

[vikramchhetryy]

Hi All,
I have a search user page where user can be searched by firstname and last name.

My Code

xhtml

  | <h:form id="searchCallCenterAgentForm" style="width:600px;">
  |    <f:facet name="header">Call Center Agent Search</f:facet>
  | 	<div class="dialog"><h:panelGrid columns="2" rowClasses="prop"
  | 	columnClasses="name,value">
  | 		<h:outputLabel for="firstName">First Name</h:outputLabel>
  | 		<h:inputText id="firstName"
  | 			value="#{callCenterAgentManage.firstName}" style="width:150px"
  | 						required="false">
  | 		<a:support event="onkeyup"						actionListener="#{callCenterAgentManage.searchCallCenterAgent}"
  | 		reRender="searchResults" />
  | 		</h:inputText>
  | 		<h:outputLabel for="lastName">Last Name	</h:outputLabel>
  | 		<h:inputText id="lastName"
  | 		value="#{callCenterAgentManage.lastName}" style="width:150px"
  | 						required="false">
  | 		<a:support event="onkeyup"
  | 			actionListener="#{callCenterAgentManage.searchCallCenterAgent}"
  | 				reRender="searchResults" />
  | 		</h:inputText>
  | 		</h:panelGrid></div>
  | 			<div class="actionButtons"><a:commandButton value="Search"
  | 				action="#{callCenterAgentManage.searchCallCenterAgent}"
  | 					id="searchCallCenterAgent" reRender="searchResults" /></div>
  | 		</h:form>
  | 	        </rich:panel> <rich:panel style="width:600px;">
  | 			<a:outputPanel id="searchResults">
  | 				<div class="section"><h:outputText value="No Agents Found"
  | 					rendered="#{agentDetails != null and agentDetails.rowCount==0}" />
  | 		<h:dataTable id="agentDetails" value="#{agentDetails}" var="details"
  | 			rendered="#{agentDetails.rowCount>0}">
  | 		<h:column>
  | 			<f:facet name="header">User Name</f:facet>
  |                         #{details.strUserName}
  |                 </h:column>
  | 		<h:column>
  | 			<f:facet name="header">First Name</f:facet>
  |                         #{details.person.strFirstName}
  |                 </h:column>
  | 			<h:column>
  | 		<f:facet name="header">Last Name</f:facet>
  |                         #{details.person.strLastName}
  |                 </h:column>
  | 			<h:column>
  | 		<f:facet name="header">Account Status</f:facet>
  |                         #{details.flgAccountStatus}
  |                 </h:column>
  | 				</h:dataTable>
  | 		</a:outputPanel>
  | 		</rich:panel>


Bean

  | 	private String firstName;
  | 	private String lastName;
  | 	@In
  | 	Account account;
  | 	@In
  | 	FacesMessages facesMessages;
  | 	@PersistenceContext
  | 	private EntityManager em;
  | 	@DataModel
  | 	private List<Account> agentDetails;
  | 
  | 	private String userName;
  | 
  | 	public void searchCallCenterAgent() {
  | 		// implement your business logic here
  | 		log.info("callCenterAgentManage.searchCallCenterAgent() action called");
  | 
  | 		String searchQuery = "select "
  | 				+ "a, p "
  | 				+ "from Account a, Person p " + "where "
  | 				+ "a.flgAccountStatus!='i' " + "and a.flgDeleted='0' "
  | 				+ "and a.strUserName!='" + account.getStrUserName() + "' ";
  | 
  | 		if (!firstName.equals("")) {
  | 			searchQuery += "and lower(p.strFirstName) like #{firstNamePattern} ";
  | 		}
  | 
  | 		if (!lastName.equals("")) {
  | 			searchQuery += "and lower(p.strLastName) like #{lastNamePattern} ";
  | 		}
  | 
  | 		searchQuery += " and a.person.ipersonId = p.ipersonId";
  | 		agentDetails = em.createQuery(searchQuery).getResultList();
  | 		log.info("Search query = " + searchQuery);
  | 		log.info("Result count = " + agentDetails.size());
  | 	}
  | Getters and setters
  | --------------------
  | --------------------
  | --------------------
  | 

When I click search it says
Error:--

  | Exception during request processing:
  | Caused by javax.servlet.ServletException with message: "/manage.xhtml: For input string: "strUserName""

Does anyone have any idea whats going wrong?

Thanks in advance

-Vikram



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4117728#4117728

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4117728