hibernate保存数据报错

itxiyuan

hibernate保存数据报错

1. org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into ORC_T_BUSINESS_TRACK (BUSI_NUM, BUSI_TYPE, CREATE_DATE, CREATE_USER_NAME, CREATE_USER_NUM, REMARK, ID) values (?, ?, ?, ?, ?, ?, ?)]; ctraint [null]; nested exception is org.hibernate.exception.CtraintViolationException: Could not execute JDBC batch update
   
2. at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:643)
   
3. at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:104)
   
4. at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:516)
   
5. at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
   
6. at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
   
7. at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:394)
   
8. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
   
9. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   
10. at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
    
11. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    
12. at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
    
13. at com.bsteel.shdc.service.OrcTBusinessTrackServiceImpl$EnhancerByCGLIB$416c9ca9.saveOrcTBusinessTrack(<generated>)
    
14. at com.bsteel.shdc.bankservice.finance.redeem.controller.AuditController.signaTure1(AuditController.java:642)
    
15. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
16. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    
17. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    
18. at java.lang.reflect.Method.invoke(Unknown Source)
    
19. at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)
    
20. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)
    
21. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
    
22. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
    
23. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
    
24. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
    
25. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
    
26. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
    
27. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
    
28. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
    
29. at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    
30. at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
    
31. at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
    
32. at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1221)
    
33. at com.bsteel.shdc.manager.permission.filter.AuthFilter.doFilter(AuthFilter.java:101)
    
34. at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
    
35. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
    
36. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
    
37. at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
    
38. at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
    
39. at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
    
40. at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
    
41. at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
    
42. at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)
    
43. at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
    
44. at org.mortbay.jetty.Server.handle(Server.java:326)
    
45. at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
    
46. at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
    
47. at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
    
48. at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
    
49. at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
    
50. at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
    
51. at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
    
52. Caused by: org.hibernate.exception.CtraintViolationException: Could not execute JDBC batch update
    
53. at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
    
54. at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    
55. at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
    
56. at org.hibernate.engine.ActionQueue.executeActi(ActionQueue.java:262)
    
57. at org.hibernate.engine.ActionQueue.executeActi(ActionQueue.java:178)
    
58. at org.hibernate.event.def.AbstractFlushingEventListener.performExecuti(AbstractFlushingEventListener.java:321)
    
59. at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
    
60. at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206)
    
61. at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:375)
    
62. at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
    
63. at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:76)
    
64. at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:512)
    
65. ... 47 more
    
66. Caused by: java.sql.BatchUpdateException: ORA-01401: inserted value too large for column
    
67. at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:345)
    
68. at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10844)
    
69. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
    
70. at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
    
71. at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
    
72. ... 56 more

复制代码

以上是报错信息

1. Map<String,String> user=new HashMap<String,String>();
   
2. user.put(LSCtants.USER_LOGIN_NO, (String) getUseInfo().get(LSCtants.USER_LOGIN_NO));
   
3. user.put(LSCtants.USER_LOGIN_NAME, (String) getUseInfo().get(LSCtants.USER_LOGIN_NAME));
   
4. orcTBusinessTrackService.saveOrcTBusinessTrack(redeemCode, "ARGUEREDEEM_COUNT", "赎单已完成", user);这是我调用的方法

复制代码

数据都是有的 调试的时候都已经取到 但是为啥保存不到数据库里 /**

1. * 保存订单跟踪信息
   
2. * busiNum:订单号
   
3. * busiType：订单类型 如制单申请WARRANTY_APP
   
4. * desc:描述
   
5. * user:操作员信息
   
6. */
   
7. @Override
   
8. public void saveOrcTBusinessTrack(String busiNum, String busiType,String desc,
   
9. Map<String, String> user) {
   
10. // TODO Auto-generated method stub
    
11. OrcTBusinessTrack orcTBusinessTrack=new OrcTBusinessTrack();
    
12. orcTBusinessTrack.setId(GuidUtil.newGuid());
    
13. orcTBusinessTrack.setBusiNum(busiNum);
    
14. orcTBusinessTrack.setBusiType(busiType);
    
15. orcTBusinessTrack.setRemark(desc);
    
16. orcTBusinessTrack.setCreateDate(new Date());
    
17. orcTBusinessTrack.setCreateUserNum(user.get(LSCtants.USER_LOGIN_NAME));
    
18. orcTBusinessTrack.setCreateUserName(user.get(LSCtants.USER_LOGIN_NAME));
    
19. orcTBusinessTrackDao.save(orcTBusinessTrack);
    
20. }

复制代码

转自：http://bbs.ibeifeng.com/read-htm-tid-66111.html