Thank you for the reply. The joins all work fine in the tests and I can
filter out the information after it is pulled from the database, but I
am just getting huge records and would rather have the filter take care
of the extra information in the sql statement as apposed to in memory.
Thanks for pointing out the arbitrary clause support issue. I have also
tried writing the join statement when I was using the createQuery and
find methods, but with no luck. The only other option I see right now
is to go to creating a SQL statement and inserting the information into
the class, but I really would prefer not to do that and I don't see why
I can't put a filter on the join tabel.
Anyway, if anyone has any further suggestions, they are appreciated.
Dale Newfield wrote:
Eric Fitzsimmons wrote:
Using AF 2 m5 Struts full source. I am trying to add a filter to a
join table that will filter for an active date range.
I've not worked with JPA or with filters, so I can't offer much
specific help, but I can point out that I don't think you're doing
what you think you're doing. I don't see any joins in the queries
you're running, so I don't understand what join you think you're
filtering...
...and note that hibernate *still* does not yet support adding
arbitrary clauses into outer joins:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-16
-Dale
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
