persistence@glassfish.java.net

RE: Constructor Expressions

From: Dru Devore <ddevore_at_duckhouse.us>
Date: Thu, 06 Nov 2008 13:15:30 -0700

I am working on recreating the problem but I think I might have solved
it. I trying to use sql in the creation. I have since tried to do it
using the object references JPQL which is proving to be difficult
because I am using a fairly hard query. It links 4 tables conditionally
with the resulting object being a conglomerate of the 4.

two questions.

1. is there a way to make a query for this using a native query?

2. if I use JPQL will it create the standard sql and execute it or will
it do the query using the objects and simply create the resulting object
from the objects. I am concerned about memory. This query will return
25,000 objects and with the four tables linked in code it will bring my
server to its knees....

---
Dru Devore
The best Christian community now online.
The Faith Haven
www.thefaithhaven.com
Come join us, bookmark us, and enjoy!
> -------- Original Message --------
> Subject: Re: Constructor Expressions
> From: Wouter van Reeven <wouter_at_van.reeven.nl>
> Date: Thu, November 06, 2008 2:04 pm
> To: persistence_at_glassfish.dev.java.net
> 
> 
> On Thu, Nov 06, 2008 at 12:02:36PM -0700, Dru Devore wrote:
> > I have been trying to get a constructor expression working and have had
> > nothing but errors. 
> > 
> > I have followed an example from a book and have tried this blog
> > 
> > http://weblogs.java.net/blog/mb124283/archive/2007/04/java_persistenc.html
> > 
> > But I have had no luck. Any suggestions/examples out there that work?
> 
> Can you post the expression that fails and possibly the error you get?
> 
> 
> Thanks, Wouter van Reeven
> 
> -- 
> 
> People: "If she weighs the same as a Duck, she's made of wood!"
> Sir Bedevere: "And therefore...?"