配置jdbc时注意特殊字符的转码

Thu Aug 18 11:06:57 CST 2016 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

原xml文件

出错原因是马老师的mysql版本较低 而当我们用高本版的mysql时注意要指定

?characterEncoding=utf8&useSSL=false

也就是改为
jdbc:mysql://localhost:3306/spring?characterEncoding=utf8&useSSL=false

又出现先的错误:

The reference to entity “useSSL” must end with the ‘;’ delimiter. Nested exception: The reference to entity “useSSL” must end with the ‘;’ delimiter.

经过查找资料:
The ampersand & is a special character in HTML and XML. If you want to use it as a normal chararacter, you have to encode it correctly. Write & instead of &:

src=”…9623&w=180&h=46&style=white&variant=text&loc=en_US”
& denotes the start of an encoded entity, such as < for <, or & for &. Entities are always terminated by an ;, thus if the ; is missing you get the error message.

也就是说在html和xml等文件中&是特殊格式字符
需要转意 把&替换成&即可

最终修改为:

jdbc:mysql://localhost:3306/hibernate?characterEncoding=utf8&useSSL=false

问题解决!

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 3
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 3
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值