Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-3062

WS-HT task service schema export fails for EmailNotification.emailHeaders under DB2 (SQLCODE=-542)

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • jBPM 5.3
    • jBPM 5.0
    • Human Task Service
    • None
    • Hide

      Possible workaround, at least to create schema:

      @org.hibernate.annotations.MapKey(columns=@Column(name="mapkey", nullable=false))
      @OneToMany(cascade=CascadeType.ALL)
      private Map<String, EmailNotificationHeader> emailHeaders;

      Show
      Possible workaround, at least to create schema: @org.hibernate.annotations.MapKey(columns=@Column(name="mapkey", nullable=false)) @OneToMany(cascade=CascadeType.ALL) private Map<String, EmailNotificationHeader> emailHeaders;

      JBPM WS-HT task service implementation failed to create schema with DB2 DB. Error log listed below.

      ERROR SchemaExport:348 - Unsuccessful: create table Notification_email_header (Notification_id bigint not null, emailHeaders_id bigint not null, mapkey varchar(255), primary key (Notification_id, mapkey), unique (emailHeaders_id))
      ERROR SchemaExport:349 - DB2 SQL Error: SQLCODE=-542, SQLSTATE=42831, SQLERRMC=MAPKEY, DRIVER=4.11.77
      ERROR SchemaExport:348 - Unsuccessful: alter table Notification_email_header add constraint FKF30FE3441F7B912A foreign key (emailHeaders_id) references email_header
      ERROR SchemaExport:349 - DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC= NOTIFICATION_EMAIL_HEADER, DRIVER=4.11.77
      ERROR SchemaExport:348 - Unsuccessful: alter table Notification_email_header add constraint FKF30FE34430BE501C foreign key (Notification_id) references Notification
      ERROR SchemaExport:349 - DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC= NOTIFICATION_EMAIL_HEADER, DRIVER=4.11.77

      Issue is related to org.jbpm.task.EmailNotification.emailHeaders mapping. Probably problem nature is similar to this one - https://issues.jboss.org/browse/JBPAPP-1071 .

              kverlaen@redhat.com Kris Verlaenen
              vmdocua_jira Vadim Melnik (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: