EXCEPTIONS

最新推荐文章于 2024-01-26 05:00:00 发布

原创最新推荐文章于 2024-01-26 05:00:00 发布 · 459 阅读

0 ·

CC 4.0 BY-SA版权

简单记录一下：

1：SQL存储过程调用错误----???

DELIMITER $$
DROP PROCEDURE IF EXISTS `dbgirl`.`getRecord` $$
CREATE PROCEDURE `dbgirl`.`getRecord` (
IN in_id INTEGER,
OUT out_name VARCHAR(20),
OUT out_age INTEGER)
BEGIN
SELECT name, age
INTO out_name, out_age
FROM abean where id = in_id;
END $$
DELIMITER ;

xception in thread "main" org.springframework.dao.TransientDataAccessResourceException: CallableStatementCallback; SQL [{call getrecord()}];

Parameter out_name is not registered as an output parameter;

nested exception is java.sql.SQLException: Parameter out_name is not registered as an output parameter

2：数据库连接错误

SQLException: The server time zone value ‘�й��׼ʱ��’ is unrecognized

原因：用了新版本的MySQL驱动

解决：
URL需要加上一些必要的后缀信息：
spring.datasource.url=jdbc:mysql://localhost:3306/chat?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC