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

Details

    • Bug
    • Resolution: Done
    • 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;

    Description

      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 .

      Attachments

        Issue Links

          is related to

          Sub-task - The sub-task of the issue JBPM-3445 Fix all jBPM 5 unit tests for DB2 97 databases.

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Open

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: