Support Forums: Message List - LIQUidFORM, an internal DSL for JPA queries, nears v1.0 http://www.theserverside.com Most recent forum messages en Jive Forums Silver 5.5.30 (www.jivesoftware.com) Sat, 25 May 2013 17:55:40 -0400 Re: Partial Object support in JDOQL http://www.theserverside.com/discussions/thread.tss?thread_id=52054 Cool thanks!! ... and JPQL does not support this because ... whoops thinking out loud again, I didn't actually ask that :) Because it does?]]> Fri, 05 Dec 2008 22:05:57 -0500 Fri, 05 Dec 2008 22:05:57 -0500 Fri, 05 Dec 2008 22:05:57 -0500 Dec 5, 2008 Mark N 0 Re: Partial Object support in JDOQL http://www.theserverside.com/discussions/thread.tss?thread_id=52054 Fri, 05 Dec 2008 06:17:17 -0500 Fri, 05 Dec 2008 06:17:17 -0500 Fri, 05 Dec 2008 06:17:17 -0500 Dec 5, 2008 rob bygrave 1 Re: Partial Object support in JDOQL http://www.theserverside.com/discussions/thread.tss?thread_id=52054 if we have a Person entity that has an Address entity ... and I only want to fetch the person firstName and surname and from the address only fetch the suburb and city. How do you do that in JDOQL?...]]> Fri, 05 Dec 2008 05:57:46 -0500 Fri, 05 Dec 2008 05:57:46 -0500 Fri, 05 Dec 2008 05:57:46 -0500 Dec 5, 2008 ^C^ ^C^ 2 Re: Lack of Partial Object support in JPA / JPQL http://www.theserverside.com/discussions/thread.tss?thread_id=52054
I see the lack of partial object support in JPQL as it's biggest design mistake. You should not have to go to native sql to perform such as query - its a shame no?

You can do that in standardised JDOQL and...]]> Fri, 05 Dec 2008 05:31:42 -0500 Fri, 05 Dec 2008 05:31:42 -0500 Fri, 05 Dec 2008 05:31:42 -0500 Dec 5, 2008 rob bygrave 3 Re: Lack of Partial Object support in JPA / JPQL http://www.theserverside.com/discussions/thread.tss?thread_id=52054 I see the lack of partial object support in JPQL as it's biggest design mistake. You should not have to go to native sql to perform such as query - its a shame no?...]]> Fri, 05 Dec 2008 04:57:38 -0500 Fri, 05 Dec 2008 04:57:38 -0500 Fri, 05 Dec 2008 04:57:38 -0500 Dec 5, 2008 ^C^ ^C^ 4 Lack of Partial Object support in JPA / JPQL http://www.theserverside.com/discussions/thread.tss?thread_id=52054 Fri, 05 Dec 2008 03:22:42 -0500 Fri, 05 Dec 2008 03:22:42 -0500 Fri, 05 Dec 2008 03:22:42 -0500 Dec 5, 2008 rob bygrave 5 Re: LIQUidFORM, an internal DSL for JPA queries, nears v1.0 http://www.theserverside.com/discussions/thread.tss?thread_id=52054 Wed, 03 Dec 2008 09:47:12 -0500 Wed, 03 Dec 2008 09:47:12 -0500 Wed, 03 Dec 2008 09:47:12 -0500 Dec 3, 2008 Chester Chen 0 you can have field mappings http://www.theserverside.com/discussions/thread.tss?thread_id=52054 I like your idea, but I guess this can only work well if you don't use field mapping, but getter/setter mapping...]]> Wed, 03 Dec 2008 07:52:57 -0500 Wed, 03 Dec 2008 07:52:57 -0500 Wed, 03 Dec 2008 07:52:57 -0500 Dec 3, 2008 Mohammed Imran 0 Ebean query http://www.theserverside.com/discussions/thread.tss?thread_id=52054 Tue, 02 Dec 2008 22:59:26 -0500 Tue, 02 Dec 2008 22:59:26 -0500 Tue, 02 Dec 2008 22:59:26 -0500 Dec 2, 2008 rob bygrave 0 Re: LIQUidFORM, an internal DSL for JPA queries, nears v1.0 http://www.theserverside.com/discussions/thread.tss?thread_id=52054 Select new Person(p.firstName, p.surname) FROM Person as p WHERE p.surname LIKE :surname If i am googling correctly, I it seems you can do this in JPQL too. So no need to drop to Hibernate.]]> Tue, 02 Dec 2008 22:04:17 -0500 Tue, 02 Dec 2008 22:04:17 -0500 Tue, 02 Dec 2008 22:04:17 -0500 Dec 2, 2008 Mark N 0 Re: LIQUidFORM, an internal DSL for JPA queries, nears v1.0 http://www.theserverside.com/discussions/thread.tss?thread_id=52054
I am not sure what you mean by
Hope your dba doesn't change your db naming conventions. :)
Really? Ok, you have the table and columns hardcoded in your sql. If you change the db you have to...]]> Tue, 02 Dec 2008 21:32:13 -0500 Tue, 02 Dec 2008 21:32:13 -0500 Tue, 02 Dec 2008 21:32:13 -0500 Dec 2, 2008 Chester Chen 1 Re: 4GL http://www.theserverside.com/discussions/thread.tss?thread_id=52054 Why not just use SQL? A 4GL DSL with good readability. Hibernate/JPA just add an extra layer of complexity to your app....]]> Tue, 02 Dec 2008 19:39:00 -0500 Tue, 02 Dec 2008 19:39:00 -0500 Tue, 02 Dec 2008 19:39:00 -0500 Dec 2, 2008 Mark N 0 Re: LIQUidFORM, an internal DSL for JPA queries, nears v1.0 http://www.theserverside.com/discussions/thread.tss?thread_id=52054 I am not sure what you mean by
Hope your dba doesn't change your db naming conventions. :)
Really? Ok, you have the table and columns hardcoded in your sql. If you change the db you have to find every...]]> Tue, 02 Dec 2008 19:27:23 -0500 Tue, 02 Dec 2008 19:27:23 -0500 Tue, 02 Dec 2008 19:27:23 -0500 Dec 2, 2008 Mark N 3 Re: LIQUidFORM, an internal DSL for JPA queries, nears v1.0 http://www.theserverside.com/discussions/thread.tss?thread_id=52054
List people = em.createNativeQuery(
"SELECT p.firstName, p.surname as lastname FROM person_table p WHERE p.surname LIKE 'Smith%'", Person.class)
.getResultList();

Hope your dba doesn't change your db naming...]]> Tue, 02 Dec 2008 16:38:34 -0500 Tue, 02 Dec 2008 16:38:34 -0500 Tue, 02 Dec 2008 16:38:34 -0500 Dec 2, 2008 Chester Chen 10 Re: 4GL http://www.theserverside.com/discussions/thread.tss?thread_id=52054 Tue, 02 Dec 2008 16:29:41 -0500 Tue, 02 Dec 2008 16:29:41 -0500 Tue, 02 Dec 2008 16:29:41 -0500 Dec 2, 2008 Casual Visitor 1