在软件列表中删除软件出错

错误提示：*org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update   


java.lang.Exception: org.hibernate.exception.ConstraintViolationException: Could
not execute JDBC batch update
        at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtil
s.java:131)
        at cn.myapps.base.ejb.AbstractDesignTimeProcessBean.doRemove(AbstractDes
ignTimeProcessBean.java:150)
        at cn.myapps.core.deploy.module.ejb.ModuleProcessBean.doRemove(ModulePro
cessBean.java:72)
        at cn.myapps.core.deploy.module.ejb.ModuleProcessBean$$EnhancerByCGLIB$$
8615d2c3.CGLIB$doRemove$1(<generated>)
        at cn.myapps.core.deploy.module.ejb.ModuleProcessBean$$EnhancerByCGLIB$$
8615d2c3$$FastClassByCGLIB$$9d8c05e1.invoke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
        at cn.myapps.protection.util.WarpProcessFactory.intercept(WarpProcessFac
tory.java:272)
        at cn.myapps.core.deploy.module.ejb.ModuleProcessBean$$EnhancerByCGLIB$$
8615d2c3.doRemove(<generated>)
        at cn.myapps.core.deploy.module.action.ModuleHelper.deleteModule(ModuleH
elper.java:54)
        at cn.myapps.core.deploy.module.action.ModuleHelper.deleteModuleWithSub(
ModuleHelper.java:32)
        at cn.myapps.core.deploy.application.action.ApplicationAction.doDelete(A
pplicationAction.java:204)
        at sun.reflect.GeneratedMethodAccessor654.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultAc
tionInvocation.java:365)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(Defau
ltActionInvocation.java:217)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:191)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
        at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
        at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.
java:113)
        at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dis
patcherUtils.java:233)
        at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterD
ispatcher.java:198)
        at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDis
patcher.java:43)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Act
ionContextCleanUp.java:78)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiL
anguageFilter.java:42)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilte
r.java:30)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java
:155)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at cn.myapps.base.web.filter.EncodingFilter.doFilter(EncodingFilter.java
:27)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:263)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:852)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:584)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:15
08)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execu
te JDBC batch update
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:71)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
249)
        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)

        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:144)

        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:298)
        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
:106)
        at cn.myapps.base.dao.HibernateBaseDAO.commitTransaction(HibernateBaseDA
O.java:755)
        at cn.myapps.base.dao.PersistenceUtils.commitTransaction(PersistenceUtil
s.java:129)
        ... 51 more
Caused by: java.sql.BatchUpdateException: Cannot delete or update a parent row:
a foreign key constraint fails (`obpm`.`t_dynaform_form`, CONSTRAINT `FKCCE42AAC
9CE9DE9F` FOREIGN KEY (`MODULE`) REFERENCES `t_module` (`ID`))
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
nt.java:2016)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
1452)
        at sun.reflect.GeneratedMethodAccessor294.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:
100)
        at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.ja
va:57)
        at $java.sql.PreparedStatement$$EnhancerByProxool$$8d275790.executeBatch
(<generated>)
        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
a:48)
        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
242)
        ... 60 more

您好，我这边跟同事沟通之后，由于我们的软件在保存之后，就会在数据库的系统库以及业务库中生成数据并形成主外键关系，所以我们的软件是不可以删除的哦。
给您带来不便，敬请见谅！

为了您的问题能够及时跟进与解决，方便的话，请提供您的联系方式（QQ或电话）以便我们为您提供更好的服务

您好，站在用户的角度，该错误提示信息确实很不友好，以及考虑到确实会在需要删除软件的情况。目前已将该问题，作为新需求提交至研发那边。带来不便，敬请见谅。

研发部门 反馈的结果：该问题会在sp7版本中实现。