Hello @Jozef Marko & @Tibor Zimányi
I am new to this community, and this is the first time I am working on Business Automation and BAMOE product.
I am facing difficulty to configure my external database (MYSQL 8.0.40) to BAMOE (8.0.5).
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. I 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 business central's filter columns like 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, I think. 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. After that, in MYSQL command line, I have executed the ddl scripts under the process-migration folder from the BAMOE add-ons.zip file which I downloaded from the website. 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&allowPublicKeyRetrieval=true&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 I face is that which standalone.xml file should I 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, as directed in the Red Hat documentation link given below -
https://docs.redhat.com/en/documentation/red_hat_process_automation_manager/7.13/html-single/installing_and_configuring_red_hat_process_automation_manager/index#eap-data-source-add-proc_install-on-eap
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,
Bhanu