details:   https://code.openbravo.com/erp/devel/pi/rev/25ca6b41ced0
changeset: 30568:25ca6b41ced0
user:      Augusto Mauch <augusto.mauch <at> openbravo.com>
date:      Wed Nov 02 15:08:53 2016 +0100
summary:   Related with issue 34323: Supports adding columns to 
AD_SESSION_STATUS

The TriggerHandler.disable methods inserts a row in AD_SESSION_STATUS to 
soft-disable the triggers. The problem is that the insert statement did not 
include the list of columns names in the INSERT statement, resulting in the 
statemeng failing if any module adds a new column to the AD_SESSION_STATUS 
table.

diffstat:

 src/org/openbravo/dal/core/TriggerHandler.java |  3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diffs (13 lines):

diff -r ff63adfc11bd -r 25ca6b41ced0 
src/org/openbravo/dal/core/TriggerHandler.java
--- a/src/org/openbravo/dal/core/TriggerHandler.java    Wed Nov 02 10:26:46 
2016 +0100
+++ b/src/org/openbravo/dal/core/TriggerHandler.java    Wed Nov 02 15:08:53 
2016 +0100
@@ -65,7 +65,8 @@
     PreparedStatement ps = null;
     try {
       ps = con
-          .prepareStatement("INSERT INTO AD_SESSION_STATUS VALUES (get_uuid(), 
'0', '0', 'Y', now(), '0', now(), '0', 'Y')");
+          .prepareStatement("INSERT INTO AD_SESSION_STATUS 
(ad_session_status_id, ad_client_id, ad_org_id, isactive, created, createdby, 
updated, updatedby, isimporting)"
+              + " VALUES (get_uuid(), '0', '0', 'Y', now(), '0', now(), '0', 
'Y')");
       ps.executeUpdate();
       sessionStatus.set(Boolean.TRUE);
     } catch (Exception e) {

------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to