日期:2014-05-20 浏览次数:20912 次
[WARN ] 121206 11:22:45,093 JDBCExceptionReporter:77 - SQL Error: 0, SQLState: 22001
[ERROR] 121206 11:22:45,093 JDBCExceptionReporter:78 - Data truncation: Data too long for column 'swsystraceaudnum' at row 1
line=111,222,333,444,555
str=111,222,333,444,555
[line-0]=111
[line-1]=222
[line-2]=333
[line-3]=444
[line-4]=555
[DEBUG] 121206 11:22:44,953 SQL:102 - select count(*) as col_0_0_ from vip_bank_inputdetail vipbankinp0_ where vipbankinp0_.panval='222' and vipbankinp0_.swsystraceaudnum='444'
detail exist,num=0
*******************
*****str4=555
*******************
id=12511121314
time=555
[DEBUG] 121206 11:22:45,031 SQL:102 - select vipbankinp_.id, vipbankinp_.merchantstype as merchant2_39_, vipbankinp_.panval as panval39_, vipbankinp_.amountoftxn as amountof4_39_, vipbankinp_.swsystraceaudnum as swsystra5_39_, vipbankinp_.timeofoctxn as timeofoc6_39_, vipbankinp_.status as status39_ from vip_bank_inputdetail vipbankinp_ where vipbankinp_.id=?
[DEBUG] 121206 11:22:45,046 SQL:102 - update vip_bank_inputdetail set merchantstype=?, panval=?, amountoftxn=?, swsystraceaudnum=?, timeofoctxn=?, status=? where id=?
[WARN ] 121206 11:22:45,093 JDBCExceptionReporter:77 - SQL Error: 0, SQLState: 22001
[ERROR] 121206 11:22:45,093 JDBCExceptionReporter:78 - Data truncation: Data too long for column 'swsystraceaudnum' at row 1
[ERROR] 121206 11:22:45,109 AbstractFlushingEventListener:301 - Could not synchronize database state with session
org.hibernate.exception.DataException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:251)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
File saveFile = null;
if(penvalFile != null){
saveFile = new File(fileName);
if(!saveFile.getParentFile().exists()){
saveFile.getParentFile().mkdirs();
}
FileUtil.copy(penvalFile, saveFile);
}
if(!saveFile.exists()){//上传出错,提示用户重新上传
this.setMsg("上传失败,请重新上传!");
}else{
//2.读取上传后的文件,保存至数据库
BufferedReader br = null;
String line = null;
String str = null;
VipBankInputDetail vbi = null;
try{
br = new BufferedReader(new FileReader(saveFile), 1024);
while((line= br.readLine()) != null){
System.out.println("line=" + line);
str = new String(line.getBytes("GBK"));
System.out.println("str=" + str);