Home » Search

About JPQL

41-50 of 133Refresh
Forum
16

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
16

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
15

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
15

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
Issue
15

JPQL Case Statements (JPA 2.0)

JPQL 2.0 adds support of CASE statements for conditional expressions in queries, similarly to switch/case/default in Java, and based on the SQL syntax. Case statements are currently not supported by ObjectDB. I wish to express also my interest in CASE statement support, which I need for conditional
Issue
15

JPQL Subqueries (JPA 1.0)

The JPQL (Java Persistence Query Language) supports defining subqueries, which are nested queries that are embedded in other queries. Subqueries are currently not supported by ObjectDB, and as a workaround, you can use a sequence of two or more queries, where the results of one query serves as
Forum
15

member visiting in jpql

? TIA The length field of arrays is not supported by JDOQL / JPQL queries. You may maintain an ordinary
Forum
15

Possible issue for JPQL IS EMPTY expression

Possible issue for JPQL IS EMPTY comparison expression: SELECT e FROM MyEntity e WHERE e.collection-valued IS EMPTY throws javax.persistence.PersistenceException: Invalid operand type  for operator IS EMPTY (error 756) Thanks. Note: It doesn' t work with SIZE(): SELECT e FROM MyEntity e WHERE SIZE
Forum
15

Will Entire JPQL Supported by ObjectDb?

management taken care here ? Thanks in Advance , Jana Some JPQL features are not supported yet by
Result
14

Consulting and Training

with ObjectDB and goes to exploring design alternatives, advanced JPQL, using ObjectDB with JEE (EJB