Встретил на проекте. Зачем sql запрос разделяют плюсами? Например:
String queryString = "select t.user_id, "
+ " u.family, "
+ " u.name, "
+ " u.otch "
+ " from USERS t "
+ " INNER JOIN fio_user u "
+ " ON u.user_id = t.user_id "
+ " WHERE sysdate between t.date_b and t.date_e "
+ " order by u.family, u.name, u.otch";
users = sess.createSQLQuery(queryString)
.addScalar("user_id", StringType.INSTANCE)
.addScalar("family", StringType.INSTANCE)
.addScalar("name", StringType.INSTANCE)
.addScalar("otch", StringType.INSTANCE)
.list();