主题 : 数据问题 |
级别: 秀才
|
1# 发表于:2014-05-12 16:50:31 IP:27.128.*.*
|
||||
---|---|---|---|---|---|
级别: 秀才
|
3# 发表于:2014-05-12 16:54:02 IP:27.128.*.*
回复第2楼
|
||
---|---|---|---|
级别: 秀才
|
4# 发表于:2014-05-12 16:55:53 IP:27.128.*.*
回复第2楼
我是新插入数据 但是不知道为什么会报update 错误,有几次也回报insert 错误和图片类似。是我数据库语句插入的时候关联没写好么? |
||
---|---|---|---|
级别: 秀才
|
5# 发表于:2014-05-12 16:56:32 IP:27.128.*.*
HTTP Status 500 - Request processing failed; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
type Exception report message Request processing failed; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update description The server encountered an internal error that prevented it from fulfilling this request. exception org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:656) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) javax.servlet.http.HttpServlet.service(HttpServlet.java:647) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:35) root cause org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114) org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244) org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2242) org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678) org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79) org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64) org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:997) org.hibernate.impl.SessionImpl.list(SessionImpl.java:1142) org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835) com.jeecms.cms.dao.main.impl.ContentTagDaoImpl.findByName(ContentTagDaoImpl.java:49) com.jeecms.cms.manager.main.impl.ContentTagMngImpl.findByName(ContentTagMngImpl.java:52) com.jeecms.cms.manager.main.impl.ContentTagMngImpl.saveTag(ContentTagMngImpl.java:89) com.jeecms.cms.manager.main.impl.ContentTagMngImpl.saveTags(ContentTagMngImpl.java:79) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) $Proxy33.saveTags(Unknown Source) com.jeecms.cms.manager.main.impl.ContentMngImpl.save(ContentMngImpl.java:253) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) $Proxy29.save(Unknown Source) com.jeecms.cms.action.admin.main.ContentAct.save(ContentAct.java:448) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) javax.servlet.http.HttpServlet.service(HttpServlet.java:647) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:35) root cause java.sql.BatchUpdateException: ORA-00001: 违反唯一约束条件 (DYCMS.PK_JC_CONTENT) oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343) oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10768) com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114) org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244) org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2242) org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2678) org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79) org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64) org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:997) org.hibernate.impl.SessionImpl.list(SessionImpl.java:1142) org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835) com.jeecms.cms.dao.main.impl.ContentTagDaoImpl.findByName(ContentTagDaoImpl.java:49) com.jeecms.cms.manager.main.impl.ContentTagMngImpl.findByName(ContentTagMngImpl.java:52) com.jeecms.cms.manager.main.impl.ContentTagMngImpl.saveTag(ContentTagMngImpl.java:89) com.jeecms.cms.manager.main.impl.ContentTagMngImpl.saveTags(ContentTagMngImpl.java:79) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) $Proxy33.saveTags(Unknown Source) com.jeecms.cms.manager.main.impl.ContentMngImpl.save(ContentMngImpl.java:253) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) $Proxy29.save(Unknown Source) com.jeecms.cms.action.admin.main.ContentAct.save(ContentAct.java:448) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426) org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) javax.servlet.http.HttpServlet.service(HttpServlet.java:647) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) com.jeecms.common.web.ProcessTimeFilter.doFilter(ProcessTimeFilter.java:35) note The full stack trace of the root cause is available in the Apache Tomcat/7.0.47 logs. |
||
---|---|---|---|
级别: 状元
|
6# 发表于:2014-05-12 16:59:31 IP:182.212.*.*
java.sql.BatchUpdateException: ORA-00001: 违反唯一约束条件 (DYCMS.PK_JC_CONTENT你是不是没设置栏目id的自动增长列?
|
||
---|---|---|---|
级别: 秀才
|
7# 发表于:2014-05-12 17:01:30 IP:27.128.*.*
回复第6楼
自动增长列 是哪个表里的?怎么设置? |
||
---|---|---|---|
级别: 秀才
|
9# 发表于:2014-05-12 17:12:45 IP:27.128.*.*
回复第8楼
我用的ORCALE 没用自动增长吧? |
||
---|---|---|---|
级别: 状元
|
10# 发表于:2014-05-12 17:15:05 IP:182.212.*.*
oracle也有序列,你数据库是怎么导入的?为什么会有添加会违反唯一约束呢?
|
||
---|---|---|---|