Home » Search

About jpql

101-110 of 133Refresh
Issue
1

Different behavior for casting and not casting

part of JPQL and rarely used I am afraid it might not be the last problem that you find. Please continue with build 2.3.6_13. quasado
Forum
1

dual access

direct SQL coding? ObjectDB doesn't support SQL but JDOQL and JPQL (the later is very similar to SQL). Queries can be logged before execution. cpanon
Forum
1

Entity with java.util.Date column gives ClassCastException in BIRT

Copied a straightforward entity class from my coleague. Using Eclipse Kepler (Reporting) and stored it in ObjectDB 2.5.3_02. After creating an ObjectDB BIRT DataSource and a DataSet, entered a simple JPQL query to select the fields. Entity looks like this: package entity; import java.util.Date
Forum
1

Handling "is null" in where clause

Greetings, I was playing aroung with JPQL and have found that there is a problem with "is null" queries. When you use "is null" in where clause, query runs correctly, but results are incorrect. Let me show you an example: - entity @Entity public class EntityA {     @Id     Integer id
Forum
1

How do I achieve a Deep Fetch using JOIN FETCH?

know that I can express one level of eager fetch in JPQL as follows: SELECT c FROM C JOIN FETCH c
Forum
1

how explorer queries work

JPQL query and it certainly doesn't have my object model available to it. does
Forum
1

How to query for list of lists ?

You cannot select a list, so this is an invalid JPQL query. SELECT s FROM PulseDataWareHouse w JOIN w
Forum
1

How to use JOIN FETCH?

The ObjectDB manual (http://www.objectdb.com/java/jpa/query/jpql/from) gives an example of using JOIN FETCH to avoid excessive round trips to the database: SELECT c FROM Country c JOIN FETCH c.capital I've tried a few variants of the following example, and haven't been able to get this to work
Forum
1

Is named-query supported in orm.xml

I prefer to keep custom JPQL named queries in an external file, e.g. orm.xml, rather than in the entity classes, for example: delete from DataValue d where d.capabilityId = :capabilityId
Forum
1

JPA query of a Set of terms

.setParameter("terms", terms); but it is not standard JPQL and it would be less efficient since indexes