问题遇到的现象和发生背景
在学习spring的jdbc template过程中
问题相关代码,请勿粘贴截图
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<!--数据库连接地址-->
<property name="url" value="jdbc:mysql://127.0.0.1:3306/schooldata?serverTimezone=UTC"/>
<!--数据库的用户名-->
<property name="username" value="root"/>
<!--数据库的密码-->
<property name="password" value="root"/>
<!--数据库驱动-->
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
</bean>
运行结果及报错内容
五月 07, 2022 4:13:08 下午 com.alibaba.druid.support.logging.JakartaCommonsLoggingImpl info
信息: {dataSource-1} inited
五月 07, 2022 4:13:08 下午 com.alibaba.druid.support.logging.JakartaCommonsLoggingImpl error
严重: create connection SQLException, url: jdbc:mysql://127.0.0.1:3306/schooldata?serverTimezone=UTC, errorCode 0, state S1000
java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.