新建用户出错

新建用户不成功，后台报告这样的异常，请帮忙解决

1. Hibernate: insert into T_USER (CALENDAR, LEVELS, REMARKS, SUPERIOR, PROXYUSER, DEFAULTDEPARTMENT, DEFAULTAPPLICATION, EMAIL, LOGINNO, LOGINPWD, NAME, TELEPHONE, STATUS, DOMAINID, FIELD1, FIELD2, FIELD3, FIELD4, FIELD5, FIELD6, FIELD7, FIELD8, FIELD9, FIELD10, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
   
2. Hibernate: insert into T_USER_DEPARTMENT_SET (DEPARTMENTID, USERID, ID) values (?, ?, ?)
   
3. 14:00:20,953  WARN JDBCExceptionReporter:77 - SQL Error: 547, SQLState: 23000
   
4. 14:00:20,953 ERROR JDBCExceptionReporter:78 - INSERT 语句与 FOREIGN KEY 约束"FKE184DC5EF336993C"冲突。该冲突发生于数据库"vos2_4"，表"dbo.T_USER", column 'ID'。
   
5. 14:00:20,968 ERROR AbstractFlushingEventListener:301 - Could not synchronize database state with session
   
6. org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
   
7.         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
   
8.         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   
9.         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
   
10.         at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
    
11.         at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
    
12.         at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
    
13.         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2220)
    
14.         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656)
    
15.         at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)
    
16.         at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
    
17.         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
    
18.         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
    
19.         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
    
20.         at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
    
21.         at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
    
22.         at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
    
23.         at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
    
24.         at cn.myapps.base.dao.HibernateBaseDAO.commitTransaction(HibernateBaseDAO.java:760)
    
25.         at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtils.java:127)
    
26.         at cn.myapps.core.user.ejb.UserProcessBean.doCreate(UserProcessBean.java:74)
    
27.         at cn.myapps.core.user.ejb.UserProcessBean$$EnhancerByCGLIB$$c2dad207.CGLIB$doCreate$8(<generated>)
    
28.         at cn.myapps.core.user.ejb.UserProcessBean$$EnhancerByCGLIB$$c2dad207$$FastClassByCGLIB$$81f78765.invoke(<generated>)
    
29.         at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
    
30.         at cn.myapps.util.ProcessFactory.intercept(ProcessFactory.java:138)
    
31.         at cn.myapps.core.user.ejb.UserProcessBean$$EnhancerByCGLIB$$c2dad207.doCreate(<generated>)
    
32.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
33.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    
34.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    
35.         at java.lang.reflect.Method.invoke(Method.java:589)
    
36.         at com.jamonapi.proxy.MonProxy.invoke(MonProxy.java:110)
    
37.         at $Proxy18.doCreate(Unknown Source)
    
38.         at cn.myapps.core.user.action.UserAction.doSave(UserAction.java:252)
    
39.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
40.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    
41.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    
42.         at java.lang.reflect.Method.invoke(Method.java:589)
    
43.         at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:365)
    
44. 
    
45. 
    
46.         at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDispatcher.java:43)
    
47.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
48.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
49.         at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:78)
    
50.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
51.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
52.         at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiLanguageFilter.java:40)
    
53.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
54.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
55.         at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilter.java:30)
    
56.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
57.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
58.         at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java:125)
    
59. 
    
60. 
    
61.         at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
    
62.         at java.lang.Thread.run(Thread.java:619)
    
63. Caused by: java.sql.BatchUpdateException: INSERT 语句与 FOREIGN KEY 约束"FKE184DC5EF336993C"冲突。该冲突发生于数据库"vos2_4"，表"dbo.T_USER", column 'ID'。
    
64.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:944)
    
65.         at sun.reflect.GeneratedMethodAccessor879.invoke(Unknown Source)
    
66.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    
67.         at java.lang.reflect.Method.invoke(Method.java:589)
    
68.         at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
    
69.         at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
    
70.         at $java.sql.PreparedStatement$$EnhancerByProxool$$ce065e28.executeBatch(<generated>)
    
71.         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
    
72.         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
    
73.         ... 84 more
    
74. java.lang.Exception: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
    
75.         at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtils.java:129)
    
76.         at cn.myapps.core.user.ejb.UserProcessBean.doCreate(UserProcessBean.java:74)
    
77.         at cn.myapps.core.user.ejb.UserProcessBean$$EnhancerByCGLIB$$c2dad207.CGLIB$doCreate$8(<generated>)
    
78.         at cn.myapps.core.user.ejb.UserProcessBean$$EnhancerByCGLIB$$c2dad207$$FastClassByCGLIB$$81f78765.invoke(<generated>)
    
79.         at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
    
80.         at cn.myapps.util.ProcessFactory.intercept(ProcessFactory.java:138)
    
81.         at cn.myapps.core.user.ejb.UserProcessBean$$EnhancerByCGLIB$$c2dad207.doCreate(<generated>)
    
82.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
83.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    
84.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    
85.         at java.lang.reflect.Method.invoke(Method.java:589)
    
86.         at com.jamonapi.proxy.MonProxy.invoke(MonProxy.java:110)
    
87.         at $Proxy18.doCreate(Unknown Source)
    
88.         at cn.myapps.core.user.action.UserAction.doSave(UserAction.java:252)
    
89.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
90.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    
91.                 ......
    
92.         at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:233)
    
93.         at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:198)
    
94.         at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDispatcher.java:43)
    
95.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
96.         at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilter.java:30)
    
97.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    
98.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
99.         at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java:125)
    
100.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
     
101. 
     
102. Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
     
103.         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
     
104.         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
     
105.         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2220)
     
106.         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656)
     
107.         at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)
     
108.         at cn.myapps.base.dao.HibernateBaseDAO.commitTransaction(HibernateBaseDAO.java:760)
     
109.         at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtils.java:127)
     
110.         ... 68 more
     
111. Caused by: java.sql.BatchUpdateException: INSERT 语句与 FOREIGN KEY 约束"FKE184DC5EF336993C"冲突。该冲突发生于数据库"vos2_4"，表"dbo.T_USER", column 'ID'。
     
112.         at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:944)
     
113.         at sun.reflect.GeneratedMethodAccessor879.invoke(Unknown Source)
     
114.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     
115.         at java.lang.reflect.Method.invoke(Method.java:589)
     
116.         at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
     
117.         at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
     
118.         at $java.sql.PreparedStatement$$EnhancerByProxool$$ce065e28.executeBatch(<generated>)
     
119.         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
     
120.         ... 84 more

复制代码

回复 2# cathy


    当保存并新建一个用户时，出现这样的异常。

   数据库用mssql ，平台用2.4版本的平台。

   另外，我的T_user表中目前只有11条记录。 t_user_department_set表中有多达33条记录，表t_user_department_set中userid为空的记录是否可以用sql语句删除而不会对系统造成影响？？？

   

回复 4# cathy


    那保存并新建出现的异常，，，怎么解决呀？

回复 6# cathy


    保存并新建后，添加用户到系统中，再次点击保存时，后台提示楼上的异常，前台提示“保存成功”，查找用户表刚才建立的用户不存在。。。

回复 8# cathy


    我晕。。

   这个问题是你们平台存在的问题呀，，
   截图的这个地方出错
   

   查找了一些资料。。

   http://zhidao.baidu.com/question/38915173.html
     http://hi.baidu.com/lalalove_yay ... bcb9c9a044dfe8.html

    应该是主外键存在关联，而hibernate在新增数据时，先插入了t_user_department_set表数据，再插入了t_user数据？

   或者代码中写的插入代码不符合hibernate规范？

回复 10# cathy


    我晕。。。没有插入数据呀？
   一条sql语句都没有用呀。。


   直接在平台后台操作的呀。。。。

   找了好久还是没有解决问题的。。

回复 12# cathy


   是的呀，，，gg