浏览 5937 次
锁定老帖子 主题:hibernate 異常
该帖已经被评为新手帖
|
|
---|---|
作者 | 正文 |
发表时间:2007-09-04
對數據庫插入記錄時 拋出異常(hibernate 3.0): Hibernate: insert into LATENT_COMPANY (F_ID, F_NAMEC, F_SNAME, F_TNO, EXPLAIN, F_EXPLAIN, F_REPLC, CONTACT, TITLE, F_TEL, MOBILE, F_FAX, E_MAIL, F_ADDRC, F_POST, F_ADDR, F_URL, ITEM_SCRPTC, CREATE_DATE, IS_DISABLE, CREATOR, BASE_ID, F_REPPROD, PARK_ID, LEVEL_ID, F_KIND, NO_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 16:54:50,218 WARN JDBCExceptionReporter:71 - SQL Error: 1401, SQLState: 23000 16:54:50,218 ERROR JDBCExceptionReporter:72 - ORA-01401: 插入的值对于列过大 16:54:50,218 WARN JDBCExceptionReporter:71 - SQL Error: 1401, SQLState: 23000 16:54:50,218 ERROR JDBCExceptionReporter:72 - ORA-01401: 插入的值对于列过大 16:54:50,234 ERROR AbstractFlushingEventListener:300 - Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at com.cavell.frameworkx.transaction.TransactionManager.commitTransaction(TransactionManager.java:38) at com.cavell.frameworkx.action.BaseAction.execute(BaseAction.java:65) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:145) at com.cavell.frameworkx.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:165) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:145) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:139) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2460) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:119) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:955) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:157) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.BatchUpdateException: ORA-01401: 插入的值对于列过大 at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10656) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195) ... 48 more 16:54:50,234 WARN RequestProcessor:538 - Unhandled Exception thrown: class org.hibernate.exception.ConstraintViolationException LatentCompanyhbm.xml: <hibernate-mapping package="com.axtronics.pcm.bean"><class> <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" > <hibernate-mapping package="com.axtronics.pcm.bean"> <hibernate-mapping package="com.axtronics.pcm.bean"> <class name="LatentCompany" table="LATENT_COMPANY" > <meta attribute="sync-DAO">false</meta> <id name="Id" type="integer" column="NO_ID" > <generator class="sequence"> <param name="sequence">OBJECT_UNIQUE_ID</param> </generator> </id><class><id><generator class="sequence"></generator> </id><id><generator class="sequence"></generator> </id> < <property> name="FId" column="F_ID" type="string" not-null="true" length="10" /> <property> name="FNamec" column="F_NAMEC" type="string" not-null="true" length="50" /> <property> name="FSname" column="F_SNAME" type="string" not-null="true" length="20" /> <property> name="FTno" column="F_TNO" type="string" not-null="true" length="8" /> <property> name="Explain" column="EXPLAIN" type="string" not-null="false" length="50" /> <property> name="FExplain" column="F_EXPLAIN" type="string" not-null="false" length="50" /> <property> name="FReplc" column="F_REPLC" type="string" not-null="true" length="20" /> <property> name="Contact" column="CONTACT" type="string" not-null="true" length="20" /> <property> name="Title" column="TITLE" type="string" not-null="true" length="20" /> <property> name="FTel" column="F_TEL" type="string" not-null="true" length="20" /> <property> name="Mobile" column="MOBILE" type="string" not-null="false" length="20" /> <property> name="FFax" column="F_FAX" type="string" not-null="false" length="20" /> <property> name="EMail" column="E_MAIL" type="string" not-null="false" length="50" /> <property> name="FAddrc" column="F_ADDRC" type="string" not-null="true" length="100" /> <property> name="FPost" column="F_POST" type="string" not-null="true" length="10" /> <property> name="FAddr" column="F_ADDR" type="string" not-null="false" length="100" /> <property> name="FUrl" column="F_URL" type="string" not-null="false" length="100" /> <property> name="ItemScrptc" column="ITEM_SCRPTC" type="string" not-null="true" length="512" /> <property> name="CreateDate" column="CREATE_DATE" type="timestamp" not-null="true" length="23" /> <property> name="Disable" column="IS_DISABLE" type="true_false" not-null="false" length="1" /> <property> name="Creator" column="CREATOR" type="string" not-null="true" length="50" /> <many-to-one> name="Base" column="BASE_ID" class="Base" not-null="true" > </many-to-one> <many-to-one> name="FRepprod" column="F_REPPROD" class="IndustrySub" not-null="true" > </many-to-one> <many-to-one> name="Park" column="PARK_ID" class="Park" not-null="true" > </many-to-one> <many-to-one> name="Level" column="LEVEL_ID" class="CompanyLevel" not-null="true" > </many-to-one> <many-to-one> name="FKind" column="F_KIND" class="Industry" not-null="true" > </many-to-one><key column="F_ID"> java 代碼: public ActionForward save(final ActionMapping mapping, final ActionForm form, final HttpServletRequest request, final HttpServletResponse response) { LatentCompanySrv latentCompanySrv = new LatentCompanySrv(); LatentCompanyForm aform = (LatentCompanyForm)form; LatentCompany latentCompany = null; int id = 0; if (request.getParameter("id") != null) { id = Integer.parseInt(request.getParameter("id")); } if (id > 0) { latentCompany = (LatentCompany)latentCompanySrv.find(LatentCompany.class, new Integer(id)); } else { latentCompany = new LatentCompany(); } latentCompany = (LatentCompany)LatentCompanyHelp.convert2Bean(aform); String userId = request.getParameter("userId"); //waiting for request document. if (userId != null && !"".equals(userId.trim())) { latentCompany.setCreator(userId); } else latentCompany.setCreator("admin"); latentCompanySrv.saveOrUpdate(latentCompany); return mapping.findForward("add"); } public static Object convert2Bean(LatentCompanyForm aform) { LatentCompany latentCompany = new LatentCompany(); LatentCompanySrv latentCompanySrv = new LatentCompanySrv(); latentCompany.setCreateDate(new java.util.Date()); //auto create....the FId and FTno,should to modify.... latentCompany.setFTno(aform.getFtno()); latentCompany.setFId(aform.getFid()); latentCompany.setFNamec(aform.getFnamec()); latentCompany.setFSname(aform.getFsname()); latentCompany.setFReplc(aform.getFreplc()); latentCompany.setContact(aform.getContact()); latentCompany.setTitle(aform.getTitle()); latentCompany.setFTel(aform.getFtel()); latentCompany.setMobile(aform.getMobile()); latentCompany.setFFax(aform.getFfax()); latentCompany.setEMail(aform.getEmail()); latentCompany.setFAddrc(aform.getFaddrc()); latentCompany.setFAddr(aform.getFaddr()); latentCompany.setFPost(aform.getFpost()); latentCompany.setFUrl(aform.getFurl()); latentCompany.setItemScrptc(aform.getItemScrptc()); String baseId = aform.getBaseId(); String parkId = aform.getParkId(); String indId = aform.getIndId(); String subId = aform.getSubId(); String levelId = aform.getLevelId(); latentCompany.setBase((Base)latentCompanySrv.getBase(baseId)); latentCompany.setPark((Park)latentCompanySrv.getPark(parkId)); latentCompany.setFKind((</key> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </class>Industry<hibernate-mapping package="com.axtronics.pcm.bean"><class> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property><key column="F_ID">)latentCompanySrv.getIndustry(indId)); latentCompany.setFRepprod((I</key></property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </class></hibernate-mapping>ndustrySub<hibernate-mapping package="com.axtronics.pcm.bean"><class> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property> <property><key column="F_ID">)latentCompanySrv.getIndustrySub(subId)); latentCompany.setLevel((CompanyLevel)latentCompanySrv.getCompanyLevel(levelId)); return latentCompany; }</key></property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </property> </class></hibernate-mapping></hibernate-mapping></class></hibernate-mapping> 声明:ITeye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
推荐链接
|
|
返回顶楼 | |
发表时间:2007-09-12
大哥,解决没有呀?我和你的问题一样,急呀.hibernate+oracle?
2007-09-11 14:12:52 [org.hibernate.util.JDBCExceptionReporter]-[DEBUG] Could not execute JDBC batch update [insert into PLCES.TB_LOAN (CUSTOMERID, LOANBRANCH, BUYHOUSEAMOUNT, BUYHOUSEAREA, BUYHOUSEADDRESS, LOFTAREA, GARAGEAREA, BIKEAREA, MORTGAGER, ASSURER, DEPOSITPERCENT, DEPOSITAMOUNT, HOUSE1MORT, HOUSE1AMOUNT, HOUSE1AREA, HOUSE1ADDRESS, HOUSE2MORT, HOUSE2AMOUNT, HOUSE2AREA, HOUSE2ADDRESS, HOUSEARRSURER, CARNO, CARKIND, CARFACTORYKIND, CARFRAMENO, CARENGENERNO, CARAMOUNT, CARREGISTERNO, CARARRSURER, PAWN1NAME, PAWN1OWNER, PAWN1NO, PAWN1AMOUNT, PAWN2NAME, PAWN2OWNER, PAWN2NO, PAWN2AMOUNT, PAWN3NAME, PAWN3OWNER, PAWN3NO, PAWN3AMOUNT, PAWN4NAME, PAWN4OWNER, PAWN4NO, PAWN4AMOUNT, PAWN5NAME, PAWN5OWNER, PAWN5NO, PAWN5AMOUNT, NOTE1, NOTE2, NOTE3, NOTE4, NOTE5, LOANACCOUNT) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] java.sql.BatchUpdateException: ORA-01401: 插入的值对于列过大 at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:458) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java(Compiled Code)) at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcStatement.java(Compiled Code)) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java(Compiled Code)) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java(Compiled Code)) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java(Inlined Compiled Code)) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java(Inlined Compiled Code)) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java(Compiled Code)) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java(Compiled Code)) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java(Compiled Code)) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java(Compiled Code)) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java(Compiled Code)) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java(Inlined Compiled Code)) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java(Compiled Code)) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java(Inlined Compiled Code)) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java(Compiled Code)) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java(Compiled Code)) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java(Compiled Code)) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java(Compiled Code)) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java(Compiled Code)) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java(Compiled Code)) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java(Compiled Code)) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java(Compiled Code)) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java(Compiled Code)) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java(Compiled Code)) at com.zjft.plces.service.LoaninfoService$$EnhancerByCGLIB$$ab63303d.addTest(<generated>) at com.zjft.plces.web.LoaninfoController.loaninfo_add_loansubmit_detail(LoaninfoController.java:415) at sun.reflect.GeneratedMethodAccessor495.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code)) at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java(Compiled Code)) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java(Compiled Code)) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java(Compiled Code)) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java(Compiled Code)) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java(Compiled Code)) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java(Compiled Code)) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java(Compiled Code)) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java(Compiled Code)) at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code)) at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code)) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java(Compiled Code)) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code)) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code)) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code)) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code)) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code)) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code)) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code)) at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code)) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code)) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code)) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code)) at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code)) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code)) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code)) 2007-09-11 14:12:52 [org.hibernate.util.JDBCExceptionReporter]-[WARN] SQL Error: 1401, SQLState: 23000 2007-09-11 14:12:52 [org.hibernate.util.JDBCExceptionReporter]-[ERROR] ORA-01401: 插入的值对于列过大 2007-09-11 14:12:52 [org.hibernate.util.JDBCExceptionReporter]-[WARN] SQL Error: 1401, SQLState: 23000 2007-09-11 14:12:52 [org.hibernate.util.JDBCExceptionReporter]-[ERROR] ORA-01401: 插入的值对于列过大 2007-09-11 14:12:52 [org.hibernate.event.def.AbstractFlushingEventListener]-[ERROR] Could not synchronize database state with session org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java(Compiled Code)) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java(Inlined Compiled Code)) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java(Inlined Compiled Code)) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java(Compiled Code)) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java(Compiled Code)) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java(Compiled Code)) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java(Compiled Code)) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java(Compiled Code)) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java(Inlined Compiled Code)) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java(Compiled Code)) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java(Inlined Compiled Code)) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java(Compiled Code)) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java(Compiled Code)) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java(Compiled Code)) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java(Compiled Code)) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java(Compiled Code)) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java(Compiled Code)) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java(Compiled Code)) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java(Compiled Code)) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java(Compiled Code)) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java(Compiled Code)) at com.zjft.plces.service.LoaninfoService$$EnhancerByCGLIB$$ab63303d.addTest(<generated>) at com.zjft.plces.web.LoaninfoController.loaninfo_add_loansubmit_detail(LoaninfoController.java:415) at sun.reflect.GeneratedMethodAccessor495.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code)) at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java(Compiled Code)) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java(Compiled Code)) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java(Compiled Code)) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java(Compiled Code)) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java(Compiled Code)) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java(Compiled Code)) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java(Compiled Code)) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java(Compiled Code)) at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code)) at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code)) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java(Compiled Code)) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code)) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code)) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code)) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code)) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code)) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code)) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code)) at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code)) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code)) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code)) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code)) at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code)) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code)) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code)) Caused by: java.sql.BatchUpdateException: ORA-01401: 插入的值对于列过大 at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:458) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java(Compiled Code)) at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcStatement.java(Compiled Code)) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java(Compiled Code)) ... 61 more 2007-09-11 14:12:52 [org.springframework.orm.hibernate3.HibernateTransactionManager]-[DEBUG] Initiating transaction rollback after commit exception org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java(Compiled Code)) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java(Inlined Compiled Code)) at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java(Inlined Compiled Code)) at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java(Compiled Code)) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java(Compiled Code)) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java(Compiled Code)) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java(Compiled Code)) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java(Compiled Code)) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java(Inlined Compiled Code)) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java(Compiled Code)) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java(Inlined Compiled Code)) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java(Compiled Code)) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java(Compiled Code)) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java(Compiled Code)) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java(Compiled Code)) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java(Compiled Code)) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java(Compiled Code)) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java(Compiled Code)) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java(Compiled Code)) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java(Compiled Code)) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java(Compiled Code)) at com.zjft.plces.service.LoaninfoService$$EnhancerByCGLIB$$ab63303d.addTest(<generated>) at com.zjft.plces.web.LoaninfoController.loaninfo_add_loansubmit_detail(LoaninfoController.java:415) at sun.reflect.GeneratedMethodAccessor495.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code)) at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java(Compiled Code)) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java(Compiled Code)) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java(Compiled Code)) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java(Compiled Code)) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java(Compiled Code)) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java(Compiled Code)) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java(Compiled Code)) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java(Compiled Code)) at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code)) at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code)) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java(Compiled Code)) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code)) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code)) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code)) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code)) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code)) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code)) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code)) at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code)) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code)) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code)) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code)) at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code)) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code)) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code)) Caused by: java.sql.BatchUpdateException: ORA-01401: 插入的值对于列过大 at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:458) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java(Compiled Code)) at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcStatement.java(Compiled Code)) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java(Compiled Code)) ... 61 more |
|
返回顶楼 | |
发表时间:2007-09-15
16:54:50,218 ERROR JDBCExceptionReporter:72 - ORA-01401: 插入的值对于列过大
建议: 是不是你的某个属性的长度大于了在数据库中定义的长度啊? 仔细检查一下 |
|
返回顶楼 | |
发表时间:2008-01-28
应该就是长度大于了数据库定义的最大长度。
还是要细心点。 |
|
返回顶楼 | |