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