2025-05-15 16:41:22 DEBUG JpaTransactionManager:374 [,] - Found thread-bound EntityManager [SessionImpl(832185234<open>)] for JPA transaction
2025-05-15 16:41:22 DEBUG JpaTransactionManager:402 [,] - Creating new transaction with name [org.springframework.data.jpa.repository.support.SimpleJpaRepository.save]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2025-05-15 16:41:23 DEBUG JpaTransactionManager:439 [,] - Exposing JPA transaction as JDBC [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@305efe7d]
2025-05-15 16:41:23 DEBUG JpaTransactionManager:789 [,] - Initiating transaction commit
2025-05-15 16:41:23 DEBUG JpaTransactionManager:557 [,] - Committing JPA transaction on EntityManager [SessionImpl(832185234<open>)]
2025-05-15 16:41:23 DEBUG SQL:135 [,] - insert into lucy_process (additional_attributes_tx,create_user_id,create_ts,decision_category_nm,decision_sub_type_nm,decision_type_nm,filter_conditions_tx,last_user_id,last_update_ts,metadata_segment_tx,origin_version_id,original_in,output_table_nm,process_ds,process_nm,process_type_cd,product_group_auto_id,project_secondary_id,promote_user_id,promote_ts,query_data_tx,secondary_id,version_id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Hibernate: insert into lucy_process (additional_attributes_tx,create_user_id,create_ts,decision_category_nm,decision_sub_type_nm,decision_type_nm,filter_conditions_tx,last_user_id,last_update_ts,metadata_segment_tx,origin_version_id,original_in,output_table_nm,process_ds,process_nm,process_type_cd,product_group_auto_id,project_secondary_id,promote_user_id,promote_ts,query_data_tx,secondary_id,version_id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2025-05-15 16:41:24 DEBUG SQL:135 [,] - update lucy_process set additional_attributes_tx=?,create_user_id=?,create_ts=?,decision_category_nm=?,decision_sub_type_nm=?,decision_type_nm=?,filter_conditions_tx=?,last_user_id=?,last_update_ts=?,metadata_segment_tx=?,origin_version_id=?,original_in=?,output_table_nm=?,process_ds=?,process_nm=?,process_type_cd=?,product_group_auto_id=?,project_secondary_id=?,promote_user_id=?,promote_ts=?,query_data_tx=?,secondary_id=? where version_id=?
Hibernate: update lucy_process set additional_attributes_tx=?,create_user_id=?,create_ts=?,decision_category_nm=?,decision_sub_type_nm=?,decision_type_nm=?,filter_conditions_tx=?,last_user_id=?,last_update_ts=?,metadata_segment_tx=?,origin_version_id=?,original_in=?,output_table_nm=?,process_ds=?,process_nm=?,process_type_cd=?,product_group_auto_id=?,project_secondary_id=?,promote_user_id=?,promote_ts=?,query_data_tx=?,secondary_id=? where version_id=?
2025-05-15 16:41:25 DEBUG SQL:135 [,] - select nextval('revinfo_rev_seq')
Hibernate: select nextval('revinfo_rev_seq')
2025-05-15 16:41:25 DEBUG SQL:135 [,] - insert into revinfo (revtstmp,rev) values (?,?)
Hibernate: insert into revinfo (revtstmp,rev) values (?,?)
2025-05-15 16:41:25 DEBUG SQL:135 [,] - insert into lucy_process_aud (revtype,additional_attributes_tx,create_user_id,create_ts,decision_category_nm,decision_sub_type_nm,decision_type_nm,filter_conditions_tx,last_user_id,last_update_ts,metadata_segment_tx,origin_version_id,original_in,output_table_nm,process_ds,process_nm,process_type_cd,product_group_auto_id,project_secondary_id,promote_user_id,promote_ts,query_data_tx,secondary_id,rev,version_id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Hibernate: insert into lucy_process_aud (revtype,additional_attributes_tx,create_user_id,create_ts,decision_category_nm,decision_sub_type_nm,decision_type_nm,filter_conditions_tx,last_user_id,last_update_ts,metadata_segment_tx,origin_version_id,original_in,output_table_nm,process_ds,process_nm,process_type_cd,product_group_auto_id,project_secondary_id,promote_user_id,promote_ts,query_data_tx,secondary_id,rev,version_id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2025-05-15 16:41:26 DEBUG SQL:135 [,] - update lucy_process set additional_attributes_tx=?,create_user_id=?,create_ts=?,decision_category_nm=?,decision_sub_type_nm=?,decision_type_nm=?,filter_conditions_tx=?,last_user_id=?,last_update_ts=?,metadata_segment_tx=?,origin_version_id=?,original_in=?,output_table_nm=?,process_ds=?,process_nm=?,process_type_cd=?,product_group_auto_id=?,project_secondary_id=?,promote_user_id=?,promote_ts=?,query_data_tx=?,secondary_id=? where version_id=?
Hibernate: update lucy_process set additional_attributes_tx=?,create_user_id=?,create_ts=?,decision_category_nm=?,decision_sub_type_nm=?,decision_type_nm=?,filter_conditions_tx=?,last_user_id=?,last_update_ts=?,metadata_segment_tx=?,origin_version_id=?,original_in=?,output_table_nm=?,process_ds=?,process_nm=?,process_type_cd=?,product_group_auto_id=?,project_secondary_id=?,promote_user_id=?,promote_ts=?,query_data_tx=?,secondary_id=? where version_id=?
2025-05-15 16:41:26 DEBUG JpaTransactionManager:657 [,] - Not closing pre-bound JPA EntityManager after transaction
2025-05-15 16:41:26 DEBUG JpaTransactionManager:1065 [,] - Resuming suspended transaction after completion of inner transaction
@MappedSuperclass
@Audited
public class BaseModel {
@Id
@GenericGenerator(name = "sequence_id",
strategy = "com.utils.EnhancedNanoTimeKeyGenerator")
@GeneratedValue(generator = "sequence_id")
@Column(name = "version_id")
protected Long versionId;
-------------------------------------------------------------------------------------------------------------------------
@Entity
@Table(name = "lucy_process")
@Audited
@TypeDefs({
@TypeDef(name = "jsonb", typeClass = JsonBinaryType.class)
})
public class LucyProcess extends BaseModel implements Serializable {
@Description(value = "Process Name")
@Column(name = "process_nm")
private String processName;
@Description(value = "Process Description")
@Column(name = "process_ds")
@Length(max = 255, message = "Description must be less than 255 characters")
private String processDescription;
@Description(value = "Metadata Segment Text")
@Column(name = "metadata_segment_tx")
private byte[] metadataSegments;
@Description(value = "Additional Attributes Text")
@Type(type = "jsonb")
@Column(name = "additional_attributes_tx", columnDefinition = "jsonb")
private ProcessAdditionalAttributes additionalAttributes;
@Description("Original Indicator")
@Column(name = "original_in")
private boolean originalIndicator;
@Description("Process Type Code")
@Column(name = "process_type_cd")
@Enumerated(EnumType.STRING)
private ProcessType processType;
@Description("Query Data Text")
@Column(name = "query_data_tx")
private byte[] queryDataBytes;
@Description("Filter Conditions Text")
@Type(type = "jsonb")
@Column(name = "filter_conditions_tx", columnDefinition = "jsonb")
private FilterCondition filterConditionBytes;
@Description("Output table Name of this process")
@Column(name = "output_table_nm")
private String outputTableName;
@Column(name = "product_group_auto_id")
private Long productGroupAutoId;
@Column(name = "origin_version_id")
private Long originVersionId;
@Column(name = "project_secondary_id")
private Long projectSecondaryId;
@Description(value = "Promote Date")
@Column(name = "promote_ts")
private Timestamp promoteTs;
@Description(value = "Promote By")
@Column(name = "promote_user_id")
private String promoteBy;
@Description(value = "Decision Category")
@Column(name = "decision_category_nm")
private String decisionCategory;
@Description(value = "Decision Type")
@Column(name = "decision_type_nm")
private String decisionType;
@Description(value = "Decision SubType")
@Column(name = "decision_sub_type_nm")
private String decisionSubType;
@Description("Product Group Auto Identifier")
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "product_group_auto_id", updatable = false, insertable = false)
private LucyProductGroup productGroup;
@Description("Origin Version Identifier")
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "origin_version_id", updatable = false, insertable = false)
private LucyProcess originalProcess;
@OneToMany(mappedBy = "process", fetch = FetchType.LAZY)
private Set<LucyProject2Process> project2Processes;
@OneToMany(mappedBy = "process", fetch = FetchType.LAZY)
private Set<LucyVariable> variables;
@OneToMany(mappedBy = "process", fetch = FetchType.LAZY)
private Set<LucyProcess2Rule> processToRules;
@OneToMany(mappedBy = "process")
@NotAudited
private Set<LucyProcess2VariableSet> processToVariableSets;
@OneToMany(mappedBy = "process")
@NotAudited
private Set<LucyProcess2VariableSetUsage> processToVariableSetUsages;
@OneToMany(mappedBy = "process")
@NotAudited
private Set<LucyProcess2FunctionSet> processToFunctionSets;
@OneToMany(mappedBy = "process")
@NotAudited
private Set<LucyProcess2FunctionSetUsage> processToFunctionSetUsages;