About SELECT

21-30 of 200Refresh
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
17

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
17

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

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

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