I'm working on a site that allows people to rate services. There is a
Services entity that contains a set of Report entities. Users can add
new services and submit reports on those services. The reports have
questions that users rate from 1 to 5 stars.
I am using hibernate properties with formulas to calculate several
things. Doing this has really simplified things, however it looks
like it may have made other things more complex. For instance, I have
properties like this in Service:
<property name="avgQuestion1"
formula="(select round(avg(r.question1)) from report r where
r.service_id = service_id)" />
<property name="countReports"
formula="(select count(*) from report r where r.service_id = service_id)" />
The users see a dataview of services. One of the columns is the number
of reports submitted for that service. The problem is that when the
user submits a report and then goes back to the dataview, the list
isn't updated to indicate the new report. The value of countReports
is still the same. Nor are the averages updated.
The Services table hasn't changed when a report is submitted, so
hibernate isn't refreshing. However, the calculated formulas HAVE
changed, but aren't causing the data to be re-read.
Are there recommended ways to force a refresh of the data? Should I
do it in the dataview? Or should I do it when a new report is
submitted? Any suggestions and advice is much appreciated!
Tauren
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Wicket-user mailing list
Wicket-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wicket-user
