The specific issue log output is as follows:

The specific issue log output is as follows:

The specific issue log output is as follows:

I have 2 entities Instructor and Section with many-to-many association between them. The intermediate table is ‘teaches’. I have a query that fetches all instructors of a given department along with their number of sections they taught in a given year. The result is a record defined as

I am learning spring boot and trying to connect to mysql. I write a simple sql query using @Query and @Param. Below is my query.

In my case I m using EntityManager, and I have to update collection type attribute in entities throuph the parent object: