官术网_书友最值得收藏!

Setting up the MariaDB database

Now, we switch our database from H2 to MariaDB. The database tables are still created automatically by JPA. But before we run our application, we have to create a database for it. The database can be created by using HeidiSQL. Open HeidiSQL, and follow these steps:

  1. Right-click your mouse inside the database list.
  2. Then, select New | Database:
  1. Let's name our database cardb. After you press OK, you should see the new cardb in the database list:
  1. In the application, we add a MariaDB dependency to the pom.xml file and remove the H2 dependency that we don't need any more:
      <dependency>
<groupId>org.mariadb.jdbc</groupId>
<artifactId>mariadb-java-client</artifactId>
</dependency>
  1. In the application.properties file, you define the database connection. First, you will define the database's url, username, password and database driver class. The spring.jpa.generate-ddl setting defines whether JPA should initialize the database (true/false). The spring.jpa.hibernate.ddl-auto setting defines the behavior of the database initialization. The possible values are none, validate, update, create, and create-drop. Create-drop means that the database is created when an application starts and it is dropped when the application is stopped. Create-drop is also a default value if you don't define any. Create value only creates the database when the application is started. Update value creates the database and updates the schema if it is changed:
      spring.datasource.url=jdbc:mariadb://localhost:3306/cardb
spring.datasource.username=root
spring.datasource.password=YOUR_PASSWORD
spring.datasource.driver-class-name=org.mariadb.jdbc.Driver

spring.jpa.generate-ddl=true
spring.jpa.hibernate.ddl-auto=create-drop
  1. Now, after running the application, you should see the tables in MariaDB. The following screenshot shows the HeidiSQL UI after the database has been created. Your application is now ready to be used with MariaDB:
主站蜘蛛池模板: 靖宇县| 铁岭县| 阳谷县| 通江县| 昭苏县| 都兰县| 东山县| 临洮县| 东海县| 清流县| 诏安县| 洛浦县| 大港区| 广河县| 长寿区| 城口县| 淮安市| 丰都县| 南开区| 筠连县| 贵州省| 广元市| 大宁县| 东莞市| 永嘉县| 兴安县| 祁连县| 高邮市| 高雄县| 巴彦淖尔市| 和田市| 新营市| 赤壁市| 特克斯县| 邢台县| 庆云县| 石家庄市| 广昌县| 黄山市| 肥城市| 静乐县|