Home » Search

About jpql

81-90 of 133Refresh
Issue
2

JPA Query Criteria API (JPA 2.0)

The JPA Criteria API supports dynamic definition of JPQL queries using CriteriaBuilder as a factory. ObjectDB supports dynamic definition of JPQL queries as strings. Support of the new JPA 2 Criteria API in expected in future versions.   Implementation of the JPA Criteria Query API was just added
Forum
2

Problems down-casting in WHERE clause

in JPQL because messageList is a List and navigation from a list must be done by an additional ... for your query in JPQL or ObjectDB and you should consider workarounds such splitting this query
Forum
2

String representation of a query

Hi, Is it possible to get a JPQL string having a Query object instance? JpaQuery class doesn't have any method like "getQueryString" or "getDatabaseQuery", maybe it's going to be added in near future ... that information with JPQL string and parameters map to find and optimize the most ineffective cases. Following
Forum
2

Help with 'not like/lower' query

on this.   Thanks You are talking about criteria queries but your first query is a JPQL query. Is it the JPQL
Forum
2

New to Product & Having An Issue

something wrong with the use of @Embedded, @EmbeddedId or with my JPQL queries or is this a bug? Any help ... . I am looking now at the JPQL query issues, which might indicate an ObjectDB bug
Forum
2

order by string with numbers

  The sql that works is ORDER BY CAST(SUBSTR(username FROM 4) AS UNSIGNED) ASC Using JPQL SELECT u ... ) then you can try using functions in your query. Integer.parseInt is supported by ObjectDB in JPQL
Forum
2

JPA does not seem to be db agnostic

)); return em.createQuery(query).getSingleResult(); } A valid JPQL query must include SELECT, otherwise the query is incomplete. Some JPA implementations extend the standard JPQL by supporting queries with no SELECT.
Forum
2

native sql queries

queries are not supported because there is no underlying RDBMS. But since SQL and JPQL are very similar it could be possible in future releases to support "native SQL". But JPQL is preferred
Forum
2

Problem with distinct select, order by and equivalent alias/attribute path

invalid from your point of view? Thanks and regards Benjamin Klink JPQL restricts ORDER BY expressions ... to repair that library to generate valid JPQL queries. 1. Even if maybe obsolete because of point 2
Issue
2

[ObjectDB 2.5.5_03] Unexpected exception (Error 990)

if this should be the case with queries (in JPQL or SQL) because expressions are reordered as part of the query optimization. I did some research on this topic. The NULL handling of JPQL or SQL queries