Home » Search

About SELECT

31-40 of 200Refresh
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
18

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
18

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

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

JPA Named Queries

="SELECT c FROM Country c") The @NamedQuery annotation contains four elements ... class. But since the scope of named queries is the entire persistence unit, names should be selected ... ", query="SELECT c FROM Country c") public class Country { ... } Attaching multiple named
Manual
17

Running JPA Queries

The Query interface defines two methods for running SELECT queries: Query.getSingleResult - for use ... query = em.createQuery("SELECT c FROM Country c", Country.class); ListSELECT c FROM Country c"); List results = query
Tutorial
17

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

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 ... of a query that returns a single result: Query q2 = em.createQuery("SELECT AVG(p.x) FROM Point p
Forum
17

A nested SELECT

Hello. I have a query UPDATE Look l SET l.partlySold = FALSE WHERE (SELECT count(a) FROM l.things a WHERE a.thing.status != :status) <= 1 which doesn't work: "Unexpected query token 'SELECT'". Does ObjectDB support queries like this? Thanks. Nested queries (issue #11) is currently not supported
Forum
17

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