oracle数据源，数据类型是timestamp，保存数据失败

我试验了一下，配置都变，对比apijson和mybatisplus 分别去写表，druid 打印的日志如下：
apijson：
2021-09-15 11:16:54.050 |-DEBUG [http-nio-8085-exec-3] druid.sql.Statement [137] -| {conn-110005, pstmt-120005} created. INSERT INTO Z_user7(id,name,create_time) VALUES(?,?,?)
2021-09-15 11:16:54.051 |-DEBUG [http-nio-8085-exec-3] druid.sql.Statement [137] -| {conn-110005, pstmt-120005} created. INSERT INTO Z_user7(id,name,create_time) VALUES(?,?,?)
2021-09-15 11:16:54.051 |-DEBUG [http-nio-8085-exec-3] druid.sql.Statement [137] -| {conn-110005, pstmt-120005} Parameters : ** [3, dd, 2020-9-16 12:20:33]** 
2021-09-15 11:16:54.052 |-DEBUG [http-nio-8085-exec-3] druid.sql.Statement [137] -| {conn-110005, pstmt-120005} Types :  **[VARCHAR, VARCHAR, VARCHAR]** 
2021-09-15 11:16:54.052 |-DEBUG [http-nio-8085-exec-3] druid.sql.Statement [137] -| {conn-110005, pstmt-120005} Parameters : [3, dd, 2020-9-16 12:20:33]
2021-09-15 11:16:54.053 |-DEBUG [http-nio-8085-exec-3] druid.sql.Statement [137] -| {conn-110005, pstmt-120005} Types : [VARCHAR, VARCHAR, VARCHAR]
2021-09-15 11:16:54.112 |-ERROR [http-nio-8085-exec-3] druid.sql.Statement [152] -| {conn-110005, pstmt-120005} execute error. INSERT INTO Z_user7(id,name,create_time) VALUES(?,?,?)

mybatisplus：
2021-09-15 11:19:22.829 |-DEBUG [http-nio-8085-exec-4] druid.sql.Statement [137] -| {conn-110005, pstmt-120000} Parameters : [0f87eae8-328b-4ead-b1b5-ba84eb1a2d34, 9471ecb1-99ae-4324-9040-a5b728547fa6, 2021-09-15 11:19:22.796, 2021-09-15 11:19:22.796]
2021-09-15 11:19:22.829 |-DEBUG [http-nio-8085-exec-4] druid.sql.Statement [137] -| {conn-110005, pstmt-120000} Types : [VARCHAR, VARCHAR, TIMESTAMP, TIMESTAMP]
2021-09-15 11:19:22.830 |-DEBUG [http-nio-8085-exec-4] druid.sql.Statement [137] -| {conn-110005, pstmt-120000} Parameters : ** [0f87eae8-328b-4ead-b1b5-ba84eb1a2d34, 9471ecb1-99ae-4324-9040-a5b728547fa6, 2021-09-15 11:19:22.796, 2021-09-15 11:19:22.796]** 
2021-09-15 11:19:22.830 |-DEBUG [http-nio-8085-exec-4] druid.sql.Statement [137] -| {conn-110005, pstmt-120000} Types :  **[VARCHAR, VARCHAR, TIMESTAMP, TIMESTAMP]** 
2021-09-15 11:19:22.862 |-DEBUG [http-nio-8085-exec-4] druid.sql.Statement [137] -| {conn-110005, pstmt-120000} executed. 33.653619 millis. INSERT INTO lcap_model  ( id,

发现mybatisplus 是识别到了时间格式。

GVP 腾讯开源/APIJSON

内容风险标识

评论 (13)

GVP腾讯开源/APIJSON

内容风险标识