[FLINK-15443] Use JDBC connector write FLOAT value occur ClassCastException

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.1
• Fix Version/s: 1.9.2, 1.10.0
• Component/s: Connectors / JDBC
• Labels: pull-request-available

Environment

flink version is 1.9.1

• Assignee: Jingsong Lee
• Reporter: Xianxun Ye
• Created: 31/Dec/19 07:13
• Updated: 02/Jan/20 08:03
• Resolved: 02/Jan/20 08:03

Description

I defined a float type field in mysql table, when I use jdbc connector write float value into db, there are ClassCastException occurs.

//代码占位符
Caused by: java.lang.ClassCastException: java.lang.Float cannot be cast to java.lang.Double, field index: 6, field value: 0.1.Caused by: java.lang.ClassCastException: java.lang.Float cannot be cast to java.lang.Double, field index: 6, field value: 0.1. Caused by: java.lang.ClassCastException: java.lang.Float cannot be cast to java.lang.Double, field index: 6, field value: 0.1.Caused by: java.lang.ClassCastException: java.lang.Float cannot be cast to java.lang.Double, field index: 6, field value: 0.1.  at org.apache.flink.api.java.io.jdbc.JDBCUtils.setField(JDBCUtils.java:106)  at org.apache.flink.api.java.io.jdbc.JDBCUtils.setRecordToStatement(JDBCUtils.java:63) at org.apache.flink.api.java.io.jdbc.writer.AppendOnlyWriter.addRecord(AppendOnlyWriter.java:56) at org.apache.flink.api.java.io.jdbc.JDBCUpsertOutputFormat.writeRecord(JDBCUpsertOutputFormat.java:144)

 

Issue Links

• links to: GitHub Pull Request #10731
• links to: GitHub Pull Request #10741