Nevermind... I figured it out. SQLResultSetMapping is now SQLResult.
Jamie wrote:
Hi Michael
Next question. I am trying to execute a query like:
select distinct customer.companyName c, max(date) d from purchase
inner join customer on purchase.customerid = customer.id group by
customer.companyName"
In doing so, I figured out I might need to use the SQLResultSetMapping
class to get at c and d, but this class does exist in the latest
cayenne-server-3.0M6.jar. What is the recommended approach?
Thanks
Jamie
Michael Gentry wrote:
I took a quick look at your model and it looks OK (given what I know
about what you are doing).
One thing that may be worth trying is to change:
Partner partner =
((BusinessServicesPrincipal)request.getUserPrincipal()).getPartner();
DataContext context =
((BusinessServicesPrincipal)request.getUserPrincipal()).getDataContext();
Customer customer = (Customer) context.newObject(Customer.class);
to:
Partner partner =
((BusinessServicesPrincipal)request.getUserPrincipal()).getPartner();
Customer customer = partner.getDataContext().newObject(Customer.class);
It may not solve anything, but worth a shot. I'm assuming you are
using Cayenne 3.x?
--
Stimulus Software - MailArchiva
Email Archiving And Compliance
USA Tel: +1-713-343-8824 ext 100
UK Tel: +44-20-80991035 ext 100
Email: [email protected]
Web: http://www.mailarchiva.com
To receive MailArchiva Enterprise Edition product announcements, send a message to:
<[email protected]>
