details:   https://code.openbravo.com/erp/devel/pi/rev/d6522f4e28ae
changeset: 15572:d6522f4e28ae
user:      Augusto Mauch <augusto.mauch <at> openbravo.com>
date:      Wed Feb 22 19:12:30 2012 +0100
summary:   Fixes issue 19839: The Exception is now being caught

diffstat:

 
modules/org.openbravo.client.application/src/org/openbravo/client/application/AlertActionHandler.java
 |  16 ++++++---
 1 files changed, 11 insertions(+), 5 deletions(-)

diffs (33 lines):

diff -r 0af5219235d1 -r d6522f4e28ae 
modules/org.openbravo.client.application/src/org/openbravo/client/application/AlertActionHandler.java
--- 
a/modules/org.openbravo.client.application/src/org/openbravo/client/application/AlertActionHandler.java
     Wed Feb 22 18:57:38 2012 +0100
+++ 
b/modules/org.openbravo.client.application/src/org/openbravo/client/application/AlertActionHandler.java
     Wed Feb 22 19:12:30 2012 +0100
@@ -33,6 +33,7 @@
 import org.codehaus.jettison.json.JSONObject;
 import org.hibernate.Query;
 import org.hibernate.SQLQuery;
+import org.hibernate.exception.SQLGrammarException;
 import org.openbravo.base.secureApp.VariablesSecureApp;
 import org.openbravo.client.kernel.BaseActionHandler;
 import org.openbravo.client.kernel.RequestContext;
@@ -108,11 +109,16 @@
             .addEntity(Alert.ENTITY_NAME);
         sqlQuery.setParameter(0, alertRule.getId());
         final DataToJsonConverter converter = new DataToJsonConverter();
-        log4j.debug("Alert " + alertRule.getName() + " (" + alertRule.getId() 
+ ") - SQL:'" + sql
-            + "' - Rows: " + sqlQuery.list().size());
-        for (Object alertObject : sqlQuery.list()) {
-          final Alert alert = (Alert) alertObject;
-          alertJsonObjects.add(converter.toJsonObject(alert, 
DataResolvingMode.FULL));
+        try {
+          log4j.debug("Alert " + alertRule.getName() + " (" + 
alertRule.getId() + ") - SQL:'" + sql
+              + "' - Rows: " + sqlQuery.list().size());
+          for (Object alertObject : sqlQuery.list()) {
+            final Alert alert = (Alert) alertObject;
+            alertJsonObjects.add(converter.toJsonObject(alert, 
DataResolvingMode.FULL));
+          }
+        } catch (SQLGrammarException e) {
+          log4j.error("An error has ocurred when trying to process the alerts: 
" + e.getMessage(),
+              e);
         }
       }
       result.put("cnt", alertJsonObjects.size());

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to