异常:
com.windtec.dao.DataAccessLayerException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at com.windtec.dao.AbstractDao.handleException(AbstractDao.java:116)
at com.windtec.dao.AbstractDao.saveOrUpdate(AbstractDao.java:54)
at com.windtec.dao.UaAuditGroupDao.create(UaAuditGroupDao.java:20)
at com.windtec.bc.AuditToolsAirlineBC.insertAuditGroup(AuditToolsAirlineBC.java:117)
at com.windtec.xml.XmltoPo.toGroup(XmltoPo.java:579)
at com.windtec.xml.XmlParse.parse(XmlParse.java:311)
at com.windtec.ui.NewClientsTools$5.widgetSelected(NewClientsTools.java:456)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at com.windtec.ui.NewClientsTools.open(NewClientsTools.java:282)
at com.windtec.ui.MyToolsLogin$3.widgetSelected(MyToolsLogin.java:227)
at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
at com.windtec.ui.MyToolsLogin.open(MyToolsLogin.java:85)
at com.windtec.ui.MyToolsLogin.run(MyToolsLogin.java:70)
at com.windtec.tools.clients.MyClientToolsLoginMain.main(MyClientToolsLoginMain.java:19)
Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.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:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.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 com.windtec.dao.AbstractDao.saveOrUpdate(AbstractDao.java:51)
... 20 more
Caused by: java.sql.BatchUpdateException: failed batch
at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
... 28 more
配置文件:
<class name="com.windtec.basedata.UaAuditGroup" schema="HANGAN" table="UA_AUDIT_GROUP">
<id column="UAAUDITGROUPPK" name="pk" type="java.lang.Long">
   
</id>
<property column="AUDITGROUPTYPE" length="20" name="auditGroupType" type="java.lang.Long"/>
<property column="AUDITPERSONALPOSITION" length="50" name="auditPersonalPosition" type="java.lang.String"/>
<property column="AUDITPERSONALPK" length="20" name="auditPersonalpk" type="java.lang.Long"/>
<property column="AUDITPERSONALNAME" length="50" name="auditPersonalName" type="java.lang.String"/>
<property column="DELETED" length="1" name="deleted" not-null="true" type="java.lang.String"/>
<property column="TRANSFERFLAG" length="1" name="transferflag" not-null="true" type="java.lang.String"/>
<property column="CREATETIME" length="7" name="createtime" not-null="true" type="java.util.Date"/>
<property column="UPDATETIME" length="7" name="updatetime" not-null="true" type="java.util.Date"/>
<property column="OPERATEDEPT" length="20" name="operatedept" not-null="true" type="java.lang.Long"/>
<property column="OPERATOR" length="20" name="operator" not-null="true" type="java.lang.Long"/>
<property column="EXPORTSTATUS" length="1" name="exportstatus" not-null="true" type="java.lang.String"/>
<property column="AUDITACTIVITYPK" name="auditactivitypk" not-null="true" type="java.lang.Long"/>
</class>