Comments (2)
不用更改任何代码,使用mysql 5.7,运行mysqlTest,经过测试是可以的:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 66249
Server version: 5.7.19 MySQL Community Server (GPL)
。。。。
16:03:18.442 [main] INFO dbdemo.mysql.test.MysqlTest - ====user==== user name:user, department name:开发部, role name:admin
上面是我在mac os 10.12.5中的测试结果。
如果升级了spring boot版本之后,连接数据源的配置中如果安全验证报错可以要加上“&useSSL=false”
from spring-boot-db.
在debug中看到了 @chenfromsz 所述的warning,在test/JpaConfigration.java中的dataSource方法中,由
dataSource.setUrl("jdbc:mysql://localhost:3306/test?characterEncoding=utf8");
变为
dataSource.setUrl("jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=false");
即可解决。
from spring-boot-db.
Related Issues (13)
- java.sql.SQLException: Incorrect string value: '\xE5\xBC\x80\xE5\x8F\x91...' for column 'name' at row 1 HOT 3
- jpa单元测试一直报如下错误,请问该如何解决?springboot版本2.0.3 HOT 2
- 代码报错 org.springframework.beans.factory.BeanCreationException: Error creating bean with name xxx HOT 1
- 使用V2.0分支,修改neo4j的配置后运行,报neo4j语法错误,使用的neo4j的版本是neo4j-community-3.0.7,麻烦作者帮忙解答下。 HOT 4
- java.lang.IllegalStateException: Failed to load ApplicationContext HOT 1
- Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; HOT 1
- naming-strategy过时替代? HOT 4
- Error creating bean with name 'movieRepository': Could not resolve matching constructor (hint: specify index/type/name arguments for simple parameters to avoid type ambiguities) HOT 1
- 第二章 在springBoot中使用数据库mysql篇dbdemo.mysql.test.JpaConfiguration.java需要手动编写吗 HOT 3
- [建议] 使用分支的形式代替子模块
- 为什么下载下来,到 IDEA 运行还是会出错 HOT 3
- 建议更新MySQL部分的readme HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from spring-boot-db.