This is an automated email from the git hooks/post-receive script. New commit to branch develop in repository topia. See http://git.nuiton.org/topia.git commit bd3ce60b081728432f59500864db6d37a3b8161e Author: Tony CHEMIT <chemit@codelutin.com> Date: Sat Apr 11 06:43:25 2015 +0200 refs #3672 Improve query --- .../org/nuiton/topia/generator/EntityDAOTransformer.java | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) diff --git a/topia-persistence/src/main/java/org/nuiton/topia/generator/EntityDAOTransformer.java b/topia-persistence/src/main/java/org/nuiton/topia/generator/EntityDAOTransformer.java index 9fff739..7a90f60 100644 --- a/topia-persistence/src/main/java/org/nuiton/topia/generator/EntityDAOTransformer.java +++ b/topia-persistence/src/main/java/org/nuiton/topia/generator/EntityDAOTransformer.java @@ -626,11 +626,13 @@ public class EntityDAOTransformer extends ObjectModelTransformerToJava { /*{ { List<<%=attrType%>> list = getContext().getHibernate().createSQLQuery( - "SELECT main.* " + - "from <%=attrClassifierDBName%> main, <%=attrJoinTableName%> secondary " + - "where main.topiaid=secondary.<%=attrDBName%>" + - " and secondary.<%=attrReverseDBName%>='" + entity.getTopiaId() + "'") - .addEntity("main", <%=providerFQN%>(<%=attrType%>.class)).list(); + " SELECT main.*" + + " FROM <%=attrClassifierDBName%> main, <%=attrJoinTableName%> secondary" + + " WHERE main.topiaid = secondary.<%=attrDBName%>" + + " AND secondary.<%=attrReverseDBName%> = ?") + .addEntity("main", <%=providerFQN%>(<%=attrType%>.class)) + .setString(0, entity.getTopiaId()) + .list(); for (<%=attrType%> item : list) { item.<%=removeName%>(entity); -- To stop receiving notification emails like this one, please contact nuiton.org SCM administrator <admin+scm@nuiton.org>.