Today query a day to find the problem, with Ibatis do batch operation, error:
[Non-atomic batch failure] use Getnextexception () to retrieve the exception of a specific element that has been batched. errorcode=-4228, Sqlstate=null
Think is what table space problem, later found still table field ' brand_nm ' length set small, for varchar (25) caused, but look at the value length: Natural Incense Rhyme (NATURE CHARM), is 22 characters ah, very strange.
SELECT * FROM Dmc_tc_rule_basic_cfg
SELECT * FROM Dmc_tc_rule_basic
--Delete
Delete (
SELECT * FROM Dmc_tc_rule_basic_str_rel
)
--Query table records
Select *from syscat.columns where tabname = Upper (' dmc_tc_rule_basic_cfg ') and colname = ' brand_nm '
--Modify Table column length
ALTER TABLE dmc_tc_rule_basic_cfg ALTER COLUMN BRAND_NM SET data type varchar (40)
Reference related documents: http://blog.csdn.net/mcpang/article/details/8241854