Re: [appfuse-user] Forcing A Group By In Hibernate

Hmm..there are two peices of advice that you will find in the documentation for JPA as you go along...first use JPQL rather than SQL because the JPA implementations are very good at generating high-performance queries. Only use SQL when you need to optimize the query in a way that is not supported

Re: [appfuse-user] Forcing A Group By In Hibernate

Thanks very much for your input below - Its much appreciated My question is simply why go the trouble of putting the sql in the entity class and then backing it out in the DAO? Is there any way I can construct the sql string in the DAO and add all the neccessary filters that I need then in the S

Re: [appfuse-user] Forcing A Group By In Hibernate

Yes it is possible. There are a number of options. For instance, you may use named queries. In this case you write the query in your Entity class then access the query from your DAO when needed. Lets see if I could construct an example: Suppose you have an Entity class called Landlord, then you mi

Re: [appfuse-user] Forcing A Group By In Hibernate

Thanks for the reply - I guess the problem is that in the DAO we do something like: getHibernateTemplates.findByCriteria.. This doesnt work for me :( - I d much rather write the sql statement from scratch like select colA from myTable Is this possible? Vincent Ramdhanie wrote: >

Re: [appfuse-user] Struts2 redirect problem

Hi, as I see it the endUserRetailer renders the result. What does it look like in your struts.xml? Please refer here before: http://struts.apache.org/2.x/docs/redirect-action-result.html regards mannobug schrieb: Hi all in my struts.xml i have an action description that have to redirect aft

[appfuse-user] Struts2 redirect problem

Hi all in my struts.xml i have an action description that have to redirect after a success. Success string is set in save method; the problem is that after saving i remain in the same page and redirection is not working. This is my struts.xml: /WEB-INF/pages/confirmRetailerR

Re: [appfuse-user] some doubt

accountExpired seems to make more sense than accountNotExpired. If you want to use the later, isExpired=false seemes to make more sense. Matt On Fri, Sep 12, 2008 at 2:30 AM, Gordian Yuan <[EMAIL PROTECTED]> wrote: > hi all, > i read the appfuse source and i have some doubt in org.appfuse.model.U

Re: [appfuse-user] AJAX Web framework

Oscar I completely agree the sx tags did not live up to my expectations. Since I am fairly familiar with Appfuse I would like to get something going in the Appfuse framework. Do anybody have opinions or experiences with Ajax on the frameworks supported in Appfuse? * JSF * Struts2 * Tapestry * Spr

Re: [appfuse-user] Forcing A Group By In Hibernate

I don't think that a group by is designed to remove duplicates, you probably want to select distinct. However, in Hibernate if you are using eager fetching you might still end up with duplicates so you may have to remove them yourself. This topic might provide some clues: http://www.javalobby.org/

Re: [appfuse-user] AJAX Web framework

My experience with struts 2 and its infamous sx tags has been BAD. We eventually moved to jQuery for ajax request. dojo included with struts 2.1.2 is fairly outdated and the tags are buggy, slow and difficult to customize. On Fri, Sep 12, 2008 at 3:38 PM, Youssef Mohammed < [EMAIL PROTECTED]> wrot

Re: [appfuse-user] AJAX Web framework

richfaces ajax support as cool and simple. On Fri, Sep 12, 2008 at 2:36 PM, Juan Heyns <[EMAIL PROTECTED]> wrote: > Hello Guys > > This question may be considered as off topic. Excuse it. If you are not > interested, please stop reading. > > I would like to have some expert oppinions on which we

[appfuse-user] AJAX Web framework

Hello Guys This question may be considered as off topic. Excuse it. If you are not interested, please stop reading. I would like to have some expert oppinions on which web framework best supports AJAX controls and rich interfaces. I have limited experience with Struts2 and so far it has not been

[appfuse-user] Forcing A Group By In Hibernate

I ve been blown away by how neat Appfuse is and its been a great kickstart. I m trying to ensure that duplicates are removed from the data returned by hibernate by forcing a group by - So far I ve tried to use the Projection group property on the criteria as follows: criteria.setProjection(Pro

[appfuse-user] some doubt

hi all, i read the appfuse source and i have some doubt in org.appfuse.model.User @Column(name="account_expired",nullable=false) public boolean isAccountExpired() { return accountExpired; } @Transient public boolean isAccountNonExpired() { return !isAccountExpired(); } i try