Open Edition

 View Only
Expand all | Collapse all

Persistent DB and Business Process Information

  • 1.  Persistent DB and Business Process Information

    Posted Thu January 02, 2025 12:16 PM

    Hello Everyone,

    I have installed BAMOE 8.0.5 version using EAP 7.4.0 with Patch 10 in my system i.e., localhost. The Business Central and Kie Server are properly installed and deployed. We have even created a project in the Business central. Now while executing the project, the data like process instances, task info etc.. keeps updating as and when our project moves to different stages. So this data gets displayed into corresponding tables of the filter columns of completed, suspended, pending etc.. After I close the business central and re-start the server, this very data gets erased. That means the data is not persistent.

    The DB that the BAMOE uses is h2 DB. This is an in-memory DB. The very nature of DB is that it does not store data permanently. The data gets erased as and when the server re-starts. My goal is to shift to a persistent DB like MYSQL, where the data gets stored in the MYSQL DB and the history of the instances is shown in the Business Central's respective filters and sections. 

    For this I have downloaded and installed MYSQL and created a database. I have also changed the data-source in standalone-full.xml to MYSQL. I have downloaded the respective mysql-j-connector-8.0.33 jar file and shifted it to the modules/../../com/mysql/main/. Now here the mysql and the main folders were respectively created by me, as by default there was no mysql folder. I only have h2database folder over there. After adding the connector at the respective path created, and even creating a domain.xml file where the connector and javax.api details are declared over there; I have restarted the server.

    This is the part where earlier by-default it was in h2 DB - 

    <datasources>
                    <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}">
                        <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>
                        <driver>h2</driver>
                        <security>
                            <user-name>sa</user-name>
                            <password>sa</password>
                        </security>
                    </datasource>
                    <drivers>
                        <driver name="h2" module="com.h2database.h2">
                            <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                        </driver>
                    </drivers>
                </datasources>
    <datasources>
    and after changing it to Mysql - 
            <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
                <connection-url>jdbc:mysql://localhost:3306/bamoedb?useSSL=false&amp;allowPublicKeyRetrieval=true&amp;serverTimezone=UTC</connection-url>
                <driver>mysql</driver>
                <security>
                    <user-name>root</user-name>
                    <password>root@9kp</password>
                </security>
            </datasource>
            <drivers>
                <driver name="mysql" module="com.mysql">
                    <xa-datasource-class>com.mysql.cj.jdbc.MysqlXADataSource</xa-datasource-class>
                </driver>
            </drivers>
        </datasources>
    One more doubt that we face is that which standalone.xml file should we make changes in? There are 4 of them respectively mentioned below in the EAP-7.4.0 >Standalone> configuration folder - 

    standalone.xml , standalone-full.xml, standalone-full-ha.xml, standalone-ha.xml

    I have presently made changes into the standalone-full.xml file as I run this file in the cmd to start the server

    The server starts but with errors and the business-central.war file and the kie-server.war file do not get deployed. Basically their deployment fails, when I do these changes.

    This is the error that I get - 

    17:19:41,257 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([
        ("subsystem" => "datasources"),
        ("data-source" => "ExampleDS")
    ]) - failure description: {
        "WFLYCTL0412: Required services that are not installed:" => ["jboss.jdbc-driver.mysql"],
        "WFLYCTL0180: Services with missing/unavailable dependencies" => [
            "org.wildfly.data-source.ExampleDS is missing [jboss.jdbc-driver.mysql]",
            "jboss.driver-demander.java:jboss/datasources/ExampleDS is missing [jboss.jdbc-driver.mysql]"
        ]
    }
    17:19:41,257 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([
        ("subsystem" => "datasources"),
        ("data-source" => "ExampleDS")
    ]) - failure description: {
        "WFLYCTL0412: Required services that are not installed:" => [
            "jboss.jdbc-driver.mysql",
            "jboss.jdbc-driver.mysql"
        ],
        "WFLYCTL0180: Services with missing/unavailable dependencies" => [
            "org.wildfly.data-source.ExampleDS is missing [jboss.jdbc-driver.mysql]",
            "jboss.driver-demander.java:jboss/datasources/ExampleDS is missing [jboss.jdbc-driver.mysql]",
            "org.wildfly.data-source.ExampleDS is missing [jboss.jdbc-driver.mysql]"
        ]
    }
    17:19:41,273 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 45) WFLYSRV0010: Deployed "kie-server.war" (runtime-name : "kie-server.war")
    17:19:41,273 INFO  [org.jboss.as.server] (ServerService Thread Pool -- 45) WFLYSRV0010: Deployed "business-central.war" (runtime-name : "business-central.war")
    17:19:41,289 INFO  [org.jboss.as.controller] (Controller Boot Thread) WFLYCTL0183: Service status report
    WFLYCTL0184:    New missing/unsatisfied dependencies:
          service jboss.jdbc-driver.mysql (missing) dependents: [service org.wildfly.data-source.ExampleDS, service jboss.driver-demander.java:jboss/datasources/ExampleDS]

    How do I resolve this issue? I request you to help me out in resolving this issue... Waiting to hear back from you...

    Thank You

    Karthikeya



    ------------------------------
    Karthikeya Panangapalli
    ------------------------------


  • 2.  RE: Persistent DB and Business Process Information

    Posted Wed January 08, 2025 09:33 AM

    Hello Everyone,

    Can somebody help me out with the above problem case?

    Thank You

    Karthikeya



    ------------------------------
    Karthikeya Panangapalli
    ------------------------------

    Original Message