Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: '广东省'
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355)
at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128)
at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2846)
at com.alibaba.druid.filter.FilterAdapter.statement_executeUpdate(FilterAdapter.java:2509)
at com.alibaba.druid.filter.FilterEventAdapter.statement_executeUpdate(FilterEventAdapter.java:327)
at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2844)
at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeUpdate(StatementProxyImpl.java:235)
at com.alibaba.druid.pool.DruidPooledStatement.executeUpdate(DruidPooledStatement.java:324)
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:510)
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:507)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:375)
... 105 more
insert into tb_rpt_mgn(OC_NAME,OO_NAME,ORDER_SOURCE,CLIENT_NAME,ORDER_NUMBER,CLIENT_NUMBER,RECIPIENT_NAME,RECIPIENT_DETAILADDRESS,ORDER_SN,TRUCKING_NUMBER,`status`,SENDERS_ADD,RECIPIENT_ADD,XL,OPR_ORG,BASETIME,FYEAR,FMONTH,FQUARTER,FWEEK,FDAY,OPSTIME,OPSJS,OPSWJS) SELECT OC_NAME,OO_NAME,ORDER_SOURCE,CLIENTNAME,ORDER_NUMBER,CLIENT_NUMBER,RECIPIENT_NAME,RECIPIENT_DETAILADDRESS,ORDER_SN,TRUCKING_NUMBER,`STATUS`, SENDERS_DETAILADDRESS AS SENDERS_ADD,RECIPIENT_AREA AS RECIPIENT_ADD,XL,OPR_ORG, REQ_RECEIPT_TIME as BASETIME, DATE_FORMAT(REQ_RECEIPT_TIME,'%y') AS FYEAR, RIGHT(CONCAT('0',ltrim(DATE_FORMAT(REQ_RECEIPT_TIME,'%m'))),2) AS FMONTH, CONCAT('0',QUARTER(REQ_RECEIPT_TIME)) AS FQUARTER, WEEK(REQ_RECEIPT_TIME) AS FWEEK, RIGHT(CONCAT('0',ltrim(DATE_FORMAT(REQ_RECEIPT_TIME,'%d'))),2) AS FDAY, HD_TIME AS OPSTIME, case WHEN (IFNULL(HD_TIME,NOW())>REQ_RECEIPT_TIME) THEN 0 ELSE 1 END AS OPSJS, case WHEN (IFNULL(HD_TIME,NOW())<=REQ_RECEIPT_TIME) THEN 0 ELSE 1 END AS OPSWJS FROM VW_RPT_MGN
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355)
at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128)
at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2846)
at com.alibaba.druid.filter.FilterAdapter.statement_executeUpdate(FilterAdapter.java:2509)
at com.alibaba.druid.filter.FilterEventAdapter.statement_executeUpdate(FilterEventAdapter.java:327)
at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2844)
at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeUpdate(StatementProxyImpl.java:235)
at com.alibaba.druid.pool.DruidPooledStatement.executeUpdate(DruidPooledStatement.java:324)
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:510)
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:507)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:375)
... 105 more
insert into tb_rpt_mgn(OC_NAME,OO_NAME,ORDER_SOURCE,CLIENT_NAME,ORDER_NUMBER,CLIENT_NUMBER,RECIPIENT_NAME,RECIPIENT_DETAILADDRESS,ORDER_SN,TRUCKING_NUMBER,`status`,SENDERS_ADD,RECIPIENT_ADD,XL,OPR_ORG,BASETIME,FYEAR,FMONTH,FQUARTER,FWEEK,FDAY,OPSTIME,OPSJS,OPSWJS) SELECT OC_NAME,OO_NAME,ORDER_SOURCE,CLIENTNAME,ORDER_NUMBER,CLIENT_NUMBER,RECIPIENT_NAME,RECIPIENT_DETAILADDRESS,ORDER_SN,TRUCKING_NUMBER,`STATUS`, SENDERS_DETAILADDRESS AS SENDERS_ADD,RECIPIENT_AREA AS RECIPIENT_ADD,XL,OPR_ORG, REQ_RECEIPT_TIME as BASETIME, DATE_FORMAT(REQ_RECEIPT_TIME,'%y') AS FYEAR, RIGHT(CONCAT('0',ltrim(DATE_FORMAT(REQ_RECEIPT_TIME,'%m'))),2) AS FMONTH, CONCAT('0',QUARTER(REQ_RECEIPT_TIME)) AS FQUARTER, WEEK(REQ_RECEIPT_TIME) AS FWEEK, RIGHT(CONCAT('0',ltrim(DATE_FORMAT(REQ_RECEIPT_TIME,'%d'))),2) AS FDAY, HD_TIME AS OPSTIME, case WHEN (IFNULL(HD_TIME,NOW())>REQ_RECEIPT_TIME) THEN 0 ELSE 1 END AS OPSJS, case WHEN (IFNULL(HD_TIME,NOW())<=REQ_RECEIPT_TIME) THEN 0 ELSE 1 END AS OPSWJS FROM VW_RPT_MGN
解决方案 »
- 我学了一年Java,不知道java_home是干什么的,大家帮帮忙!
- ServletContext获取properties文件内容
- SSH 打开 pdf 文件
- 基于ssh的框架
- 页面用IE浏览时提示java script错误
- 用HttpURLConnection模拟浏览器提交请求,非常急。
- Tomcat连接池连接多数据库的问题
- jsp读取数据出现乱码,SOS!!!
- 请问大家JSP页面中怎么使用 space(50) 这个函数.谢谢... 急...
- 关于javamail的问题,困扰几天了,郁闷啊!!
- 项目打jar包后,访问外部配置
- java使用axis2生成客户端,调用服务端webservice报错None
找下 广东省 这个值 对应着数据库的哪个列。