[JBoss Seam] - ejb-ql join and h:dataTable
by 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
18 years, 3 months
[JBoss Portal] - New Session Id generated on every AJAX call when SSL is enab
by cybershastri
Hi All,
I am making an AJAX call in one of my jsp pages.
When I login to the portal with normal HTTP url, and make the AJAX call,
the session Id for the AJAX request remains the same everytime.
However, the behavior changes when I login to portal with HTTP/S protocol.
Now, everytime the AJAX request generates new session id. Is this normal behavior? What needs to be done if I need the same session id to be used for each AJAX request?
Here is how I am creating AJAX requests :
| function updateTicket(){
| var params;
| // Obtain an XMLHttpRequest instance
| req = newXMLHttpRequest();
|
| var handlerFunction = callback;
| params = "ticketNumber=" + ticketNumber + "&"
| + "probDesc=" + eprobdesc + "&"
| + "diagResoln=" + ediagres + "&"
| + "requestType=updateTicket";
|
| var url="/TicketEscalation/TicketUpdate.json";
| req.open("POST", url , true);
| req.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
| req.setRequestHeader("Content-length", params.length);
| req.setRequestHeader("Connection", "close");
| req.onreadystatechange = handlerFunction;
| req.send(params);
| }
|
function newXMLHttpRequest() {
|
| if (window.XMLHttpRequest) {
|
| // Create XMLHttpRequest object in non-Microsoft browsers
| req = new XMLHttpRequest();
|
| } else if (window.ActiveXObject) {
|
| // Create XMLHttpRequest via MS ActiveX
| try {
| // Try to create XMLHttpRequest in later versions
| // of Internet Explorer
|
| req = new ActiveXObject("Msxml2.XMLHTTP");
|
| } catch (e1) {
|
| // Failed to create required ActiveXObject
|
| try {
| // Try version supported by older versions
| // of Internet Explorer
|
| req = new ActiveXObject("Microsoft.XMLHTTP");
|
| } catch (e2) {
|
| // Unable to create an XMLHttpRequest with ActiveX
| alert("Your browser does not support AJAX");
| }
| }
| }
| return req;
| }
|
Regards,
Shastri.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4117704#4117704
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4117704
18 years, 3 months
[JBoss Seam] - Page Parameter Pains.
by Andy Gibson
I have a stateless view page for a widget and multiple lists of widget detail records in data tables in a rich:tab. I pass in the widgetId as a parameter to fetch and display the view, and use page parameters to maintain state in a stateless view as the user interacts with it. I'm finding some nasty side effects of page parameters.
For each widget detail, I have a rich:tab containing a data table that displays the widget detail and my own little paginator facelet that uses the EntityQuery methods for next, first, last, prev etc... Being stateless, I need to pass the first result for each subdetail each time so the entity query knows where to start displaying results from.
My pages.xml for the page looks like this :
| <page view-id="widgetView.xhtml">
| <param name="widgetId" value="#{widgetHome.id}" required="false"
| converterId="javax.faces.Long" />
| <param name="subDetailAFirst" required="false"
| value="#{subDetailsAQuery.firstResult}" />
| <param name="subDetailsBFirst" required="false"
| value="#{subDetailsBQuery.firstResult}" />
| </page>
|
|
(There are 5 sub details each with a tab containing a table and a paginator)
This works, and works extremely well, it was a piece of cake to develop, and it's times like this that Seam rocks.
However, it has a problem. Obviously, since I use page params, anytime I do an s:link to the page, Seam tries to add the parameters and since there are none, it creates the EntityQueries to try and obtain the parameter values. Obviously this is not the desired result. This problem also happens for search pages with bookmarkeable results when the search pages are linked from a page, or even worse, a menu which is re-used across a number of pages.
Normally when you have a link to a page with page parameters for which you know there is no value (i.e. the contactId in the add contact link in the seam contact example), you can add it manually to the s:link so seam doesn't try to add it. This is somewhat acceptable to a point.
It seems a little clumsy to have to do that for each of the 5 parameters, for every link that references the page, and will need to be modified if I ultimately add a 6th sub detail table with pagination.
One option is to put it into a conversation and make it stateful which works, but apart from being a little unnecessary, and overkill for a view page, it comes with it's own trickses. When you change tabs, and it involves a datafetch, and you go back to the original tab, the data is nulled out because a sql query flushed the entity manager and nulled out the existing data entities.
Going back to a stateless solution, it seems that a better option is to make page parameters optional (similar to the required attribute for @In and @Out bijection) so that if the object isn't there, and it is optional, then no object is created and no parameter is added. I couldn't find an existing JIRA, anyone have any thoughts on the matter? Should I not worry about multiple objects being created per request for no reason?
Cheers,
Andy Gibson
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4117697#4117697
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4117697
18 years, 3 months