details: https://code.openbravo.com/erp/devel/pi/rev/2b071325db7c
changeset: 34233:2b071325db7c
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Thu Jun 14 06:34:24 2018 +0530
summary: Fixes Issue 38735: incorrect query in ReservationUtils
HQL query in getReservationStockFromStorageDetail method
in ReservationUtils.java had ")" end brace at end with out
"(" start brace in the query. This is not correct but was
allowed in hibernate version 3.6, but hibernate version 5.3
does not allow such error in query. Hence the query is modified
by removing the ")" end brace.
diffstat:
src/org/openbravo/materialmgmt/ReservationUtils.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (21 lines):
diff -r 668c2f40ea20 -r 2b071325db7c
src/org/openbravo/materialmgmt/ReservationUtils.java
--- a/src/org/openbravo/materialmgmt/ReservationUtils.java Tue Jun 26
09:42:07 2018 +0200
+++ b/src/org/openbravo/materialmgmt/ReservationUtils.java Thu Jun 14
06:34:24 2018 +0530
@@ -11,7 +11,7 @@
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
- * All portions are Copyright (C) 2012-2017 Openbravo SLU
+ * All portions are Copyright (C) 2012-2018 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
*************************************************************************
@@ -266,7 +266,7 @@
hql.append(" and coalesce(rs.storageBin, r.storageBin) = :storageBin");
hql.append(" and coalesce(rs.attributeSetValue, r.attributeSetValue) =
:attributeSetValue");
hql.append(" and r.uOM = :uom");
- hql.append(" and rs.quantity > rs.released)");
+ hql.append(" and rs.quantity > rs.released");
Query query = OBDal.getInstance().getSession().createQuery(hql.toString());
query.setParameter("product", storageDetail.getProduct());
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
