Stack Overflow
Stack Overflow

Questions tagged [ejbql]

EJB QL is a Query Language provided for navigation across a network of enterprise beans and dependent objects defined by means of container managed persistence.

EJB QL is a Query Language provided for navigation across a network of enterprise beans and dependent objects defined by means of container managed persistence. EJB QL is introduced in the EJB 2.0 specification. The EJB QL query language defines finder methods for entity beans with container managed persistenceand is portable across containers and persistence managers. EJB QL is used for queries of two types of finder methods:

  1. Finder methods that are defined in the home interface of an entity bean and which return entity objects.
  2. Select methods, which are not exposed to the client, but which are used by the Bean Provider to select persistent values that are maintained by the Persistence Manager or to select entity objects that are related to the entity bean on which the query is defined. From the EJB
52 questions
0
votes
2 answers

EJBQL - How to sort query results by a field in LEFT JOIN

I have the following classes (simplified for clarity): Class Top { InternationalStringType name; } Class InternationalStringType { List localizedString; } Class LocalizedStringType { String value; } The following EJBQL…
Farrukh Najmi
  • 5,055
  • 3
  • 35
  • 54
0
votes
1 answer

how to add day to date in ejbql

I am trying to achieve dateadd in my EJB query. I tried something like this but it doesn't work: select t.date + 1 from Table t Once I tried executing that code, this exception comes out: org.hibernate.exception.SQLGrammarException: ERROR: operator…
inxis
  • 51
  • 1
  • 4
0
votes
1 answer

How to convert this sql to EJB QL

The sql query is: SELECT to_char(DE.DELIVERYID) FROM DELIVERIES DE; DELIVERYID in oracle is a number and deliveryid in JPA is a Long. any suggestion?
Rafael
  • 185
  • 1
  • 4
  • 14
0
votes
1 answer

How do i do a like statement in ejb-ql?

Possible Duplicate: Parameter in like clause JPQL I got this code from an example, how do i do a search with ebj ql? SELECT OBJECT(p) FROM Person p WHERE (p.name LIKE ?1) How do i continue from here? I would like to return results where p.name…
Slay
  • 1,285
  • 4
  • 20
  • 44
0
votes
1 answer

Jpa ejbql query by list property

I have objects: PersenInfo : (long id,String name, String lastName,String email) AnsMsg : (long id,PersenInfo fromPersoninfo,String theMsg) Person : (PersonInfo personInfo, List msgs) person.hbm look like this:
Idan
  • 901
  • 4
  • 13
  • 29
0
votes
2 answers

EJBQL - Find all rows that have more than 'x' relationships

I know there must be a simple way to do this, but it's not coming to me at the moment. I've got a simple entity like (irrelevant parts removed for brevity): @Entity @Table(name = "reviews") public class Review { private String text; private…
aroth
  • 54,026
  • 20
  • 135
  • 176
0
votes
1 answer

Merge EJBQL query with CriteriaBuilder object

Is there a simple way to merge a existing ejbql query with a existing CriteriaBuilder object? I have on the one side a jasper report with ejbql query and on another side are applications function and object rights as a CriteriaBuilder object. My…
DSmelanskij
  • 81
  • 9
1 2 3
4