[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5810) Database MYSQL supports recursive but populate doesn't work

Database MYSQL supports recursive but populate doesn't work ----------------------------------------------------------- Key: HHH-5810 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5810 Project: Hibernate Core Issue Type: Task Components: query-sql Affects Versions: 3.3.0.GA Environment: Hibernate 3.3.0 GA, MySQL 5.1.41 Reporter: Raul Romanillos Llorente After running on the screen we see that the field_3 field_1 fields have the same value. Hibernate has the same value assigned to the fields valueField_1, valueField_2 and valueField_3 and the database are different values. Hibernate did not return good results with createSQLQuery (query). ... String query = "SELECT i.id_route, i.route_name, ii.route_name, iii.route_name,"; query += " FROM routes i"; query += " LEFT JOIN routes ii ON i.id_route_parent=i.id_route"; query += " LEFT JOIN routes iii ON ii.id_route_parent=iii.id_route tx = session.getTransaction(); tx.begin(); result = session.createSQLQuery(query).list(); tx.commit();"; String valueField_0, valueField_1, valueField_2, valueField_3; if (result!=null) { for (Object obj: result) { Object [] cols= (Object []) irObj; valueField_0=(cols[0]!=null?cols[0].toString():""); valueField_1=(cols[1]!=null?cols[1].toString():""); valueField_2=(cols[2]!=null?cols[2].toString():""); valueField_3=(cols[3]!=null?cols[3].toString():""); System.out.println("field_1:"+valueField_1+"\nfield_2:"+valueField_2+"\nfield_3:"+valueField_3); } }