| I am the original reporter (different account / email address now). I have updated my testcase project with new versions of dependencies for hibernate, spring framework, and other components, and verified that the query produced is correct: select device0_.id as id1_0_0_, device0_.row_version as row_vers2_0_0_, device0_.description as descript3_0_0_, device0_.calibrated as calibrat4_0_0_, device0_.address as address5_0_0_, device0_.device_group_id as device_g6_0_0_, device0_.device_index as device_i7_0_0_, device0_.device_type_id as device_t8_0_0_, deviceprop1_.device_id as device_i1_2_1_, deviceprop2_.id as property2_2_1_, deviceprop2_.id as id1_1_2_, deviceprop2_.row_version as row_vers2_1_2_, deviceprop2_.property_type_id as property4_1_2_, deviceprop2_.prop_value as prop_val3_1_2_, deviceprop2_1_.device_id as device_i1_2_2_, propertyty3_.id as id1_6_3_, propertyty3_.row_version as row_vers2_6_3_, propertyty3_.description as descript3_6_3_, propertyty3_.prop_key as prop_key4_6_3_, propertyty3_.prop_type as prop_typ5_6_3_, devicetype4_.id as id1_3_4_, devicetype4_.row_version as row_vers2_3_4_, devicetype4_.description as descript3_3_4_, devicetype4_.vendor_id as vendor_i4_3_4_ from device device0_ left outer join device_property_xref deviceprop1_ on device0_.id=deviceprop1_.device_id left outer join device_property deviceprop2_ on deviceprop1_.property_id=deviceprop2_.id left outer join device_property_xref deviceprop2_1_ on deviceprop2_.id=deviceprop2_1_.property_id left outer join property_type propertyty3_ on deviceprop2_.property_type_id=propertyty3_.id left outer join device_type devicetype4_ on device0_.device_type_id=devicetype4_.id where device0_.id=807 order by deviceprop2_.id asc To update, my environment now consists of: Mac OSX, MySQL 5.7, Eclipse Neon with embedded Maven, Hibernate 5.0.5.Final (also tried with 5.1.5.Final and 5.2.10.Final), MySQL Connector 6.0.5. I will attach the code for the new testcase in a moment with the latest version as of writing (5.2.10.Final – which took a little effort to change out deprecated classes), but I believe this can be marked as resolved now! |