[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3307) HQL query translation in real SQL ignores the dialect class

[ https://hibernate.onjira.com/browse/HHH-3307?page=com.atlassian.jira.plug... ] Robert Rodehorst commented on HHH-3307: --------------------------------------- Confirmed this issue by modifying HXTT's Microsoft Access dialect with the following transformSelectString function: {code:title=com.hxtt.support.hibernate.HxttAccessDialect.java|borderStyle=solid} public String transformSelectString(String select) { select = super.transformSelectString(select); // Find all joins int count = 0; int idx = 0; String sub = " join "; while((idx = select.indexOf(sub, idx)) != -1) { count++; idx += sub.length(); } // Remove "outer" keywords and add nested parentheses if (count > 0) { select = select.replaceAll(" left outer join ", ") left join "); select = select.replaceAll(" right outer join ", ") right join "); select = select.replaceAll(" inner join ", ") inner join "); select = select.replaceAll(" from ", " from " + StringHelper.repeat('(', count)); } return select; } {code} As mentioned in the original report, this works fine for loading Hibernate mappings. However, executing HQL queries with more than one join results in syntax errors, as the nested parentheses required for Access queries never get applied. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira