Home » Search

About SELECT

21-30 of 200Refresh
Manual
27

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
23

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
22

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

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
21

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

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
20

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
20

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

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
20

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