About SELECT

21-30 of 200Refresh
Manual
21

JPA Query Structure (JPQL / Criteria)

and easier to use in Java. JPQL Query Structure As with SQL, a JPQL SELECT query also consists of up to 6 clauses in the following format: SELECT ... FROM ... [WHERE ...] [GROUP BY ... [HAVING ...]] [ORDER BY ...] The first two clauses, SELECT and FROM are required in every retrieval query
Manual
20

Index Definition

execution. Indexes are especially efficient in lookup and range queries: SELECT p FROM Point p WHERE p.x = 100 SELECT p FROM Point p WHERE p.x BETWEEN 50 AND 80 SELECT p FROM Point p WHERE p.x >= 50 ... enables quick execution of the following queries: SELECT p FROM Point p WHERE p.x = 100 AND p.y = 100
Issue
19

Issue with DISTINCT Select

It is getting more and more frustrating :( We've introduced distinct select instead of regular selection in our code (no changes else) and suddenly receive invalid identifiers in queries exceptions ... identifier (namely, $1) multiple times for different selections in the same query
Forum
19

ClassCastException on SELECT NEW ... after UPDATE over Java RMI

internally runs SELECT NEW ... queries. For example: SELECT NEW com.arunta.base.db.FileNameDTO(r.id, r.fileName) FROM RecordingMetaData AS r WHERE ... A remote RMI client runs SELECT (but not SELECT ... is that once we UPDATE a record from the client (via the RMI interface), all SELECT NEW ... queries
Manual
18

JPA Criteria API Queries

JPA Criteria Query The following query string represents a minimal JPQL query: SELECT c FROM ... c = q.from(Country.class); q.select(c); The CriteriaBuilder interface serves as the main ... , the range variable, c, is also used in the SELECT clause as the query result expression
Forum
18

Multi selection and distinct in a criteria query

hi, How can I realize multi selection with the criteria api concerning distinct? I.e. doing something like SELECT DISTINCT $1, $2 wouldn't work because I do only have something like criteria.multiselect(...) and nothing like builder.distinct(selection) so that I could do something like criteria
Forum
18

Problem with distinct select, order by and equivalent alias/attribute path

));                 em.getTransaction().commit();                         String q1 = "select ... ();                 q1 = "select distinct s.location "             + "from Street s ... , Location.class).getResultList();                 String q2 = "select distinct s.location
Forum
18

Is there any faster select method?

SELECT: TypedQuery query = em.createQuery(     "SELECT p FROM Point p WHERE p.id ... ); ** the Point class is of the tutorial. I found the above select method is ten times slower ... . Is there any faster method of select? TIA Entity objects can be retrieved by their primary key (object
Forum
18

selecting objects that have a particular key/value in persistant HashMap

a JPA query that selects such objects?  Something like the following (but clearly does not work) :  SELECT p FROM Person p where p.pMap['location']='California' Any thoughts?  Thanks, -Adam   Please try the following query: SELECT p FROM Person p WHERE p.pMap.get('location') = 'California
Forum
18

Wrong select results

Hello, I got a realy strange SELECT problem. In explorer query "select p  from Player p where p.confirmed==false", given me some results with p.confirmed==TRUE. And when I try to do (see image) "select p, p.confirmed  from Player p where p.confirmed==false", I getting p->confirmed->true and p