腾讯微博api获得的微博数据入不了mysql数据库

[liugangfeng8]

[INFO] XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
[INFO] SQLErrorCodesFactory - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at cn.my7g.pandora.crawler.utils.ReflectionUtil.invokeMethod(ReflectionUtil.java:149)
at cn.my7g.pandora.crawler.threadpool.model.FreeThreadModel.excute(FreeThreadModel.java:29)
at cn.my7g.pandora.crawler.threadpool.utils.SuperThread.run(SuperThread.java:33)
Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [REPLACE INTO t_user_status(id,name,nick,head,location,country_code,province_code,city_code,text,origtext,image,count,mcount,video_picurl,video_player,video_realurl,video_shorturl,video_title,music_author,music_url,music_title,self,timestamp,type,isvip,status,source,fname,flag) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Data truncation: Data too long for column 'text' at row 1; nested exception is java.sql.BatchUpdateException: Data truncation: Data too long for column 'text' at row 1
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:614)
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:883)
at cn.my7g.pandora.dao.impl.QqTStatusDaoImpl.saveQqTStatusInterestedList(QqTStatusDaoImpl.java:121)
at cn.my7g.pandora.service.UserDataBean.execute(UserDataBean.java:84)
... 7 more
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'text' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
at com.jolbox.bonecp.StatementHandle.executeBatch(StatementHandle.java:469)
at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:898)
at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:1)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
... 11 more

[安特矮油]

Data truncation: Data too long for column 'text' at row 1; nested exception is java.sql.BatchUpdateException: Data truncation: Data too long for column 'text' at row 1
数据太长了，可能是你text这个字段的长度小于了传入参数的长度

[liugangfeng8]

不是那个问题是特殊字符的问题，我的数据库是编码是utf8

[安特矮油]

如果真如你所说，那么就是这些特殊字没办法识别所以导致乱码，从而使得数据超长，你可以试着改变编码改成Unicode或者GBK等等试试吧