DBUnit向mysql导数据异常
来源:互联网 发布:动态图截取软件 编辑:程序博客网 时间:2024/05/01 00:09
C:\Users\Administrator\Desktop\defaultDB - mysql专用\build.xml:50: org.dbunit.DatabaseUnitException: java.sql.SQLException: Incorrect string value: '\xE3\x80\x8A\xE8\xAE\xBE...' for column 'DOCCONTENT' at row 1at org.dbunit.ant.Operation.execute(Operation.java:175)at org.dbunit.ant.DbUnitTask.execute(DbUnitTask.java:272)at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)at org.apache.tools.ant.Task.perform(Task.java:348)at org.apache.tools.ant.Target.execute(Target.java:392)at org.apache.tools.ant.Target.performTasks(Target.java:413)at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)at org.apache.tools.ant.Project.executeTargets(Project.java:1251)at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)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 org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)at org.apache.tools.ant.Task.perform(Task.java:348)at org.apache.tools.ant.Target.execute(Target.java:392)at org.apache.tools.ant.Target.performTasks(Target.java:413)at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)at org.apache.tools.ant.Project.executeTarget(Project.java:1368)at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)at org.apache.tools.ant.Project.executeTargets(Project.java:1251)at org.apache.tools.ant.Main.runBuild(Main.java:811)at org.apache.tools.ant.Main.startAnt(Main.java:217)at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)java.sql.SQLException: Incorrect string value: '\xE3\x80\x8A\xE8\xAE\xBE...' for column 'DOCCONTENT' at row 1at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:773)at org.dbunit.database.statement.SimplePreparedStatement.addBatch(SimplePreparedStatement.java:67)at org.dbunit.database.statement.AutomaticPreparedBatchStatement.addBatch(AutomaticPreparedBatchStatement.java:57)at org.dbunit.operation.AbstractBatchOperation.execute(AbstractBatchOperation.java:178)at org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:67)at org.dbunit.ant.Operation.execute(Operation.java:171)at org.dbunit.ant.DbUnitTask.execute(DbUnitTask.java:272)at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)at org.apache.tools.ant.Task.perform(Task.java:348)at org.apache.tools.ant.Target.execute(Target.java:392)at org.apache.tools.ant.Target.performTasks(Target.java:413)at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)at org.apache.tools.ant.Project.executeTargets(Project.java:1251)at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)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 org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)at org.apache.tools.ant.Task.perform(Task.java:348)at org.apache.tools.ant.Target.execute(Target.java:392)at org.apache.tools.ant.Target.performTasks(Target.java:413)at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)at org.apache.tools.ant.Project.executeTarget(Project.java:1368)at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)at org.apache.tools.ant.Project.executeTargets(Project.java:1251)at org.apache.tools.ant.Main.runBuild(Main.java:811)at org.apache.tools.ant.Main.startAnt(Main.java:217)at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)Total time: 25 seconds
开始以为是编码问题,后来经过查询,发现服务器端编码和客户端编码都是UTF-8编码,所以编码没问题;
通过 show character set;命令发现Utf8编码的最大编码长度为3,这个似乎不会影响都数据的存储,但是怀疑是不是字段的长度限制的问题,把DocContent这个字段类型从Text设置LongText,问题解决。
Text、MediumText和LongText支持的长度如下(来自MySql 5.1手册):
TINYTEXT
最大长度为255(28–1)字符的TEXT列。
TEXT[(M)]
最大长度为65,535(216–1)字符的TEXT列。
可以给出可选长度M。则MySQL将列创建为最小的但足以容纳M字符长的值的TEXT类型。
MEDIUMTEXT
最大长度为16,777,215(224–1)字符的TEXT列。
LONGTEXT
最大长度为4,294,967,295或4GB(232–1)字符的TEXT列。LONGTEXT列的最大有效(允许的)长度取决于客户端/服务器协议中配置最大包大小和可用的内存。
- DBUnit向mysql导数据异常
- DBUnit导数据报表名超长、MBCS字段被截断
- Mysql之导数据
- Mysql 导数据
- mysql导数据库
- MySQL导数据
- 利用sqoop从mysql向hbase导数据(拼接mysql多字段做为hbase rowkey)
- sql 向另一个表导数据
- mysql 导数据库命令
- mysql 导数据库命令
- mysql 导数据库命令
- mysql导数据及注意事项
- 导数据中的网络引起的异常
- org.dbunit.database.AmbiguousTableNameException异常
- mysql往infobright中按天导数据脚本
- Window下使用mysql命令行导数据
- R语言导数据到MYSQL
- sql2005数据库导数据到mysql中
- [Leetcode] Partition List
- C#位运算 http://www.cnblogs.com/sweting/archive/2009/11/05/1596873.html
- JVM调优总结(二)-一些概念
- 07 - 基本控件:ListView 列表
- 多线程信号量控制
- DBUnit向mysql导数据异常
- Oracle存储过程
- libgdx 环境搭建
- 仿豌豆荚实现android连接pc方法
- JVM调优总结(三)-基本垃圾回收算法
- Tomcat一步步实现反向代理、负载均衡、内存复制
- SCOPE_IDENTITY和@@identity的区别
- dealloc Don't Use Accessor Methods in Init and Dealloc
- linux下配置虚拟主机