Ajay Paul

JPQL that includes EXTRACT, such as, ... WHERE EXTRACT (HOUR FROM o.start) BETWEEN ?1 AND ?2 AND EXTRACT (MINUTE FROM o.start)=?3 fails when Java 2 security is enabled because EclipseLink...

EclipseLink NullPointerException Cannot read field "index" because "key" is null

4

**Describe the bug** The JPQL query `SELECT o FROM Account o WHERE (o.accountId=?1)` fails when supplied with an `AccountId` that is an embeddable id for the entity. EclipseLink converts this...

When running a Jakarta Data test against Db2 there is an issue with sorting not always being honored. To recreate, remove the `@SkipIfSysProp(DB_DB2)`in DataTest.java (/io.openliberty.data.internal_fat/fat/src/test/jakarta/data/DataTest.java) ``` @Test @SkipIfSysProp(DB_DB2) //Failing on...

JPQL queries that select ElementCollection attributes have incorrect results

8

**Describe the bug** When JPQL queries select an attribute that is a `ElementCollection` (if using annotations) or `element-collection` (if using XML) and getResultList is used to obtain the result, instead...

When attempting to invoke aggregate functions in JPQL and supplying an argument that omits the optional entity identification variable, such as, ``` SELECT MAX(price) FROM Item SELECT MIN(price) FROM Item...

Describe the bug When Persistence 3.2 is used to query for an entity that has an attribute of type Instant, it gets a DateTimeParseException. See test.jakarta.data.jpa.web.DemographicInfo, which has this attribute:...

JPQL EXTRACT not working on PostgreSQL and Oracle using EclipseLink

14

EclipseLink is generated a SQL query from JPQL to PostgreSQL that is rejected by the database. For example, the JPQL SELECT this.publicDebt / this.numFullTimeWorkers FROM DemographicInfo WHERE EXTRACT (YEAR FROM...

JPQL SELECT query returns incorrect results when running back to back on DB2

5

EclipseLink is returning an empty result list intermittently when running on DB2. For example, the JPQL Query: SELECT this.numFullTimeWorkers FROM DemographicInfo WHERE this.collectedOn=:when When executed on DB2 this query will...

Entity identifier 'this' is broken for comparisons with time

1

This error seems to be related to #2198 (which is closed). But here the comparison is happening between time values instead of numeric values. Query : `SELECT this.numFullTimeWorkers FROM DemographicInfo...

Getting issue when using named query in JPQL Please refer logs : ``` [INFO] [ERROR ] CWWJP0015E: An error occurred in the org.eclipse.persistence.jpa.PersistenceProvider persistence provider when it attempted to create...