About SELECT

31-40 of 200Refresh
Forum
23

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
23

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
22

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

CRUD Database Operations with JPA

objects in the database by using a simple query: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point p"); System.out.println("Total Points: " + q1.getSingleResult()); The query string ("SELECT ... see another example of a query that returns a single result: Query q2 = em.createQuery("SELECT AVG(p.x) FROM
Manual
22

Running JPA Queries

The Query interface defines two methods for running SELECT queries: Query.getSingleResult - for use ... : TypedQuery query = em.createQuery("SELECT c FROM Country c", Country.class); List ... (generic) type: Query query = em.createQuery("SELECT c FROM Country c"); List results = query
Manual
22

BIRT/ODA ObjectDB Driver

extension. To install it: Open the [Install] dialog box by selecting Help > Install New Software... In ... ENTER. Select the ObjectDB Birt/ODA feature. Complete the installation by clicking Next twice, accepting ... and selecting New Data Source. Select ObjectDB Data Source from the list of available data source types
Tutorial
22

Step 7: Run the Spring Web App

as a server in your NetBeans - you should be able to run your application now by selecting Run > Run Main Project from the main menu (or F6): You can select the server in the Run category of the project properties window (right click the project node and select Properties to open it). Alternatively
Forum
22

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
22

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

Conditional Selection

so when I use... SELECT firstName + " " + middleName + " " + lastName FROM Employee     ORDER BY ... an additional field. e.g. displayName. Use a method in the SELECT clause. It could be a static method