How to Use Mariadb and Liquibase Together With Maven on Jboss
First you must define the needed dependency in your pom file. <profile> <id>mariadb</id> <activation> <pr...
https://www.czetsuyatech.com/2021/07/how-to-use-mariadb-and-liquibase-together-with-maven-on-jboss.html
First you must define the needed dependency in your pom file.
<profile> <id>mariadb</id> <activation> <property> <name>env</name> <value>mariadb</value> </property> </activation> <properties> <db.driver>org.mariadb.jdbc.Driver</db.driver> <db.url>jdbc:mariadb://localhost:3306/mariadb</db.url> <db.username>mariadb</db.username> <db.password>mariadb</db.password> </properties> <dependencies> <!-- Dependency for liquibase plugin --> <dependency> <groupId>org.mariadb.jdbc</groupId> <artifactId>mariadb-java-client</artifactId> <version>1.5.4</version> </dependency> </dependencies> </profile>Then we need to configure jboss datasource
<datasource jta="true" jndi-name="java:jboss/datasources/MariaDBAdminDatasource" pool-name="MariaDBMariadb" enabled="true" use-java-context="true" use-ccm="false"> <connection-url>jdbc:mariadb://127.0.0.1:3306/MariaDB</connection-url> <driver-class>org.mariadb.jdbc.Driver</driver-class> <driver>mariadb-driver</driver> <pool> <min-pool-size>2</min-pool-size> <max-pool-size>20</max-pool-size> </pool> <security> <user-name>MariaDB</user-name> <password>MariaDB</password> </security> <validation> <validate-on-match>true</validate-on-match> <background-validation>true</background-validation> <check-valid-connection-sql>select 1</check-valid-connection-sql> </validation> <statement> <prepared-statement-cache-size>10</prepared-statement-cache-size> <share-prepared-statements>false</share-prepared-statements> </statement> </datasource> <drivers> <driver name="mariadb-driver" module="org.mariadb"> <xa-datasource-class>org.mariadb.jdbc.MySQLDataSource</xa-datasource-class> </driver> </drivers>And finally inside jboss modules folder we need to create a new folder: org\mariadb\main with mariadb-java-client-1.5.4.jar and module.xml. Content of module.xml is:
<?xml version="1.0" encoding="UTF-8"?> <module xmlns="urn:jboss:module:1.0" name="org.mariadb"> <resources> <resource-root path="mariadb-java-client-1.5.4.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> </dependencies> </module>
Post a Comment