Confluence 2.7 Temp Archive : Troubleshooting SQL Exceptions
This page last changed on Dec 02, 2007 by smaddox.
If you get an exception similar to one of the following: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: Duplicate entry '1234' for key 1 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:88) caused by: java.sql.BatchUpdateException: Duplicate entry '1234' for key 1 at com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:647) or (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.BatchUpdateException: ORA-00001: unique constraint (CONFLUENCE.SYS_C0012345) violated This document will outline the steps to take to increasing logging on your system. This additional logging will help us work out the cause of this error. To enable this additional logging:
Related topicEnable Hibernate Logging |
![]() |
Document generated by Confluence on Dec 20, 2007 19:02 |