grails « SQL « JPA Q&A

1. hibernate AssertionFailure from a grails project

I am getting an error that begins as follows below. Is this something to do with the way my cascades are set up? Where is the proper place to start investigating? ...

2. Grails HQL vs SQL Statements

I would like an opinion about querying the database using HQL or SQL Statements, concerning simplicity, complexity and performance.

3. How to do a Union SQL statement in HQL?

I'm trying to create a Union between two tables, using HQL (Hibernate Query Language). This SQL script works fine on my SQL server:

SELECT COUNT(DISTINCT linkedin_id) as test, school_name