解决ssm框架下对数据库操作时出现Data truncation: Data too long for column 'xxx' at row 1异常

这里我用的mybatis版本是3.4.0

我发生这个问题的基础条件是在本身存在的框架之下，就是说用的自动生成的model，mapper接口和mapper.xml，这样一般来说就不存在mapper.xml中传参时配置问题，但是还是会出现如下异常:

严重: Servlet.service() for servlet [spring] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: com.mes.dao.MesProductMapper.insertSelective (batch index #1) failed. Cause: java.sql.BatchUpdateException: Data truncation: Data too long for column 'product_materialsource' at row 1
; SQL []; Data truncation: Data too long for column 'product_materialsource' at row 1; nested exception is java.sql.BatchUpdateException: Data truncation: Data too long for column 'product_materialsource' at row 1] with root cause
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'product_materialsource' at row 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4230)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2838)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1933)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1393)

实际上很多 原因都可能导致这个异常产生，比如说MyBatis在使用select节点查询时传递多个参数时发生错误产生，所以这里只说我发生的异常处理方法。
由于我是需要将xml格式的内容转存到数据库中，就需要spring在web请求中定义编码，通过类org.springframework.web.filter.CharacterEncodingFilter，定义request和response的编码。具体做法是，在WEB-INF下面的web.xml中定义一个Filter：

<filter>
		<filter-name>encodingFilter</filter-name>
		<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
		<init-param>
			<param-name>encoding</param-name>
			<param-value>UTF-8</param-value>
		</init-param>
		<init-param>
			<param-name>forceEncoding</param-name>
			<param-value>true</param-value>
		</init-param>
	</filter>
	<filter-mapping>
		<filter-name>encodingFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>

可以提一下的是CharacterEncodingFilter类具有encoding和forceEncoding两个属性，其中encoding是表示设置request的编码，forceEncoding表示是否同时设置response的编码。