springboot2 Unable to translate SQLException with Error code '1406', will now try the fallback translator

这个错误实际是字段过长，本来由于log问题，没看出来，自己写了一个测试类，直接抛出异常了。

09:07:18.956 [pool-3-thread-1] DEBUG org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:178) - SQL error codes for 'MySQL' found

09:07:18.957 [pool-3-thread-1] DEBUG org.springframework.jdbc.support.SQLErrorCodesFactory.registerDatabase(SQLErrorCodesFactory.java:246) - Caching SQL error codes for DataSource [com.zaxxer.hikari.HikariDataSource@1bdde09a]: database product name is 'MySQL'

09:07:18.959 [pool-3-thread-1] DEBUG org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:284) - Unable to translate SQLException with Error code '1406', will now try the fallback translator

09:07:18.961 [pool-3-thread-1] DEBUG org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98) - Extracted SQL state class '22' from value '22001'

09:07:18.932 [pool-3-thread-1] DEBUG org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:202) - Looking up default SQLErrorCodes for DataSource [com.zaxxer.hikari.HikariDataSource@1bdde09a]

09:07:18.808 [pool-3-thread-1] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:395) - Loaded 11 bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]

09:07:18.808 [pool-3-thread-1] DEBUG org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:213) - Creating shared instance of singleton bean 'DB2'

09:07:17.948 [pool-3-thread-1] DEBUG org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) - ==> Preparing: insert into film(name,fno,magnet,ourl,pdate,duration,director ,manufacturer,publisher,actorid,description,scenario,create_time, update_time,category,bigcate,zone,imgpath,thumb,imgurl,thumburl) values(?,?, ?,?, STR_TO_DATE(?,'%Y-%m-%d'), ?, ?,?, ?,?, ?, ? ,now(),now(),?, ?,?, ?, ?,? ,? )

09:07:17.969 [pool-3-thread-1] DEBUG org.apache.ibatis.logging.jdbc.BaseJdbcLogger.debug(BaseJdbcLogger.java:143) - ==> Parameters: SexArt – Michelle H & Sybil A(String), (String), (String), .top/V/83759.html(String), null, null, null, null, null, null, SexArt – Michelle H & Sybil A<br /><br />As the day draws to a close and “Sunset” approaches, sexy redhead Michelle H and slender brunette Sybil A are enjoying some peaceful time together. Blue-eyed beauty Michelle is fixing her make-up ready for a night out, and as she leans in to apply lip gloss to her girlfriend’s pretty lips, she can’t resist unbuttoning her plaid shirt and caressing her perfect breasts. Sybil spreads her legs and Michelle takes the cue to slide her hand inside Sybil’s shorts and stroke her pussy. She strips the tanned cutie naked and turns her onto her knees, licking the smooth pink folds of her shaven pussy eagerly, making her juice up with pleasure. Michelle slips two fingers into Sybil’s tight hole and uses them like a cock, thrusting in and out. Sybil rubs her clit as Michelle’s drilling spurs her on to orgasm, showing her gratitude through passionate, open-mouthed kisses. Now Michelle slips out of her dress to stand over Sybil, who eagerly helps her out of her frilly lace underwear, pawing at Michelle’s beautiful breasts with their hard nipples. Pulling Michelle’s panties off, Sybil plays with Michelle’s clit as she straddles her and grinds on her lap. They switch places, Michelle spreading her thighs to let Sybil lick and finger her hungrily. Sybil watches her lover closely as she works her fingers into her slit, kissing her and thrilling to the sight of Michelle as she writhes with lust. Sybil’s expert touch brings Michelle’s climax crashing over her. The girls sit side by side and stroke their fingers against each other’s clit, racing to a second orgasm. As they dress and stroll out to enjoy the beautiful Mallorcan sunset, their deep connection is plain to see.<br/>收集于互联网!(String), null, null, null, 欧美(String), null, null, (String), http://pic.888xinxin.com/pic/uploadimg/2017-3/83759.jpg(String)

09:07:18.039 [pool-3-thread-1] DEBUG org.mybatis.logging.Logger.debug(Logger.java:49) - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3e1de960]

Exception in thread "main" org.springframework.dao.DataIntegrityViolationException:

### Error updating database. Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'description' at row 1

### The error may exist in com/utravel/mapper/FilmMapper.xml

### The error may involve com.utravel.mapper.FilmMapper.addFilm-Inline

### The error occurred while setting parameters

### SQL: insert into film(name,fno,magnet,ourl,pdate,duration,director ,manufacturer,publisher,actorid,description,scenario,create_time, update_time,category,bigcate,zone,imgpath,thumb,imgurl,thumburl) values(?,?, ?,?, STR_TO_DATE(?,'%Y-%m-%d'), ?, ?,?, ?,?, ?, ? ,now(),now(),?, ?,?, ?, ?,? ,? )

### Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'description' at row 1

; Data truncation: Data too long for column 'description' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'description' at row 1

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)

at com.sun.proxy.$Proxy69.insert(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)

at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)

at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)

at com.sun.proxy.$Proxy71.addFilm(Unknown Source)

at com.utravel.service.impl.FilmServiceImpl.addFilm(FilmServiceImpl.java:22)

at com.utravel.tv.CrawlRunnable.ProcessDetailPage(CrawlRunnable.java:162)

at com.utravel.DemoApplication.main(DemoApplication.java:44)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.intellij.rt.execution.application.AppMain.main(AppMain.java:140)

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'description' at row 1

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4072)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)

at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)

at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)

at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)

at com.sun.proxy.$Proxy85.execute(Unknown Source)

at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)

at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)

at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)

at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)

at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)

at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)

at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)

... 13 more