I'm a beginner in Hibernate : I try to use annotations.
In purpose i try to use org.hibernate.annotations.LazyCollectionOption.EXTRA

For that on my entity i annotate one member like that :


The Class CompteEnBanque is a SuperClass(with strategy = InheritanceType.TABLE_PER_CLASS), and their two subclasses are "comptes_epargne" and "comptes_courant",

So when I try to get size of listCpt, I have this SQL query generated by Hibernate :



And i've got this error : org.hibernate.util.JDBCExceptionReporter - Every derived table must have its own alias
Missing an alias on subselect, how i can fix that ?
I use MySQL DB.

Thanks in advance for your help

I found a solution to by-pass the problem but not resolve it!
it Consists to modify inheritance strategy, from TABLE_PER_CLASS to JOINED.
With JOINED strategy each class (even the abstract class) has a table in DB, thereby, when hibernate makes a count query, it doesn't request on an union between subclasses tables but request the table that represent the abstract class.

This a by-pass solution, but not a resolution of my problem if you have an idea, please make a reply.