Home » Search

About jpql

31-40 of 133Refresh
Manual
19

Retrieving JPA Entity Objects

queries. The official query language of JPA is JPQL (Java Persistence Query Language). It enables ... . JPA queries and JPQL are described in chapter 4. Retrieval by Refresh Managed objects can be reloaded
Forum
16

JPQL JOIN FETCH Error

Hello I get an error when executing the following JPQL query: select doi from Doi doi left join ... works on Hibernate with Oracle / MySQL / Postgres, so I'm assuming the JPQL is valid. Any ideas? Thanks John The query is not a valid JPQL query since JOIN FETCH should be followed by a path
Forum
16

Modifying something with Explorer -> app JPQL with Enum doesn't work anymore

after that kind of usage of Explorer makes JPQL with Enum to don't work properly. That's why I spent ... the problem. The problem is that redeploying the application after that kind of usage of Explorer makes JPQL ... without any application. What happens when you run that JPQL query in the Explorer? In
Forum
15

Delete object from collection versus delete from JPQL

persist() to write them to the database.  But does running a JPQL update or delete alter the in-memory objects? There are cases where the JPQL syntax is more expressive than operating on a collection
Forum
15

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
15

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
15

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
15

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
15

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
15

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