wood burning stoves 2.0*
The moose likes EJB and other Java EE Technologies and the fly likes problematic ejb ql query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "problematic ejb ql query" Watch "problematic ejb ql query" New topic

problematic ejb ql query

Liat Barda

Joined: Sep 17, 2003
Posts: 9
I got an alerts table that contains alerts recived by servers the columns are: serverip, time stamp,alert type.
I would like to get a list of all alerts but if two alerts have the same ip and type - i want to check thier time stamp and only if alert a.timestame >alertb.timestamp + 60 sec - i want to see both of them
otherwise only one of then should be returned from the query(the newer one).
will be happy to see some complex examples of ejb ql.

liat barda
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30068

That seems to complex to do in EJB-QL. You can write a simpler finder and put the logic in a session bean. In other words, call the session bean and filter the results there.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link: http://aspose.com/file-tools
subject: problematic ejb ql query
Similar Threads
Doubts on EJB-QL
Problem in EJB QL Finder Method.....
Hibernate mapping types
Discussion of Naming Policy
Alert timeout