Hibernate version:

Core 3.2.6 GA
Annotations 3.3.1 GA
Entity Manager 3.3.2 GA

Name and version of the database you are using:

PostgreSQL 8.0.15

Problem

Hi Experts

I have applied the solution as given in http://forum.hibernate.org/viewtopic.php?t=947709 regarding the deeply nested join problem but haven't been able to find a working solution. I keep getting the following exception and have no idea why:

org.postgresql.util.PSQLException: ERROR: table name "comp1x2_" specified more than once

As you can see from the exception I am currently using PostgreSQL for the database but I have also tested the snippet of code with MySQL and obtained a similar MySQL exception. The Hibernate Criteria code snippet producing the exception is as follows:


Any help would be appreciated!

Ristretto

Have you found a solution? I am struggling with the same problem.

Not yet! This is still a major headache for me. I would greatly appreciate any help or nudge in the right direction. I could be using the Criteria API incorrectly although I would have expected a hibernate exception if that were the case. Please help!

I'm posting the last part of the generated SQL for the criteria and hopefully it will help in identifying the problem. Supplier is the superclass of Partner and Provider and I'm using a Joined Table inheritance strategy.