About JPQL

41-50 of 145Refresh
Forum
12

JPA JPQL WHERE clause for IN :variable not working if variable is a list of Enums

Hi, I have a case where I have a JPQL query like: "select o from MyEntity o WHERE (enumField IN :enumFieldList)" And enum field is defined in MyEntity as:     @Enumerated(EnumType.STRING ... understood the JPA JPQL IN clause should work with Enum types - is that the case, or is this an objectdb
Forum
12

JPQL IN Operator

How can I use the standard JPQL IN operator with ObjectDB? This JPQL query works fine with EclipseLink / postgres but throws an exception in objectDB: select distinct dv.creationtime from DataValue dv where dv.capabilityId.capabilityId ==> in <== :capabilities and dv.creationtime
Forum
12

JPQL keyword in entity - what to do?

Hi, I have a problem with entity that is using one of JPQL keywords as one of the fields. It's a 'type' field. When I try to build a query that looks for example like this: select new ResultData(p ... and so on in my entities? It seems as an ObjectDB bug since you should be able to use JPQL keywords
Issue
12

JPQL support for Maps (JPA 2.0)

JPQL 2.0 introduces the ability define FROM variables for map keys and values. Currently ObjectDB supports FROM variables for collection elements. FROM variables for map keys and values are expected ... supported but not map keys. Hi, I've tested both KEY and VALUE statements with JPQL with the latest version
Issue
12

JPQL Update & Delete (JPA 1.0)

JPQL (Java Persistence Query Language) supports updating and deleting database objects by queries. Currently ObjectDB supports only JPQL SELECT (retrieval) queries. Delete queries are supported for JDOQL (JDO Query Language). spring-data-jpa uses delete queries to implement repository.deleteAll
Forum
12

Possible issue for JPQL "LEFT [OUTER] JOIN"

Possible issue for JPQL "LEFT [OUTER] JOIN" is doing "[INNER] JOIN".   Thanks. Thank you for this report. Please try build 2.3.7_18 that should fix this issue. Great and fast solution but it doesn't work with the following JPQL queries string:     - "SELECT a,b FROM A a LEFT OUTER JOIN a.listB b
Forum
12

Possible issue for JPQL IN expression

Possible issue for JPQL IN expression with a set of more than one string literals values in the path expression. Error: Exception in thread "main" [ObjectDB 2.3.7_10] SELECT e FROM MyEntity e WHERE e ... : Unexpected query token ',' (closing ')' is missing)   Thanks This is one of the few elements of JPQL
Forum
12

Show Sql/Jpql

Is there a way to show the executed Sql/Jpql in the console? You can set the log element in ObjectDB configuration to write logging also to the console:     
Forum
12

CASE WHEN...THEN...ELSE...END not working using JPQL/JDOQL

something or is it an issue with ObjectDB? Anyone could help me on how to use the "case" in JPQL? Thank
Forum
12

find repeated records by JPQL

Hi, I know a single command in MySQL can find repeated records: Select * from TTT t where id in (select id from TTT s group id having count(id)>1) I dont know how to do this using JPQL, but I use query from 430,000 records and put them into hashmap, finally it cost one hour and failed