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

Double quotes not recognized by WorkItemHandler

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Critical
    • None
    • 7.17.0.Final
    • Workbench
    • None
    • NEW
    • NEW

    Description

      I am following this link to create a custom work item for MSSQL database connection and I am able to generate work item maven project and deploy work item repository into wildfly server successfully.
      jBPM Link: http://mswiderski.blogspot.com/2018/04/jbpm-work-items-are-really-simple.html

      When I go to Service Repository to access a list of work items, it shows blank and throws an exception. Refer to Error.log file.
      File: ServiceRepository.jpg, ServiceRepository2.jpg, Error.log

      MsDatabaseWorkItemHandler.java Source:
      ======================================
      @Wid(widfile="MSQLService.wid", name="MSQLService",
      displayName="Database Service Task",
      defaultHandler="mvel: new com.maventree.workitem.msdatabase.MsDatabaseWorkItemHandler(\"${db.host}\", \"${db.userName}\", \"${db.userPassword}\")",
      category = "maven-xw-workitem",
      icon = "defaultservicenodeicon.png",
      parameters=

      { @WidParameter(name="DbHost", required = true), @WidParameter(name="DbUser", required = true), @WidParameter(name="DbPassword", required = true), @WidParameter(name="SqlQuery", required = true) }

      ,
      results =

      { @WidResult(name = "QueryResult", runtimeType = "java.util.List") }

      ,
      mavenDepends = {
      @WidMavenDepends(group = "${groupId}", artifact = "${artifactId}", version = "${version}")
      },
      serviceInfo = @WidService(category = "${name}", description = "${description}",
      keywords = "database",
      action = @WidAction(title = "Database Service Task")
      )
      )
      public class MsDatabaseWorkItemHandler extends AbstractLogOrThrowWorkItemHandler

      pom.xml Source:
      ===============
      <properties>
      <db.host>jdbc:sqlserver://localhost:1433;databaseName=user;</db.host>
      <db.userName>user</db.userName>
      <db.userPassword>password</db.userPassword>
      </properties>

      When I modify JDBC URL by removing ":" colon character from parameter as below, everything is working fine. Please help. Thank you.

      pom.xml Source:
      ===============
      <properties>
      <db.host>jdbcsqlserver//localhost1433;databaseName=user;</db.host>
      <db.userName>user</db.userName>
      <db.userPassword>password</db.userPassword>
      </properties>

      Attachments

        1. Error.log
          20 kB
        2. maven-xw-workitem-7.31.0.Final.jar
          30 kB
        3. maven-xw-workitem-7.31.0.Final.jar
          29 kB
        4. ServiceRepository.jpg
          ServiceRepository.jpg
          124 kB
        5. ServiceRepository2.jpg
          ServiceRepository2.jpg
          120 kB

        Activity

          People

            elguardian@gmail.com Enrique González Martínez (Inactive)
            maventree Maven tree (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: