hibernate-entitymanager Questions

Postgresql – Getting an error 'Multiple ResultSets were returned" while running multiple select queries via JPA EntityManager

November 26, 2023
ParthDobariya
3 Answers

To achieve better performance by reducing multiple DB calls, I want to execute multiple select queries in the same DB call. I'm using PostgresSQL database (version 14.9), Java (version 17) and Springboot (version 3.0.6). Here is my code: private final…

VIEW QUESTION

insert the list parameter into the nativeQuery – Postgresql

December 22, 2022
pawello12
2 Answers

I have a query like this that works well : "SELECT * FROM elements we WHERE jsonb_exists_all(CAST(we.elements AS jsonb), ARRAY['TEST'])" I need to use the .setParameter method from EntityManager to insert a whole array instead of ["CHEST"] e.g. ["TEST", "TEST1",…

VIEW QUESTION