About SELECT

191-200 of 200Refresh
JDO Doc
2

javax.jdo.Query

should be a String containing a SQL SELECT statement. Since: JDO 2.0   void addExtension(String key
Forum
1

em.flush(); em.clear(); loosing data and not persisting managed objects

="SELECT MAX($1.addDate) FROM Notes $1 WHERE $1.addDate IS NOT NULL" args="null" transactionId="-1" /> [2011-05-05 22:28:02 #133 query.tokenizer]
Forum
1

How to query for list of lists ?

. Here's the example : Query query = em.createQuery("SELECT i.filterDescription FROM Inspiration i ... directly in the SELECT clause. But this should work: SELECT f FROM Inspiration i JOIN i ... > reviewSnippets; ...   Finally the query is:  SELECT w.reviewSnippets FROM PulseDataWareHouse w
Issue
1

JPQL support for mapped by (inverse) collections

query = em.createQuery(         //    "SELECT a FROM A a WHERE a.list IS EMPTY");         //System.out.println(query.getResultList().size());         // SELECT a FROM A a WHERE a.list IS NOT EMPTY         List list1 = em.createQuery(             "SELECT DISTINCT b.a FROM B b", A.class
Forum
1

Listing large number of complicated objects with paging.

with such a simple query: select prod from Product prod order by prod.id ASC Right now I have 55541 ... .createQuery("select prod from Product prod order by prod.id ASC", Product.class); prodList = icQuery ... .578 [http-bio-8080-exec-3] DEBUG pl.hplxtool.dao.impl.ProductDAOImpl - Query: [select prod from
Forum
1

New to Product & Having An Issue

({ @NamedQuery(name="Department.findAll", query="SELECT d FROM Department AS d"), @NamedQuery(name="Department.byName", query="SELECT d from Department AS d WHERE d.name = :name"), @NamedQuery(name="Department.findByCmpPK", query="SELECT d FROM test.Domain.Department AS d
Forum
1

No clue how to query with collection

> getAddresses(); } Now what I want to do is to select all available Customer Entites and ORDER them by ... null). So I want something like this: SELECT c, a FROM Customer INNER JOIN c.addresses ORDER BY ... that selecting the first item of a collection ain't be a good idea. now I can select the right item
Forum
1

Strange behaviour with ORDER BY and IN

("Locations without selection criterion in descending order (by id): ");         em.createQuery("select ... selection criterion ON ID-FIELD in descending order (by id): ");         em.createQuery("select l from ... ("\nLocations with IN selection criterion ON NON-ID-FIELD in descending order (by town): ");         em
Forum
1

Problem with entities detection

") @XmlRootElement @NamedQueries({ @NamedQuery(name = "Alumno_odb.findAll", query = "SELECT a FROM Alumno a") , @NamedQuery(name = "Alumno_odb.findByDni", query = "SELECT a FROM Alumno a WHERE a.dni = :dni") , @NamedQuery(name = "Alumno_odb.findByNombre", query = "SELECT a FROM Alumno
Forum
1

Criteria Query results in a NoResultException instead of returning object

); criteria.select(root); List predicates = new ArrayListSELECT $1 FROM IdentityObject $1 ... to the following JPQL query: SELECT $1 FROM IdentityObject $1 WHERE $1.name='demo' You have to use