DEV Community: PINNINTI SAI SUKUMAR

Connecting Jbpm With External dataSource / External Database / Mysql Database

PINNINTI SAI SUKUMAR — Sat, 29 Oct 2022 14:03:09 +0000

Writing this Article For Reference and this might help others .

I, am New to JBPM , if Anything Mentioned In the article is Wrong Please Suggest it in the comments .

Reference video:
In Order Use Execute-Sql-Work-Item-Handler:
Please Follow this Video Guide From YouTube:
jBPM ExecuteSqlWorkItemHandler | KIE TUTORIALS
- - - - -
Installing
- - - - - - -

`Please make sure that you have toggled the Execute-Sql in the Custom Tasks Administration section.
Steps to Follow :

Click on the gear icon in the nav bar, scroll down and open Custom Tasks Administration .

Search for Execute-Sql and toggle it to the yes state. If prompted for jndi name just add : java:jboss/datasources/ Adding Dependencies In order to add external Data source, Navigate to your:

Project> Settings >Deployments> Work Item handlers >

Add a new Work Item Handler

Name: ExecuteSQL
Value:
new org.jbpm.process.workitem.executesql.ExecuteSqlWorkItemHandler("java:jboss/datasources/")
Resolver type: MVEL
`
Navigate to Dependencies and add a dependency From [Here][2] .
Or else
GroupID : org.jbpm.contrib | Artifact ID : execute-sql-workitem | Version : 7.42.0.Final
Save the Configuration and the Create the Business Process as required.`
- - - - -
Drivers Deployment
- - - - - - - - -
Download the Zip from below link
[mysqljdbcdriver.zip][3]
Extract the zip and copy the mysql-connector-java-5.1.47-bin.jar file.

Navigate JBPM Installation Folder \standalone\deployments
paste the file there.
Navigate to JBPM Installation Folder \modules\com
- Create folder named: Mysql
- Inside mysql folder create a folder named main. The main Folder Directory would look like: JBPM Installation Folder \modules\com\mysql\main
Navigate to JBPM Installation Folder \bin\drivers
- Copy mysql-connector-java.jar file.
- Repeat the Steps 2 and 3
- Navigate to JBPM Installation Folder \modules\com\mysql\main Paste the file.
- Create a .xml file named module.xml.
- The Contents of the module.xml file is: <?xml version='1.0' encoding='UTF-8'?> Adding The External Data Source - - - - - - - - - - - - - - - -
Now open Another Terminal in the bin and Execute the Following Command " jboss-cli.bat -c "
Configure Your DataSource From the Below Command :
xa-data-source add - name=
- jndi-name="java:/jboss/datasources/" - user-name=jbpm - password=jbpm - driver-name=mysql-connector-java.jar - xa-datasource-class=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource - xa-datasource-properties=[{ServerName=localhost,PortNumber=3306,DatabaseName=}] *replace & with the with database name.and the other parameters with their respective values .
Now You can Use the External DataSource .

Reference Links

For PostgreSql : https://karinavarela.me/2020/06/17/persisting-custom-data-configuring-external-persistence/

MySql : http://www.mastertheboss.com/bpm/jbpm6/configuring-jbpm-to-use-mysql-as-database/

[2]: https://mvnrepository.com/artifact/org.jbpm.contrib/execute-sql-workitem/7.42.0.Final
[3]: https://dbschema.com/jdbc-drivers/MySqlJdbcDriver.zip

Netflix Zuul & Eureka LoadBalancing in 2022

PINNINTI SAI SUKUMAR — Tue, 17 May 2022 13:29:15 +0000

Netflix Zuul & Eureka Load Balancing in 2022

The Netflix Zuul is deprecated and no longer suppported .
Spring Cloud Gate Way is the alternative .

there are many advantages of using spring cloud gateway as alternative. but it also do not support few features such as spring starter security for web mvc .

So in order to use the Netflix Zuul Combined by Eureka Client in 2022 .

Use the spring boot version which is released before the
deprecation
The eureka client version released in the same time frame .
Set the java version to 1.8 .

<packaging>jar</packaging>
<properties>
    <java.version>1.8</java.version>
    <spring-cloud.version>Hoxton.SR8</spring-cloud.version>
</properties>

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-security</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.cloud</groupId>
        <artifactId>spring-cloud-starter-netflix-zuul</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.cloud</groupId>
        <artifactId>spring-cloud-starter-netflix-eureka-client</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>io.jsonwebtoken</groupId>
        <artifactId>jjwt</artifactId>
        <version>0.9.1</version>
    </dependency>
    <dependency>
        <groupId>javax.xml.bind</groupId>
        <artifactId>jaxb-api</artifactId>
    </dependency>

    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
    </dependency>
</dependencies>

<dependencyManagement>
    <dependencies>
        <dependency>
            <groupId>org.springframework.cloud</groupId>
            <artifactId>spring-cloud-dependencies</artifactId>
            <version>${spring-cloud.version}</version>
            <type>pom</type>
            <scope>import</scope>
        </dependency>
    </dependencies>
</dependencyManagement>

<build>
    <plugins>
        <plugin>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
            <version>${project.parent.version}</version>
        </plugin>
    </plugins>
</build>
<repositories>
    <repository>
        <id>spring-milestones</id>
        <name>Spring Milestones</name>
        <url>https://repo.spring.io/milestone</url>
        <snapshots>
            <enabled>false</enabled>
        </snapshots>
    </repository>
</repositories>`

The Maven Pom.xml can be Found Here.

Random Responsive balls in the background

PINNINTI SAI SUKUMAR — Wed, 06 Apr 2022 04:21:01 +0000