This is an automated email from the ASF dual-hosted git repository.
egonzalez pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-kie-kogito-apps.git
The following commit(s) were added to refs/heads/main by this push:
new d604b2b83 [incubator-kie-issues-812] Adding indexes and scripts to
data audit to avoid the use of hibernate flag. (#1948)
d604b2b83 is described below
commit d604b2b83435ddcb44023e90d7d63542956b4256
Author: Enrique <[email protected]>
AuthorDate: Tue Jan 16 08:43:25 2024 +0100
[incubator-kie-issues-812] Adding indexes and scripts to data audit to
avoid the use of hibernate flag. (#1948)
* [incubator-kie-issues-812] Adding indexes and scripts to data audit to
avoid the use of hibernate flag.
* remove duplicate database sccript
---
.../app/audit/jpa/model/JobExecutionLog.java | 8 ++-
.../audit/jpa/model/ProcessInstanceErrorLog.java | 8 ++-
.../audit/jpa/model/ProcessInstanceNodeLog.java | 8 ++-
.../audit/jpa/model/ProcessInstanceStateLog.java | 9 ++-
.../jpa/model/ProcessInstanceVariableLog.java | 9 ++-
.../jpa/model/UserTaskInstanceAssignmentLog.java | 31 +++-------
.../jpa/model/UserTaskInstanceAttachmentLog.java | 9 ++-
.../jpa/model/UserTaskInstanceCommentLog.java | 9 ++-
.../jpa/model/UserTaskInstanceDeadlineLog.java | 11 +++-
.../audit/jpa/model/UserTaskInstanceStateLog.java | 10 +++-
.../jpa/model/UserTaskInstanceVariableLog.java | 9 ++-
.../app/audit/jpa/queries/JPAAbstractQuery.java | 6 ++
.../src/main/resources/META-INF/data-audit-orm.xml | 2 +-
.../h2/V1.0.0__CREATE DATA AUDIT SCHEMA.sql | 70 ++++++++++++++++++++++
.../V1.0.0__CREATE DATA AUDIT SCHEMA.sql | 70 ++++++++++++++++++++++
.../pom.xml | 14 +++++
16 files changed, 248 insertions(+), 35 deletions(-)
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/JobExecutionLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/JobExecutionLog.java
index 450b112a4..2c1e729c5 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/JobExecutionLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/JobExecutionLog.java
@@ -26,13 +26,19 @@ import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
import jakarta.persistence.Temporal;
import jakarta.persistence.TemporalType;
@Entity
-@Table(name = "Job_Execution_Log")
+@Table(name = "Job_Execution_Log",
+ indexes = {
+ @Index(name = "ix_jel_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_jel_jid", columnList = "job_id"),
+ @Index(name = "ix_jel_status", columnList = "status")
+ })
@SequenceGenerator(name = "jobExecutionHistoryIdSeq", sequenceName =
"JOB_EXECUTION_HISTORY_ID_SEQ")
public class JobExecutionLog {
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceErrorLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceErrorLog.java
index 532b55d65..7f24acae3 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceErrorLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceErrorLog.java
@@ -27,6 +27,7 @@ import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
import jakarta.persistence.Transient;
@@ -34,7 +35,12 @@ import jakarta.persistence.Transient;
import static
org.kie.kogito.app.audit.jpa.model.ModelConstants.ERROR_LOG_LENGTH;
@Entity
-@Table(name = "Process_Instance_Error_Log")
+@Table(name = "Process_Instance_Error_Log",
+ indexes = {
+ @Index(name = "ix_piel_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_piel_key", columnList = "business_key"),
+ @Index(name = "ix_piel_event_date", columnList = "event_date")
+ })
@SequenceGenerator(name = "processInstanceErrorHistorySeq", sequenceName =
"PROCESS_INSTANCE_ERROR_LOG_SEQ_ID")
public class ProcessInstanceErrorLog extends AbstractProcessInstanceLog {
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceNodeLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceNodeLog.java
index 0aeaf06e7..21edd62e9 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceNodeLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceNodeLog.java
@@ -28,13 +28,19 @@ import jakarta.persistence.Enumerated;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
import jakarta.persistence.Temporal;
import jakarta.persistence.TemporalType;
@Entity
-@Table(name = "Process_Instance_Node_Log")
+@Table(name = "Process_Instance_Node_Log",
+ indexes = {
+ @Index(name = "ix_pinl_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_pinl_key", columnList = "business_key"),
+ @Index(name = "ix_pinl_event_date", columnList = "event_date")
+ })
@SequenceGenerator(name = "processInstanceNodeLogIdSeq", sequenceName =
"PROCESS_INSTANCE_NODE_LOG_ID_SEQ")
public class ProcessInstanceNodeLog extends AbstractProcessInstanceLog {
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceStateLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceStateLog.java
index 96f47f6ef..88bb58139 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceStateLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceStateLog.java
@@ -32,6 +32,7 @@ import jakarta.persistence.ForeignKey;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.JoinColumn;
import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
@@ -39,7 +40,13 @@ import jakarta.persistence.Temporal;
import jakarta.persistence.TemporalType;
@Entity
-@Table(name = "Process_Instance_State_Log")
+@Table(name = "Process_Instance_State_Log",
+ indexes = {
+ @Index(name = "ix_pisl_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_pisl_state", columnList = "state"),
+ @Index(name = "ix_pisl_key", columnList = "business_key"),
+ @Index(name = "ix_pisl_event_date", columnList = "event_date")
+ })
@SequenceGenerator(name = "processInstanceStateLogIdSeq", sequenceName =
"PROCESS_INSTANCE_STATE_LOG_ID_SEQ")
public class ProcessInstanceStateLog extends AbstractProcessInstanceLog {
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceVariableLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceVariableLog.java
index 76a528460..b04905a62 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceVariableLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/ProcessInstanceVariableLog.java
@@ -27,12 +27,19 @@ import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
import jakarta.persistence.Transient;
@Entity
-@Table(name = "Process_Instance_Variable_Log")
+@Table(name = "Process_Instance_Variable_Log",
+ indexes = {
+ @Index(name = "ix_pivl_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_pivl_key", columnList = "business_key"),
+ @Index(name = "ix_pivl_event_date", columnList = "event_date"),
+ @Index(name = "ix_pivl_var_id", columnList = "variable_id")
+ })
@SequenceGenerator(name = "processInstanceVariableLogIdSeq", sequenceName =
"PROCESS_INSTANCE_VARIABLE_LOG_ID_SEQ")
public class ProcessInstanceVariableLog extends AbstractProcessInstanceLog {
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceAssignmentLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceAssignmentLog.java
index dd54c7415..078a348d7 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceAssignmentLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceAssignmentLog.java
@@ -29,12 +29,19 @@ import jakarta.persistence.ForeignKey;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.JoinColumn;
import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
@Entity
-@Table(name = "Task_Instance_Assignment_Log")
+@Table(name = "Task_Instance_Assignment_Log",
+ indexes = {
+ @Index(name = "ix_utasl_utid", columnList =
"user_task_instance_id"),
+ @Index(name = "ix_utasl_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_utasl_key", columnList = "business_key"),
+ @Index(name = "ix_utasl_event_date", columnList = "event_date")
+ })
@SequenceGenerator(name = "taskInstanceAssignmentLogIdSeq", sequenceName =
"TASK_INSTANCE_ASSIGNMENT_LOG_ID_SEQ")
public class UserTaskInstanceAssignmentLog extends AbstractUserTaskInstanceLog
{
@@ -42,12 +49,6 @@ public class UserTaskInstanceAssignmentLog extends
AbstractUserTaskInstanceLog {
@GeneratedValue(strategy = GenerationType.AUTO, generator =
"taskInstanceAssignmentLogIdSeq")
private Long id;
- @Column(name = "task_definition_id")
- private String userTaskDefinitionId;
-
- @Column(name = "task_instance_id")
- private String userTaskInstanceId;
-
@Column(name = "task_name")
private String userTaskName;
@@ -68,22 +69,6 @@ public class UserTaskInstanceAssignmentLog extends
AbstractUserTaskInstanceLog {
this.id = id;
}
- public String getUserTaskDefinitionId() {
- return userTaskDefinitionId;
- }
-
- public void setUserTaskDefinitionId(String userTaskDefinitionId) {
- this.userTaskDefinitionId = userTaskDefinitionId;
- }
-
- public String getUserTaskInstanceId() {
- return userTaskInstanceId;
- }
-
- public void setUserTaskInstanceId(String userTaskInstanceId) {
- this.userTaskInstanceId = userTaskInstanceId;
- }
-
public String getUserTaskName() {
return userTaskName;
}
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceAttachmentLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceAttachmentLog.java
index 0794d471f..c60c56103 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceAttachmentLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceAttachmentLog.java
@@ -26,11 +26,18 @@ import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
@Entity
-@Table(name = "Task_Instance_Attachment_Log")
+@Table(name = "Task_Instance_Attachment_Log",
+ indexes = {
+ @Index(name = "ix_utatl_utid", columnList =
"user_task_instance_id"),
+ @Index(name = "ix_utatl_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_utatl_key", columnList = "business_key"),
+ @Index(name = "ix_utatl_event_date", columnList = "event_date")
+ })
@SequenceGenerator(name = "taskInstanceAttachmentLogIdSeq", sequenceName =
"TASK_INSTANCE_ATTACHMENT_LOG_ID_SEQ")
public class UserTaskInstanceAttachmentLog extends AbstractUserTaskInstanceLog
{
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceCommentLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceCommentLog.java
index 3992b2fd6..82a43a651 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceCommentLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceCommentLog.java
@@ -24,11 +24,18 @@ import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
@Entity
-@Table(name = "Task_Instance_Comment_Log")
+@Table(name = "Task_Instance_Comment_Log",
+ indexes = {
+ @Index(name = "ix_utcl_utid", columnList =
"user_task_instance_id"),
+ @Index(name = "ix_utcl_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_utcl_key", columnList = "business_key"),
+ @Index(name = "ix_utcl_event_date", columnList = "event_date")
+ })
@SequenceGenerator(name = "taskInstanceCommentLogIdSeq", sequenceName =
"TASK_INSTANCE_COMMENT_LOG_ID_SEQ")
public class UserTaskInstanceCommentLog extends AbstractUserTaskInstanceLog {
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceDeadlineLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceDeadlineLog.java
index 3fee81963..ff39b8510 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceDeadlineLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceDeadlineLog.java
@@ -28,6 +28,7 @@ import jakarta.persistence.ForeignKey;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.JoinColumn;
import jakarta.persistence.JoinTable;
import jakarta.persistence.MapKeyColumn;
@@ -35,7 +36,13 @@ import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
@Entity
-@Table(name = "Task_Instance_Deadline_Log")
+@Table(name = "Task_Instance_Deadline_Log",
+ indexes = {
+ @Index(name = "ix_utdl_utid", columnList =
"user_task_instance_id"),
+ @Index(name = "ix_utdl_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_utdl_key", columnList = "business_key"),
+ @Index(name = "ix_utdl_event_date", columnList = "event_date")
+ })
@SequenceGenerator(name = "taskInstanceDeadlineLogIdSeq", sequenceName =
"TASK_INSTANCE_DEADLINE_LOG_ID_SEQ")
public class UserTaskInstanceDeadlineLog extends AbstractUserTaskInstanceLog {
@@ -44,7 +51,7 @@ public class UserTaskInstanceDeadlineLog extends
AbstractUserTaskInstanceLog {
private Long id;
@ElementCollection
- @JoinTable(name = "TaskInstanceDeadlineNotificationLog", joinColumns =
@JoinColumn(name = "task_instance_deadline_log_id"), foreignKey =
@ForeignKey(name = "fk_task_instance_deadline_tid"))
+ @JoinTable(name = "Task_Instance_Deadline_Notification_Log", joinColumns =
@JoinColumn(name = "task_instance_deadline_log_id"), foreignKey =
@ForeignKey(name = "fk_task_instance_deadline_tid"))
@MapKeyColumn(name = "property_name")
@Column(name = "property_value")
private Map<String, String> notification;
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceStateLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceStateLog.java
index e7f0dca00..59697fdd5 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceStateLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceStateLog.java
@@ -24,11 +24,19 @@ import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
@Entity
-@Table(name = "Task_Instance_State_Log")
+@Table(name = "Task_Instance_State_Log",
+ indexes = {
+ @Index(name = "ix_utsl_utid", columnList =
"user_task_instance_id"),
+ @Index(name = "ix_utsl_state", columnList = "state"),
+ @Index(name = "ix_utsl_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_utsl_key", columnList = "business_key"),
+ @Index(name = "ix_utsl_event_date", columnList = "event_date")
+ })
@SequenceGenerator(name = "taskInstanceStateLogIdSeq", sequenceName =
"TASK_INSTANCE_STATE_LOG_ID_SEQ")
public class UserTaskInstanceStateLog extends AbstractUserTaskInstanceLog {
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceVariableLog.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceVariableLog.java
index 543590137..24bdccfc1 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceVariableLog.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/model/UserTaskInstanceVariableLog.java
@@ -26,11 +26,18 @@ import jakarta.persistence.Enumerated;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
+import jakarta.persistence.Index;
import jakarta.persistence.SequenceGenerator;
import jakarta.persistence.Table;
@Entity
-@Table(name = "Task_Instance_Variable_Log")
+@Table(name = "Task_Instance_Variable_Log",
+ indexes = {
+ @Index(name = "ix_tavl_utid", columnList =
"user_task_instance_id"),
+ @Index(name = "ix_tavl_pid", columnList =
"process_instance_id"),
+ @Index(name = "ix_tavl_key", columnList = "business_key"),
+ @Index(name = "ix_tavl_event_date", columnList = "event_date")
+ })
@SequenceGenerator(name = "taskInstanceVariableLogIdSeq", sequenceName =
"TASK_INSTANCE_VARIABLE_LOG_ID_SEQ")
public class UserTaskInstanceVariableLog extends AbstractUserTaskInstanceLog {
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/queries/JPAAbstractQuery.java
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/queries/JPAAbstractQuery.java
index b0dc01599..b10d95ae5 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/queries/JPAAbstractQuery.java
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/java/org/kie/kogito/app/audit/jpa/queries/JPAAbstractQuery.java
@@ -56,10 +56,16 @@ public abstract class JPAAbstractQuery<R> {
if (pagination != null) {
if (pagination.get("limit") != null) {
jpaQuery.setMaxResults((Integer) pagination.get("limit"));
+ } else {
+ jpaQuery.setMaxResults(10);
}
if (pagination.get("offset") != null) {
jpaQuery.setFirstResult((Integer) pagination.get("offset"));
+ jpaQuery.setFirstResult(0);
}
+ } else {
+ jpaQuery.setFirstResult(0);
+ jpaQuery.setMaxResults(10);
}
return jpaQuery.getResultList();
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/META-INF/data-audit-orm.xml
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/META-INF/data-audit-orm.xml
index 8d384fe7a..f365314ff 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/META-INF/data-audit-orm.xml
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/META-INF/data-audit-orm.xml
@@ -633,7 +633,7 @@
notification.property_name as propertyName,
notification.property_value as propertyValue
FROM Task_Instance_Deadline_Log log
- LEFT JOIN TaskInstanceDeadlineNotificationLog notification ON
log.id = notification.task_instance_deadline_log_id
+ LEFT JOIN Task_Instance_Deadline_Notification_Log notification ON
log.id = notification.task_instance_deadline_log_id
WHERE log.user_task_instance_id = :userTaskInstanceId
</query>
<!-- hint name="org.hibernate.timeout" value="200"/ -->
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/db/data-audit/h2/V1.0.0__CREATE
DATA AUDIT SCHEMA.sql
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/db/data-audit/h2/V1.0.0__CREATE
DATA AUDIT SCHEMA.sql
new file mode 100644
index 000000000..c4b13ac8d
--- /dev/null
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/db/data-audit/h2/V1.0.0__CREATE
DATA AUDIT SCHEMA.sql
@@ -0,0 +1,70 @@
+create sequence JOB_EXECUTION_HISTORY_ID_SEQ start with 1 increment by 50;
+create sequence PROCESS_INSTANCE_ERROR_LOG_SEQ_ID start with 1 increment by 50;
+create sequence PROCESS_INSTANCE_NODE_LOG_ID_SEQ start with 1 increment by 50;
+create sequence PROCESS_INSTANCE_STATE_LOG_ID_SEQ start with 1 increment by 50;
+create sequence PROCESS_INSTANCE_VARIABLE_LOG_ID_SEQ start with 1 increment by
50;
+create sequence TASK_INSTANCE_ASSIGNMENT_LOG_ID_SEQ start with 1 increment by
50;
+create sequence TASK_INSTANCE_ATTACHMENT_LOG_ID_SEQ start with 1 increment by
50;
+create sequence TASK_INSTANCE_COMMENT_LOG_ID_SEQ start with 1 increment by 50;
+create sequence TASK_INSTANCE_DEADLINE_LOG_ID_SEQ start with 1 increment by 50;
+create sequence TASK_INSTANCE_STATE_LOG_ID_SEQ start with 1 increment by 50;
+create sequence TASK_INSTANCE_VARIABLE_LOG_ID_SEQ start with 1 increment by 50;
+create table Job_Execution_Log (id bigint not null, event_date timestamp(6),
execution_counter integer, expiration_time timestamp(6), job_id varchar(255),
node_instance_id varchar(255), priority integer, process_instance_id
varchar(255), repeat_interval bigint, repeat_limit integer, retries integer,
scheduled_id varchar(255), status varchar(255), primary key (id));
+create table Process_Instance_Error_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255),
parent_process_instance_id varchar(255), process_id varchar(255),
process_instance_id varchar(255), process_type varchar(255), process_version
varchar(255), root_process_id varchar(255), root_process_instance_id
varchar(255), error_message varchar(255), node_definition_id varchar(255),
node_instance_id varchar(255), primary key (id));
+create table Process_Instance_Node_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255),
parent_process_instance_id varchar(255), process_id varchar(255),
process_instance_id varchar(255), process_type varchar(255), process_version
varchar(255), root_process_id varchar(255), root_process_instance_id
varchar(255), connection varchar(255), event_data varchar(255), event_type
varchar(255) check (event_type in ('ENTER','EXIT','ABORTED','ASYNC_ENT [...]
+create table Process_Instance_State_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255),
parent_process_instance_id varchar(255), process_id varchar(255),
process_instance_id varchar(255), process_type varchar(255), process_version
varchar(255), root_process_id varchar(255), root_process_instance_id
varchar(255), event_type varchar(255) not null check (event_type in
('ACTIVE','STARTED','COMPLETED','ABORTED','SLA_VIOLATION','PENDING','SUSPEND
[...]
+create table Process_Instance_State_Roles_Log (process_instance_state_log_id
bigint not null, role varchar(255));
+create table Process_Instance_Variable_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255),
parent_process_instance_id varchar(255), process_id varchar(255),
process_instance_id varchar(255), process_type varchar(255), process_version
varchar(255), root_process_id varchar(255), root_process_instance_id
varchar(255), variable_id varchar(255), variable_name varchar(255),
variable_value varchar(255), primary key (id));
+create table Task_Instance_Assignment_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), assignment_type varchar(255),
task_name varchar(255), primary key (id));
+create table Task_Instance_Assignment_Users_Log
(task_instance_assignment_log_id bigint not null, user_id varchar(255));
+create table Task_Instance_Attachment_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), attachment_id varchar(255),
attachment_name varchar(255), attachment_uri varchar(255), event_type integer,
primary key (id));
+create table Task_Instance_Comment_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), comment_content varchar(255),
comment_id varchar(255), event_type integer, primary key (id));
+create table Task_Instance_Deadline_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), event_type varchar(255),
primary key (id));
+create table Task_Instance_State_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), actual_user varchar(255),
description varchar(255), event_type varchar(255), name varchar(255), state
varchar(255), primary key (id));
+create table Task_Instance_Variable_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), variable_id varchar(255),
variable_name varchar(255), variable_type varchar(255) check (variable_type in
('INPUT','OUTPUT')), variable_value varchar(255), primary key (id));
+create table Task_Instance_Deadline_Notification_Log
(task_instance_deadline_log_id bigint not null, property_value varchar(255),
property_name varchar(255) not null, primary key
(task_instance_deadline_log_id, property_name));
+create index ix_jel_pid on Job_Execution_Log (process_instance_id);
+create index ix_jel_jid on Job_Execution_Log (job_id);
+create index ix_jel_status on Job_Execution_Log (status);
+create index ix_piel_pid on Process_Instance_Error_Log (process_instance_id);
+create index ix_piel_key on Process_Instance_Error_Log (business_key);
+create index ix_piel_event_date on Process_Instance_Error_Log (event_date);
+create index ix_pinl_pid on Process_Instance_Node_Log (process_instance_id);
+create index ix_pinl_key on Process_Instance_Node_Log (business_key);
+create index ix_pinl_event_date on Process_Instance_Node_Log (event_date);
+create index ix_pisl_pid on Process_Instance_State_Log (process_instance_id);
+create index ix_pisl_state on Process_Instance_State_Log (state);
+create index ix_pisl_key on Process_Instance_State_Log (business_key);
+create index ix_pisl_event_date on Process_Instance_State_Log (event_date);
+create index ix_pivl_pid on Process_Instance_Variable_Log
(process_instance_id);
+create index ix_pivl_key on Process_Instance_Variable_Log (business_key);
+create index ix_pivl_event_date on Process_Instance_Variable_Log (event_date);
+create index ix_pivl_var_id on Process_Instance_Variable_Log (variable_id);
+create index ix_utasl_utid on Task_Instance_Assignment_Log
(user_task_instance_id);
+create index ix_utasl_pid on Task_Instance_Assignment_Log
(process_instance_id);
+create index ix_utasl_key on Task_Instance_Assignment_Log (business_key);
+create index ix_utasl_event_date on Task_Instance_Assignment_Log (event_date);
+create index ix_utatl_utid on Task_Instance_Attachment_Log
(user_task_instance_id);
+create index ix_utatl_pid on Task_Instance_Attachment_Log
(process_instance_id);
+create index ix_utatl_key on Task_Instance_Attachment_Log (business_key);
+create index ix_utatl_event_date on Task_Instance_Attachment_Log (event_date);
+create index ix_utcl_utid on Task_Instance_Comment_Log (user_task_instance_id);
+create index ix_utcl_pid on Task_Instance_Comment_Log (process_instance_id);
+create index ix_utcl_key on Task_Instance_Comment_Log (business_key);
+create index ix_utcl_event_date on Task_Instance_Comment_Log (event_date);
+create index ix_utdl_utid on Task_Instance_Deadline_Log
(user_task_instance_id);
+create index ix_utdl_pid on Task_Instance_Deadline_Log (process_instance_id);
+create index ix_utdl_key on Task_Instance_Deadline_Log (business_key);
+create index ix_utdl_event_date on Task_Instance_Deadline_Log (event_date);
+create index ix_utsl_utid on Task_Instance_State_Log (user_task_instance_id);
+create index ix_utsl_state on Task_Instance_State_Log (state);
+create index ix_utsl_pid on Task_Instance_State_Log (process_instance_id);
+create index ix_utsl_key on Task_Instance_State_Log (business_key);
+create index ix_utsl_event_date on Task_Instance_State_Log (event_date);
+create index ix_tavl_utid on Task_Instance_Variable_Log
(user_task_instance_id);
+create index ix_tavl_pid on Task_Instance_Variable_Log (process_instance_id);
+create index ix_tavl_key on Task_Instance_Variable_Log (business_key);
+create index ix_tavl_event_date on Task_Instance_Variable_Log (event_date);
+alter table if exists Process_Instance_State_Roles_Log add constraint
fk_process_instance_state_pid foreign key (process_instance_state_log_id)
references Process_Instance_State_Log;
+alter table if exists Task_Instance_Assignment_Users_Log add constraint
fk_task_instance_assignment_log_tid foreign key
(task_instance_assignment_log_id) references Task_Instance_Assignment_Log;
+alter table if exists Task_Instance_Deadline_Notification_Log add constraint
fk_task_instance_deadline_tid foreign key (task_instance_deadline_log_id)
references Task_Instance_Deadline_Log;
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/db/data-audit/postgresql/V1.0.0__CREATE
DATA AUDIT SCHEMA.sql
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/db/data-audit/postgresql/V1.0.0__CREATE
DATA AUDIT SCHEMA.sql
new file mode 100644
index 000000000..c4b13ac8d
--- /dev/null
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-common/src/main/resources/db/data-audit/postgresql/V1.0.0__CREATE
DATA AUDIT SCHEMA.sql
@@ -0,0 +1,70 @@
+create sequence JOB_EXECUTION_HISTORY_ID_SEQ start with 1 increment by 50;
+create sequence PROCESS_INSTANCE_ERROR_LOG_SEQ_ID start with 1 increment by 50;
+create sequence PROCESS_INSTANCE_NODE_LOG_ID_SEQ start with 1 increment by 50;
+create sequence PROCESS_INSTANCE_STATE_LOG_ID_SEQ start with 1 increment by 50;
+create sequence PROCESS_INSTANCE_VARIABLE_LOG_ID_SEQ start with 1 increment by
50;
+create sequence TASK_INSTANCE_ASSIGNMENT_LOG_ID_SEQ start with 1 increment by
50;
+create sequence TASK_INSTANCE_ATTACHMENT_LOG_ID_SEQ start with 1 increment by
50;
+create sequence TASK_INSTANCE_COMMENT_LOG_ID_SEQ start with 1 increment by 50;
+create sequence TASK_INSTANCE_DEADLINE_LOG_ID_SEQ start with 1 increment by 50;
+create sequence TASK_INSTANCE_STATE_LOG_ID_SEQ start with 1 increment by 50;
+create sequence TASK_INSTANCE_VARIABLE_LOG_ID_SEQ start with 1 increment by 50;
+create table Job_Execution_Log (id bigint not null, event_date timestamp(6),
execution_counter integer, expiration_time timestamp(6), job_id varchar(255),
node_instance_id varchar(255), priority integer, process_instance_id
varchar(255), repeat_interval bigint, repeat_limit integer, retries integer,
scheduled_id varchar(255), status varchar(255), primary key (id));
+create table Process_Instance_Error_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255),
parent_process_instance_id varchar(255), process_id varchar(255),
process_instance_id varchar(255), process_type varchar(255), process_version
varchar(255), root_process_id varchar(255), root_process_instance_id
varchar(255), error_message varchar(255), node_definition_id varchar(255),
node_instance_id varchar(255), primary key (id));
+create table Process_Instance_Node_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255),
parent_process_instance_id varchar(255), process_id varchar(255),
process_instance_id varchar(255), process_type varchar(255), process_version
varchar(255), root_process_id varchar(255), root_process_instance_id
varchar(255), connection varchar(255), event_data varchar(255), event_type
varchar(255) check (event_type in ('ENTER','EXIT','ABORTED','ASYNC_ENT [...]
+create table Process_Instance_State_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255),
parent_process_instance_id varchar(255), process_id varchar(255),
process_instance_id varchar(255), process_type varchar(255), process_version
varchar(255), root_process_id varchar(255), root_process_instance_id
varchar(255), event_type varchar(255) not null check (event_type in
('ACTIVE','STARTED','COMPLETED','ABORTED','SLA_VIOLATION','PENDING','SUSPEND
[...]
+create table Process_Instance_State_Roles_Log (process_instance_state_log_id
bigint not null, role varchar(255));
+create table Process_Instance_Variable_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255),
parent_process_instance_id varchar(255), process_id varchar(255),
process_instance_id varchar(255), process_type varchar(255), process_version
varchar(255), root_process_id varchar(255), root_process_instance_id
varchar(255), variable_id varchar(255), variable_name varchar(255),
variable_value varchar(255), primary key (id));
+create table Task_Instance_Assignment_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), assignment_type varchar(255),
task_name varchar(255), primary key (id));
+create table Task_Instance_Assignment_Users_Log
(task_instance_assignment_log_id bigint not null, user_id varchar(255));
+create table Task_Instance_Attachment_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), attachment_id varchar(255),
attachment_name varchar(255), attachment_uri varchar(255), event_type integer,
primary key (id));
+create table Task_Instance_Comment_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), comment_content varchar(255),
comment_id varchar(255), event_type integer, primary key (id));
+create table Task_Instance_Deadline_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), event_type varchar(255),
primary key (id));
+create table Task_Instance_State_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), actual_user varchar(255),
description varchar(255), event_type varchar(255), name varchar(255), state
varchar(255), primary key (id));
+create table Task_Instance_Variable_Log (id bigint not null, business_key
varchar(255), event_date timestamp(6), event_id varchar(255), event_user
varchar(255), process_instance_id varchar(255), user_task_definition_id
varchar(255), user_task_instance_id varchar(255), variable_id varchar(255),
variable_name varchar(255), variable_type varchar(255) check (variable_type in
('INPUT','OUTPUT')), variable_value varchar(255), primary key (id));
+create table Task_Instance_Deadline_Notification_Log
(task_instance_deadline_log_id bigint not null, property_value varchar(255),
property_name varchar(255) not null, primary key
(task_instance_deadline_log_id, property_name));
+create index ix_jel_pid on Job_Execution_Log (process_instance_id);
+create index ix_jel_jid on Job_Execution_Log (job_id);
+create index ix_jel_status on Job_Execution_Log (status);
+create index ix_piel_pid on Process_Instance_Error_Log (process_instance_id);
+create index ix_piel_key on Process_Instance_Error_Log (business_key);
+create index ix_piel_event_date on Process_Instance_Error_Log (event_date);
+create index ix_pinl_pid on Process_Instance_Node_Log (process_instance_id);
+create index ix_pinl_key on Process_Instance_Node_Log (business_key);
+create index ix_pinl_event_date on Process_Instance_Node_Log (event_date);
+create index ix_pisl_pid on Process_Instance_State_Log (process_instance_id);
+create index ix_pisl_state on Process_Instance_State_Log (state);
+create index ix_pisl_key on Process_Instance_State_Log (business_key);
+create index ix_pisl_event_date on Process_Instance_State_Log (event_date);
+create index ix_pivl_pid on Process_Instance_Variable_Log
(process_instance_id);
+create index ix_pivl_key on Process_Instance_Variable_Log (business_key);
+create index ix_pivl_event_date on Process_Instance_Variable_Log (event_date);
+create index ix_pivl_var_id on Process_Instance_Variable_Log (variable_id);
+create index ix_utasl_utid on Task_Instance_Assignment_Log
(user_task_instance_id);
+create index ix_utasl_pid on Task_Instance_Assignment_Log
(process_instance_id);
+create index ix_utasl_key on Task_Instance_Assignment_Log (business_key);
+create index ix_utasl_event_date on Task_Instance_Assignment_Log (event_date);
+create index ix_utatl_utid on Task_Instance_Attachment_Log
(user_task_instance_id);
+create index ix_utatl_pid on Task_Instance_Attachment_Log
(process_instance_id);
+create index ix_utatl_key on Task_Instance_Attachment_Log (business_key);
+create index ix_utatl_event_date on Task_Instance_Attachment_Log (event_date);
+create index ix_utcl_utid on Task_Instance_Comment_Log (user_task_instance_id);
+create index ix_utcl_pid on Task_Instance_Comment_Log (process_instance_id);
+create index ix_utcl_key on Task_Instance_Comment_Log (business_key);
+create index ix_utcl_event_date on Task_Instance_Comment_Log (event_date);
+create index ix_utdl_utid on Task_Instance_Deadline_Log
(user_task_instance_id);
+create index ix_utdl_pid on Task_Instance_Deadline_Log (process_instance_id);
+create index ix_utdl_key on Task_Instance_Deadline_Log (business_key);
+create index ix_utdl_event_date on Task_Instance_Deadline_Log (event_date);
+create index ix_utsl_utid on Task_Instance_State_Log (user_task_instance_id);
+create index ix_utsl_state on Task_Instance_State_Log (state);
+create index ix_utsl_pid on Task_Instance_State_Log (process_instance_id);
+create index ix_utsl_key on Task_Instance_State_Log (business_key);
+create index ix_utsl_event_date on Task_Instance_State_Log (event_date);
+create index ix_tavl_utid on Task_Instance_Variable_Log
(user_task_instance_id);
+create index ix_tavl_pid on Task_Instance_Variable_Log (process_instance_id);
+create index ix_tavl_key on Task_Instance_Variable_Log (business_key);
+create index ix_tavl_event_date on Task_Instance_Variable_Log (event_date);
+alter table if exists Process_Instance_State_Roles_Log add constraint
fk_process_instance_state_pid foreign key (process_instance_state_log_id)
references Process_Instance_State_Log;
+alter table if exists Task_Instance_Assignment_Users_Log add constraint
fk_task_instance_assignment_log_tid foreign key
(task_instance_assignment_log_id) references Task_Instance_Assignment_Log;
+alter table if exists Task_Instance_Deadline_Notification_Log add constraint
fk_task_instance_deadline_tid foreign key (task_instance_deadline_log_id)
references Task_Instance_Deadline_Log;
diff --git
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-springboot/pom.xml
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-springboot/pom.xml
index 072f923b9..db44922d5 100644
---
a/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-springboot/pom.xml
+++
b/data-audit/kogito-addons-data-audit-jpa/kogito-addons-data-audit-jpa-springboot/pom.xml
@@ -35,6 +35,20 @@
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
</dependency>
+ <dependency>
+ <groupId>org.reflections</groupId>
+ <artifactId>reflections</artifactId>
+ </dependency>
+
+ <dependency>
+ <groupId>org.hibernate.orm</groupId>
+ <artifactId>hibernate-core</artifactId>
+ </dependency>
+ <dependency>
+ <groupId>org.hibernate.orm</groupId>
+ <artifactId>hibernate-ant</artifactId>
+ </dependency>
+
<!--runtime -->
<dependency>
<groupId>org.springframework.boot</groupId>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
