论坛首页 入门技术论坛

hibernate 異常

浏览 5937 次
该帖已经被评为新手帖
作者 正文
   发表时间:2007-09-04  
Hibernate 拋出異常為:
對數據庫插入記錄時 拋出異常(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>
   发表时间: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
0 请登录后投票
   发表时间:2007-09-15  
16:54:50,218 ERROR JDBCExceptionReporter:72 - ORA-01401: 插入的值对于列过大

建议:

是不是你的某个属性的长度大于了在数据库中定义的长度啊?

仔细检查一下

0 请登录后投票
   发表时间:2008-01-28  
应该就是长度大于了数据库定义的最大长度。
还是要细心点。
0 请登录后投票
论坛首页 入门技术版

跳转论坛:
Global site tag (gtag.js) - Google Analytics