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