After upgrading from Hibernate 5 to Hibernate 6, a native query that used to work now fails with an “ORA-17006: Invalid column name” error. Entity definitions Base class: @Entity @Table(name = "...

In one of my Spring Data JPA repositories I have this native query (PostgreSQL): @Query(value = "SELECT * FROM ballots b WHERE b.companies && :companyIds and b.meeting_id in :meetingIds&...

I have the following Spring Data JPA repository method using a native query with an aliased column that does not exist physically in the database table: @Repository public interface ...

I'm executing a PostgreSQL query in Kotlin using prepareNativeQuery and passing named parameters like this: prepareNativeQuery(sbConsulta, Tuple::class.java) .setParameter("UNIDADE", ...

I made a native query: @NamedNativeQuery( name = "getting_some_objects_native_query", query = "some query", resultSetMapping = "some_object_mapper"...

I'm working on a Spring Data JPA application that connects to SQL Server and uses H2 for integration testing (JUnit). I have a native SQL query that uses the SQL Server DATENAME function, like this: ...

Hibernate 5.6.15.Final I have 2 entities with 1-to-1 relationship, both have audit fields "createdBy", "modifiedBy", "createdDate", "modifiedDate". class ...

I'm adding a new column - uuid with varchar(36) type in Oracle DB. I had a search query that searched by ids, now I need to add a similar query but using uuids instead. @Column(name = "UUID")...

I'm trying to use EclipseLink as a JPA provider in a Spring Boot 3 app. I seem to be missing something, as Query.setParameter() is not able to set named (:param) or enumerated (?1) parameters. This ...

I am trying to run a JPA native query which will INSERT data in a postgres database. However I am getting the following error : Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value ...

I've found very interesting but not implemented method in some CoreDao Interface: import org.apache.commons.lang3.tuple.Pair; import javax.management.Query; import java.util.List; import java.util....

I need to update the values into update native query from EmployeeDTO class and I have used following implemetation. But I got this error in console, even though the syntax is correct for query: ...

Help Needed: Perform a Nested Aggregation with Spring Data Elasticsearch 5.2.6 and Elasticsearch-rest-client 8.10 I'm working on a project using Elasticsearch with Spring Data Elasticsearch 5.2.6, and ...

Specification: Firebird 2.5, Hibernate 6.2 or 6.5 - yes I know this is odd composition since Firebird 2.5 is pretty outdated but for a while I have to live with it. When I call custom method in ...

Configuration: Firebird 2.5, Hibernate 6.2 or 6.5 When I call custom method in PagingAndSortingRepository with Pageable object set to page > 0 the generated statement has misplaced first and skip ...