Nice. I'm a fan of "when in doubt, do it anyway" :)
On Sat, Apr 25, 2009 at 6:34 AM, Oliver Lambert <olambo...@gmail.com> wrote:
> Sorry, I didn't get back sooner - too much work!
> No one told me I couldn't do this so I just did it. Create a dummy entity
> to a table/view that doesn't exist - then write a query that uses column
> aliases and any arbitrary sql to populate that entity. I guess JPA/Hibernate
> is just creating an instance of a class and then calling a bunch of setters.
>
> Other times, I've dumped all the hard work on Oracle programmers, getting
> them to create a set of read only views and created entities on them, but I
> guess thats less weird.
>
> I've also done a similar thing in using formal constructors via hibernate's
> report queries, but thats more work and I'm lazy.
>
> cheers Oliver
>
>
> On Fri, Apr 24, 2009 at 6:11 AM, Derek Chen-Becker
> <dchenbec...@gmail.com>wrote:
>
>> Oliver, I've never done anything like that in JPA or Hibernate. Is that
>> actually possible? Can you "create" a class instance within a query?
>>
>> Derek
>>
>>
>> On Thu, Apr 23, 2009 at 2:47 PM, Charles F. Munat <c...@munat.com> wrote:
>>
>>>
>>> I'm not really sure how I would go about this, but I'll think about it
>>> when I have time to get back to that code.
>>>
>>> Thanks, Oliver.
>>>
>>> Chas.
>>>
>>> Oliver Lambert wrote:
>>> > Is there anything to stop you defining an class/entity {answer: String,
>>> > countAnswer: Int} and to directly create it from JPA (of course, it's
>>> > read only).
>>> >
>>> > On Wed, Apr 22, 2009 at 9:36 AM, Charles F. Munat <c...@munat.com
>>> > <mailto:c...@munat.com>> wrote:
>>> >
>>> >
>>> > I was thinking tuples, but that didn't work. I'll try your
>>> suggestion.
>>> > BTW, for anyone reading along, I forgot the group by clause in the
>>> query
>>> > below.
>>> >
>>> > Chas.
>>> >
>>> > Derek Chen-Becker wrote:
>>> > > I think that the type would be Array[Any] and you'll get one
>>> > String and
>>> > > Int for each row.
>>> > >
>>> > > Derek
>>> > >
>>> > > On Tue, Apr 21, 2009 at 3:37 PM, Charles F. Munat <
>>> c...@munat.com
>>> > <mailto:c...@munat.com>
>>> > > <mailto:c...@munat.com <mailto:c...@munat.com>>> wrote:
>>> > >
>>> > >
>>> > > Anyone have a quick example of how to run a scalar query in
>>> > JPA? I can't
>>> > > find anything in the JPA demo.
>>> > >
>>> > > I have this query:
>>> > >
>>> > > select t.answer, count(distinct answer) from Vote t where
>>> > t.poll = :poll
>>> > > order by t.answer
>>> > >
>>> > > but how do I call it? I normally do:
>>> > >
>>> > > Model.createNamedQuery[...]("findVoteCountAnswersByPoll",
>>> > "poll" ->
>>> > > poll).findAll
>>> > >
>>> > > But what is the type? And how do I get the results back out?
>>> > >
>>> > > I know I did this once before somewhere, but I can't
>>> remember
>>> > where and
>>> > > I can't find it.
>>> > >
>>> > > Thanks!
>>> > >
>>> > > Chas.
>>> > >
>>> > >
>>> > >
>>> > >
>>> > > >
>>> >
>>> >
>>> >
>>> >
>>> > >
>>>
>>>
>>>
>>
>>
>>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Lift" group.
To post to this group, send email to liftweb@googlegroups.com
To unsubscribe from this group, send email to
liftweb+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/liftweb?hl=en
-~----------~----~----~----~------~----~------~--~---
