Posts by tag: sql

Mar 2023
March 12	Applying hints to OracleDB subqueries
Oct 2022
October 30	SQL predicates evaluation order
Mar 2022
March 20	Extending locking options with EclipseLink JPQL
March 6	PostgreSQL cursor fetch size (EclipeLink JPA)
Feb 2022
February 20	JPA read-only join table
Jan 2022
January 23	JPA @PostLoad during readOnly (EclipseLink) queries
January 9	JPA (EclipseLink) queries with an unmapped database column
May 2021
May 30	JPQL JOIN FETCH with a condition
May 16	JPQL JOIN FETCH with CursoredStream/ScrollableCursor
Apr 2021
April 18	Native SQL in JPA (EclipseLink) CriteriaBuilder
April 4	JPA (EclipseLink) window functions
Nov 2019
November 17	Snippet for a periodic DB query