JPQL Exercices

Ensure you can display SQL requests made by JPA:

for hibernate:

      <property name="hibernate.show_sql" value="true"/>
    

for eclipselink

      <property name="eclipselink.logging.level" value="FINE"/>
    

Write and test the following requests.

• get all courses taught to "1year" student group.
• get all courses with programming as a domain
• get all courses with programming and system as a domain (you might want to add one such course to the database first). Use JOIN
• same request, but use the "member of" operator in the "WHERE" part
• look at the SQL code produced for the previous entries