sharding-jdbc-spring-boot-starter 整合 mybatis-plus-boot-starter + druid
sharding-jdbc整合 mybatis-plus + druid
shardingsphere分库分表
================================
©Copyright 蕃薯耀 2020-10-21
http://fanshuyao.iteye.com/
一、环境:
<parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.2.10.RELEASE</version> <relativePath/> </parent>
<mybatisPlus.version>3.4.0</mybatisPlus.version> <shardingsphere.version>4.1.1</shardingsphere.version>
<!-- 不能使用druid-spring-boot-starter,会导致:Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required --> <!-- <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version>1.2.1</version> </dependency> --> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.2.1</version> </dependency> <dependency> <groupId>org.apache.shardingsphere</groupId> <artifactId>sharding-jdbc-spring-boot-starter</artifactId> <version>${shardingsphere.version}</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.2</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-freemarker</artifactId> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.13</version> </dependency> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>${mybatisPlus.version}</version> </dependency> <!--mybatis-plus 码生成器 添加 模板引擎依赖 这个需要增加模板引擎依赖,如freemarker--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-generator</artifactId> <version>${mybatisPlus.version}</version> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <scope>provided</scope> </dependency>
数据源连接配置:
#com.alibaba.druid.pool.DruidDataSource
#DruidDataSource需要引入druid的Jar包,使用:url
#com.zaxxer.hikari.HikariDataSource
#HikariDataSource要使用:jdbc-url
spring.shardingsphere.datasource.ss1.type=com.alibaba.druid.pool.DruidDataSource
spring.shardingsphere.datasource.ss1.driver-class-name=com.mysql.cj.jdbc.Driver
spring.shardingsphere.datasource.ss1.url=jdbc:mysql://localhost:3306/ss1?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8&pinGlobalTxToPhysicalConnection=true&autoReconnect=true&nullNamePatternMatchesAll=true
spring.shardingsphere.datasource.ss1.username=root
spring.shardingsphere.datasource.ss1.password=root
注意:
不能使用:druid-spring-boot-starter,不然会导致下面的问题:java.lang.IllegalArgumentException: Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required
Caused by: java.lang.IllegalArgumentException: Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required at org.springframework.util.Assert.notNull(Assert.java:201) at org.mybatis.spring.support.SqlSessionDaoSupport.checkDaoConfig(SqlSessionDaoSupport.java:122) at org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:73) at org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:44) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1853) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1790) ... 47 more
================================
©Copyright 蕃薯耀 2020-10-21
http://fanshuyao.iteye.com/
相关推荐
1、基于yml 配置方式 ,实现springBoot+sharding-jdbc+mybatis-plus 实现分库分表,读写分离,以及全局表,子表的配置。 2、实现mybatis-plus 整合到springboot 详细使用请看 测试用例
SpringBoot+Mybatis-Plus整合Sharding-JDBC5.1.1实现单库分表【全网最新】.doc
spring+mybatis+sharding-jdbc实现的一个小demo,仅供参考
该项目主要采用springboot2.x+sharding -spring-boot-sharding-jdbc
主要介绍了Spring Boot 集成 Sharding-JDBC + Mybatis-Plus 实现分库分表功能,本文通过实例代码给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友可以参考下
因为原项目中提到的 sharding-jdbc-mybatis-plus-spring-boot-starter 没有再更新,所以产生了此项目 dependencies com.baomidou:mybatis-plus:2.2.0 sharding-jdbc-core-spring-boot-starter:2.0.3 spring-boot-...
spring boot的配置文件配置无法具体配置druid连接池的各种属性(官网上我没找到),所以采用java类的方式配置,包括druid的wallFilter、statFilter、statViewServlet、webStatFilter等等
Springboot2+JPA|MyBatis+Sharding-JDBC示例源码,可直接运行。
Sharding-JDBC教程:Spring Boot整合Sharding-JDBC实现分库分表+读写分离
sharding-jdbc-4.0.0-rc1 整合spring boot 2+mybatis plus 分库分表Demo 可以直接跑起来
sharding-jdbc 3.1.0 不分片表,分页bug,第二页查出的数据会显示前面的数据 https://github.com/apache/incubator-shardingsphere/issues/1722 sharding-core-3.1.0.jar
基于springCloud+RocketMQ+Sharding-jdbc+Elastic-job微服务万信金融项目.zip ## 技术解决方案 1、微服务技术应用于P2P金融业务解决方案 2、接口规范SpringBoot+Swagger 3、持久层编码 MyBatis Plus 4、...
Sharding-JDBC教程:Spring Boot整合Sharding-JDBC实现读写分离
spring+mybatis+sharding-jdbc 1.3.1实现分库分表案例(可直接运行)
该资源是一个demo,结合mybatis演示sharding-jdbc开源分库分表框架的使用,有创建表SQL,直接导入即可
sharding-jdbc整合boot
Sharding-JDBC教程:Spring Boot2.0以上整合Sharding-JDBC实现分库分表+读写分离,Mysql数据库主从搭建:https://blog.csdn.net/forezp/article/details/94173427
spring4.0.2+mybatis3.2.4+sharding-jdbc1.4.2实现分库分表、主从及事物支持
Spring Boot + Sharding JDBC 实现分库分表(当当版),详见:https://blog.csdn.net/z1353095373/article/details/116273665
sharind-jdbc样例,当中包含了按月动态分表,一个比较简单的demo,仅供参考!……………………