sharding-jdbc-spring-boot-starter 整合 mybatis-plus-boot-starter + druid
sharding-jdbc-spring-boot-starter 整合 mybatis-plus-boot-starter + druid
sharding-jdbc整合 mybatis-plus + druid
shardingsphere分库分表
================================
©Copyright 蕃薯耀 2020-10-21
https://www.cnblogs.com/fanshuyao/
一、环境:
<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
https://www.cnblogs.com/fanshuyao/
相关文章
- spring boot-mybatis全注解化(3)
- spring boot: @Entity @Repository一个简单的数据读存储读取
- spring boot: spring Aware的目的是为了让Bean获得Spring容器的服务
- 解决Spring Boot OTS parsing error: Failed to convert WOFF 2.0
- spring boot:rabbitmq用topic模式发送接收消息(spring boot 2.4.4)
- spring boot:使mybatis访问多个druid数据源(spring boot 2.3.2)
- spring boot:用zxing生成二维码,支持logo(spring boot 2.3.2)
- spring boot:使用mybatis访问多个mysql数据源/查看Hikari连接池的统计信息(spring boot 2.3.1)
- Spring Boot新模块devtools
- [Spring boot] Configuring and Accessing a Data Source
- [Spring boot] Application properties and configurations
- spring boot:接收数组参数及多文件混合json参数(spring boot 2.3.4)
- spring boot:配置shardingsphere(sharding jdbc)使用druid数据源(druid 1.1.23 / sharding-jdbc 4.1.1 / mybatis / spring boot 2.3.3)
- spring boot:构建多模块项目(spring boot 2.3.1)
- Spring Boot 热部署插件
- 10_Spring Boot 集成Dubbo + Mybatis + Redis
- 优雅处理 Spring Boot 日志文件:高效、可维护的日志管理方案详解
- Spring+SpringMVC+Mybatis(开发必备技能)04、mybatis自动生成mapper_dao_model(包含工具与视频讲解) 纯绿色版本、配套使用视频,100%运行成功
- 学习Spring Boot:(十四)spring-shiro的密码加密
- 学习Spring Boot:(十二)Mybatis 中自定义枚举转换器
- 学习Spring Boot:(八)Mybatis使用分页插件PageHelper
- SpringBoot学习笔记(五)——Spring Boot中使用MyBatis进阶
- Spring+SpringMVC+Mybatis(开发必备技能)04、mybatis自动生成mapper_dao_model(包含工具与视频讲解) 纯绿色版本、配套使用视频,100%运行成功