Details
-
Bug
-
Resolution: Not a Bug
-
Critical
-
None
-
7.17.0.Final
-
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=
,
results =
,
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>