[EJB 3.0] - Dynamic Named Query?
by hotat27
Hello,
Currently I'm using named query which is written in orm.xml and is working fine.
| Query query = em.createNamedQuery("selectAddresses");
| query.setParameter("postcode", 50000);
| query.getResultList();
|
| <query>
| select * from address where postcode=:postcode ORDER BY state ASC
| </query>
|
Is it possible to dynamically change the "ORDER BY state ASC" to ascending or descending in java code, either through query.setParameter("", "") or any other methods?
I've tried the setParameter method, for example
| <query>select * from address where postcode=:postcode ORDER BY state :ordering</query>
|
| query.setParameter("ordering", "ASC") or query.setParameter("ordering", "DESC")
|
but the result didn't seem to be consistent.
Thanks in advance.
Steven
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3969960#3969960
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3969960
19 years, 7 months
[Beginners Corner] - jboss + seam + facelets - giving me an error with h:inputTex
by Di
Hi, I'm a bit confused.
I have a standard login page with
<h:inputText value="#{login.Username}" />
dd><h:inputSecret value="#{login.Password}" size="16"/>
getters and setters are set exactly the same for Username and Password (getUsername, getPassword), and if I change the type from inputText to inputSecret, I don't get an error.
But with inputText I get
javax.faces.el.PropertyNotFoundException: /WEB-INF/incl/login.xhtml @15,53 value="#{login.Username}": Bean: $Proxy229, property: Username
at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:58)
at javax.faces.component.UIOutput.getValue(UIOutput.java:75)
at org.apache.myfaces.renderkit.RendererUtils.getStringValue(RendererUtils.java:225)
at org.apache.myfaces.renderkit.html.HtmlTextRendererBase.renderInput(HtmlTextRendererBase.java:131)
at org.apache.myfaces.renderkit.html.HtmlTextRendererBase.encodeEnd(HtmlTextRendererBase.java:49)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:331)
at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java:242)
at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java:239)
at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java:239)
at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:554)
at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:352)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:144)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.seam.servlet.SeamRedirectFilter.doFilter(SeamRedirectFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.seam.servlet.SeamExceptionFilter.doFilter(SeamExceptionFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Unknown Source)
So far I have tried shifting my seam.properties file, adding the faces.jar items again, but I can't work out why exactly it is going wrong.
The definitions for the Username are:
(in the bean)
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
(In the interface)
public String getUsername();
public void setUsername(String username);
I'm sure it is just a setting somewhere, but I have looked at the xml files and they all appear correct to me.
Any ideas?
Thanks
Di
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3969958#3969958
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3969958
19 years, 7 months