You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@syncope.apache.org by md...@apache.org on 2016/01/14 11:01:13 UTC
syncope git commit: [SYNCOPE-735] Deleting unused ACT_GE_BYTEARRAY
entries
Repository: syncope
Updated Branches:
refs/heads/1_2_X e9d7d2d96 -> 5b0bbfcfb
[SYNCOPE-735] Deleting unused ACT_GE_BYTEARRAY entries
Project: http://git-wip-us.apache.org/repos/asf/syncope/repo
Commit: http://git-wip-us.apache.org/repos/asf/syncope/commit/5b0bbfcf
Tree: http://git-wip-us.apache.org/repos/asf/syncope/tree/5b0bbfcf
Diff: http://git-wip-us.apache.org/repos/asf/syncope/diff/5b0bbfcf
Branch: refs/heads/1_2_X
Commit: 5b0bbfcfbe4aaeee3a370bb418af727dfcd616be
Parents: e9d7d2d
Author: Marco Di Sabatino Di Diodoro <md...@apache.org>
Authored: Thu Jan 14 11:00:55 2016 +0100
Committer: Marco Di Sabatino Di Diodoro <md...@apache.org>
Committed: Thu Jan 14 11:00:55 2016 +0100
----------------------------------------------------------------------
.../workflow/user/activiti/ActivitiUserWorkflowAdapter.java | 9 +++++++++
1 file changed, 9 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/syncope/blob/5b0bbfcf/core/src/main/java/org/apache/syncope/core/workflow/user/activiti/ActivitiUserWorkflowAdapter.java
----------------------------------------------------------------------
diff --git a/core/src/main/java/org/apache/syncope/core/workflow/user/activiti/ActivitiUserWorkflowAdapter.java b/core/src/main/java/org/apache/syncope/core/workflow/user/activiti/ActivitiUserWorkflowAdapter.java
index 1d06195..be2ba97 100644
--- a/core/src/main/java/org/apache/syncope/core/workflow/user/activiti/ActivitiUserWorkflowAdapter.java
+++ b/core/src/main/java/org/apache/syncope/core/workflow/user/activiti/ActivitiUserWorkflowAdapter.java
@@ -253,6 +253,15 @@ public class ActivitiUserWorkflowAdapter extends AbstractUserWorkflowAdapter {
update.append("AND TASK_ID_<>'").append(taskId).append("' ");
}
jdbcTemplate.execute(update.toString());
+
+ List<String> byteArrayIds = jdbcTemplate.queryForList(
+ "SELECT BYTEARRAY_ID_ FROM ACT_HI_VARINST WHERE BYTEARRAY_ID_ IS NOT NULL", String.class);
+ update.setLength(0);
+ update.append("DELETE FROM ACT_GE_BYTEARRAY WHERE NAME_ LIKE 'hist.%' ");
+ for (String byteArrayId : byteArrayIds) {
+ update.append("AND ID_<>'").append(byteArrayId).append("' ");
+ }
+ jdbcTemplate.execute(update.toString());
}
/**