插入100条 每次都是奇数条成功 偶数条抛这个异常 每次只能插入50条 求高手帮忙
Hibernate: insert into H_SAM_SAMPLE (SAMPLE_TYPE_ID, AREA_ID, SAMPLE_NUM, OLD_SAMPLE_NUM, ORDER_ID, SHOW_NAME, IS_MANY, MANY_ID, IS_GET, CHECK_SITE, INT_NO, INT_TOTAL, INT_DATE, STORE_RACK, STORE_BOX, PER_CODE, DIRECTION, IS_CHECKED, CUSTOMER_CODE, MEMO, SOURCE, PROJECT_ID, PERSON_NAME, PERSON_SEX, PERSON_NATION, PERSON_AGE, PERSON_POST, IS_HANG_SAMPLE, PERSON_ADDRESS, PERSON_TEL, CUSTOM_ID, ACCEPT_SAMPLE_TIME, SAMPLE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into NEWHEALTH_TEST_2.H_SAMPLE_BOARD_INFO (POSITION_POINT, SAMPLE_NUM, BOARD_NAME, CREAT_DATE, flag, ID) values (?, ?, ?, ?, ?, ?)
2012-6-4 15:29:18 org.hibernate.util.JDBCExceptionReporter logExceptions
警告: SQL Error: 1031, SQLState: 42000
2012-6-4 15:29:18 org.hibernate.util.JDBCExceptionReporter logExceptions
严重: ORA-01031: insufficient privileges
2012-6-4 15:29:18 org.hibernate.util.JDBCExceptionReporter logExceptions
警告: SQL Error: 1031, SQLState: 42000
2012-6-4 15:29:18 org.hibernate.util.JDBCExceptionReporter logExceptions
严重: ORA-01031: insufficient privileges
2012-6-4 15:29:18 org.hibernate.event.def.AbstractFlushingEventListener performExecutions
严重: Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1141)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.achievo.query.HibernateListTemplate$ListHibernateCallback.doInHibernate(HibernateListTemplate.java:155)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:387)
at org.achievo.query.HibernateListTemplate.find(HibernateListTemplate.java:83)
at org.achievo.dao.BaseDaoByHB.query(BaseDaoByHB.java:168)
at org.achievo.platform.bean.BaseBean.query(BaseBean.java:137)
at cn.org.genomics.health.solexa.prenatal.bloodTask.dao.impl.hb.SamSampleDao.findSampleByCode(SamSampleDao.java:55)
at cn.org.genomics.health.project.service.impl.SynchronizationSampleService.saveSynchronizationSample(SynchronizationSampleService.java:271)
at cn.org.genomics.health.project.service.impl.SynchronizationSampleService.saveSynchronizationSample(SynchronizationSampleService.java:226)
at cn.org.genomics.health.project.service.impl.SynchronizationSampleService$$FastClassByCGLIB$$e713d9cf.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at cn.org.genomics.health.project.service.impl.SynchronizationSampleService$$EnhancerByCGLIB$$5edcbff2.saveSynchronizationSample(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy50.saveSynchronizationSample(Unknown Source)
at cn.org.genomics.system.remote.operTransferService.RemoteTransferService.saveSynchronizationSample(RemoteTransferService.java:108)
at cn.org.genomics.system.remote.operTransferService.RemoteTransferService$$FastClassByCGLIB$$11416413.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
at at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java:109)
at org.springframework.remoting.caucho.Hessian2SkeletonInvoker.invoke(Hessian2SkeletonInvoker.java:94)
at org.springframework.remoting.caucho.HessianExporter.invoke(HessianExporter.java:142)
at cn.org.genomics.system.remote.ServiceExporter.handleRequest(ServiceExporter.java:29)
at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)