About SELECT

21-30 of 200Refresh
Manual
36

ORDER BY clause (JPQL / Criteria API)

is at least one million people, ordered by the country name: SELECT c.name FROM Country c WHERE c.population > 1000000 ... clause produces objects for examination and the WHERE clause selects which objects to collect as results. Then the SELECT clause builds the results by evaluating the result expressions. Finally the results
Manual
36

FROM clause (JPQL / Criteria API)

over all the Country objects in the database: SELECT c FROM Country AS c The AS keyword is optional, and the same query can also be written as follows: SELECT c FROM Country c By default, the name ... returns all the pairs of countries that share a common border: SELECT c1, c2 FROM Country c1, Country c2
Manual
32

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
27

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
25

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
24

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
24

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
24

Java EE 6 JPA Tutorial - IntelliJ Project

: 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
24

JPA Web App Tutorial - IntelliJ Project

the project zip file: JPA Web App - Maven Project (6KB) Open the project in IntelliJ IDEA: Select File > Open Project.... Select the guestbook-web directory and click OK. Define the Server: Select File ... separately). Define Run Configuration: Select Run > Edit Configurations, click the + icon
Tutorial
24

Spring MVC JPA Tutorial - IntelliJ Project

: Spring MVC JPA - Maven Project (8KB) 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