spring boot+jpa接入达梦数据库

前言

最近有一个新项目，由于信息安全等要求只能使用达梦数据库（dm8），之前从来没用过，特此开一个笔记记录一下spring boot+jpa如何使用达梦数据库完成开发。

依赖

pom文件需要

        <!-- https://mvnrepository.com/artifact/com.dameng/Dm8JdbcDriver18 --><dependency><groupId>com.dameng</groupId><artifactId>Dm8JdbcDriver18</artifactId><version>8.1.1.49</version></dependency><dependency><groupId>com.dameng</groupId><artifactId>DmDialect-for-hibernate5.3</artifactId><version>8.1.1.49</version></dependency>

配置

spring:devtools:restart:enabled: falsedatasource:type: com.alibaba.druid.pool.DruidDataSourcedriver-class-name: "dm.jdbc.driver.DmDriver"url: "jdbc:dm://${DM_HOST}:${DM_PORT}/${DM_DATABASE}"username: ${DM_USERNAME}password: ${DM_PASSWORD}druid:initial-size: 5min-idle: 20maxActive: 100maxWait: 60000timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000validationQuery: "SELECT 1"testWhileIdle: truetestOnBorrow: truetestOnReturn: falsepoolPreparedStatements: truemaxPoolPreparedStatementPerConnectionSize: 10filters: "stat,slf4j"web-stat-filter:enabled: falsejpa:database-platform: "org.hibernate.dialect.DmDialect"show-sql: trueopen-in-view: falsehibernate:default_schema: suosddl-auto: noneproperties:javax:persistence:sharedCache:mode: ENABLE_SELECTIVEhibernate:default_schema: ${DM_DATABASE}"use_jdbc_metadata_defaults: falseenable_lazy_load_no_trans: trueformat_sql: trueconnection:provider_disables_autocommit: falsegenerate_statistics: falseid:new_generator_mappings: truejdbc:batch_size: 25order_inserts: trueorder_updates: truequery:fail_on_pagination_over_collection_fetch: truein_clause_parameter_padding: trueshow_sql: truedialect: org.hibernate.dialect.DmDialect

对应的domain类和repository

domain

import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import lombok.experimental.SuperBuilder;
import org.springframework.data.jpa.domain.support.AuditingEntityListener;import javax.persistence.Entity;
import javax.persistence.EntityListeners;
import javax.persistence.Table;@NoArgsConstructor
@SuperBuilder
@Getter
@Setter
@Entity
@EntityListeners(AuditingEntityListener.class)
@Table(schema = "SUOS")
public class Class extends AbstractModel{@Schema(description = "校区id")private Integer campusId;@Schema(description = "校区名称")private String campusName;@Schema(description = "专业id")private Integer majorId;@Schema(description = "专业代码")private String majorCode;@Schema(description = "专业名称")private String majorName;@Schema(description = "方向")private String field;@Schema(description = "界别")private String grade;@Schema(description = "班级名称")private String name;@Schema(description = "班号")private String number;
}

注意这个schema最好是带上，不然可能会给你写到默认database里去
repository

import com.timerchina.suos.domain.Class;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;public interface ClassRepository extends JpaRepository<Class, Integer>, JpaSpecificationExecutor<Class> {}