JavaWeb 项目开发中 - 新增客户信息功能 - 【保存】
执行 insert 语句,页面捕获异常 :
处理异常!com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/shandong/project/ibatis/sqlmap/personbasicmsg/piCusBasInfo.xml.
--- The error occurred while applying a parameter map.
--- Check the insertPiCusBasInfo-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: com.ibm.db2.jcc.am.ro: DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609, SQLERRMC=null, DRIVER=3.58.82
MyEclipse 后台报:
...
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/shandong/project/ibatis/sqlmap/personbasicmsg/piCusBasInfo.xml.
--- The error occurred while applying a parameter map.
--- Check the insertPiCusBasInfo-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: com.ibm.db2.jcc.am.ro: DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609, SQLERRMC=null, DRIVER=3.58.82
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:505)
...
SQL 语句拿出来 可以单独在 数据库中成功执行。
insert into PI_CUSBASINFO(
CUSTID,
REGIONCODE,
SUBTYPE,
CREDLEVEL,
ISSECRETCUST,
CUSTNAME,
OLDNAME,
ENAMEEVER,
FIRSTNAME,
LASTNAME,
BIRTHDAY,
SEX,
VOLK,
ISCOUNTION,
COUNTRY,
LIWACODE,
ORIGIN,
OFFICEDEPT,
DEPTPROPERTY,
DEPTTRADE,
DUTIES,
APPOINTMENT,
CUSTTITLE,
JOBSTARTDATE,
CURJOBSTART,
BECOMEMYCUST,
POLITICAL,
HEALTH,
EDUCATION,
GRADUATION,
ABIDANCE,
HYMEN,
FILIAL,
MARROWNAME,
MARROWCADTYPE,
MARROWCADNO,
MARROWJOBDEPT,
MARROWTEL,
LOANCARDNO,
LOANCARDCHKDATE,
FINANCIALNAME,
LOANCARDPW,
ISMYEMPLOYEE,
ISMYSTOCKHOLDER,
STOCKTYPE,
STOCKLMT,
STOCKNO,
ISMYRELATION,
ISCUSTODIALBOX,
ISPREFERENTIAL,
PFENDDATE,
ISVIP,
VIPTYPE,
VIPCODE,
ISRSCUST,
ISWGCCUST,
ISAGENT,
ISBADCUST,
DEBTPERIOD,
CSDCREATDATE,
DEPOSITAMT,
AVGFINACE,
ISBLACKLIST,
CREDRECORDOUT,
CREDRECORDIN,
CHECKCYCLE,
CHECKSENDTYPE,
CHECKSENDADDR,
CUSTSTATE,
CHANNELCODE,
CUSTMGR,
DEPTCODE,
ORGCODE,
INPUTER,
INPUTDATE,
remark,
familymemerber,
belongorg,
belongorglncard,
custided,
regioncodeed,
loadcardno,
daybaramt,
daybalcurrency,
firstadmin,
firstadmindept,
secondadmin1,
secondadmin1dept,
secondadmin2,
secondadmin2dept,
custchater,
workenddate,
asset,
assurerate,
workdate,
intendincome,
ecrsresult,
spouseecrsresult,
DEPTADDR,
DEPTPOSTCODE,
PROFESSION,
EDUBACKGROUND,
SOCIALNO,
ISCHECK,
custLevel,
cardtype,
cardno,
officeDeptNo)
values(
'2000500058',
'0769',
'',
'',
'',
'大概',
'',
'',
'',
'',
'1997-09-18',
'1',
'',
'1',
'CHN',
'',
'',
'534',
'0005',
'N',
'1',
'',
'',
'2010-09-19',
'2010-09-19',
'2010-09-19',
'',
'',
'50',
'',
'',
'22',
'',
'',
'',
'',
'',
'',
'',
'2010-09-19',
'',
'',
'',
'',
'',
0.0,
'',
'',
'',
'',
'2010-09-19',
'',
'',
'',
'',
'',
'',
'',
0,
'2010-09-19',
0.0,
0.0,
'0',
'',
'',
'',
'',
'',
'0'||'0'||'0',
'',
'y00000a7',
'100000',
'',
'y00000a7',
'2010-12-31',
'',
5,
'',
'',
'',
'',
'',
0.0,
'',
'',
'',
'',
'',
'',
'',
'07',
'',
0.0,
0.0,
'',
0.0,
'',
'',
'',
'',
'0004',
'0003',
'',
'',
'',
'4',
'4',
'')
小猫推测,可能是数据库的配置有问题,但是
DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609, SQLERRMC=null, DRIVER=3.58.82 ,异常代码在网上搜索无果。。。。
望各位高手指导。。。。。谢谢!