How to express WITH clause in Spring Data relational JDBC?
I would like to write a CTE and/or With clause using the SelectBuilderor Query builder from the project Spring Data Relational.
Spring Data JDBC Set vs List in One To Many Relationship
My one-to-many relationship works fine as a Set, but if I change to a List then I encounter errors. I’m using an H2 database, but also tried an Oracle DB and saw a similar error.
Spring Data JDBC @Query method returning null when filtering on varchar2 column in Oracle DB
I am trying to setup connections to query a ready only database using Spring Data JDBC. My interface looks something like the following