Home » Search

About SELECT

21-30 of 200Refresh
Manual
26

WHERE clause (JPQL / Criteria API)

The WHERE clause adds filtering capabilities to the FROM-SELECT structure. It is essential in any JPQL query that retrieves selective objects from the database. Out of the four optional clauses ... , which is represented by the parameter p: SELECT c FROM Country c WHERE c.population > :p The FROM clause
Manual
21

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
Manual
20

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
Issue
20

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
Tutorial
19

Java EE 6 JPA Tutorial - IntelliJ Project

IDEA: Select File > Open Project.... Select the guestbook-jee6 directory and click OK. Define the Server: Select File > Settings > Application Servers. Add Tomcat 6 Server if not set already (Tomcat has to be downloaded separately). Define Run Configuration: Select Run > Edit Configurations, click
Tutorial
19

JPA Web App Tutorial - IntelliJ Project

: Select File > Open Project.... Select the guestbook-web directory and click OK. Define the Server: Select File > Settings > Application Servers. Add Tomcat 6 Server if not set already (Tomcat has to be downloaded separately). Define Run Configuration: Select Run > Edit Configurations, click the + icon
Tutorial
19

Spring MVC JPA Tutorial - IntelliJ Project

: Spring MVC JPA - Maven Project (7KB). Open the project in IntelliJ IDEA: Select File > Open Project.... Select the guestbook-spring directory and click OK. Define the Server: Select File > Settings ... ). Define Run Configuration: Select Run > Edit Configurations, click the + icon and select Tomcat
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