It's probably related to the following issue: http://issues.appfuse.org/browse/APF-689
Suggested workaround: Set your hibernate_sequence to a high enough value so that future insertions do not produce unique key constraint violations. For instance, if your highest key value in any of your tables is 182974, then the following statement would work for you - SQL> alter sequence hibernate_sequence increment by 182975 minvalue 0; Matt On 8/29/07, fadhli <[EMAIL PROTECTED]> wrote: > Hello, > > I'm using Appfuse 2m5 Spring MVC Basic. I done testing on MySQL and > everything went ok. > > But when I switched to Oracle, an error happened. The following is the error > stack trace. Any ideas anyone? Matt? > > Running com.dnt.dao.UserDaoTest > WARN - LoadContexts.cleanup(108) | fail-safe cleanup (collections) : > org.hibernate.engine.loading.CollectionLoadContext@ > 1611aec<[EMAIL PROTECTED] > > WARN - JDBCExceptionReporter.logExceptions(77) | SQL Error: > 1, SQLState: 23000 > ERROR - JDBCExceptionReporter.logExceptions(78) | > ORA-00001: unique constraint (ESDB.SYS_C007348) violated > > WARN - JDBCExceptionReporter.logExceptions (77) | SQL > Error: 1, SQLState: 23000 > ERROR - JDBCExceptionReporter.logExceptions(78) | > ORA-00001: unique constraint (ESDB.SYS_C007348) violated > > ERROR - > AbstractFlushingEventListener.performExecutions(301) | > Could not synchronize database state with session > org.hibernate.exception.ConstraintViolationException: Could > not execute JDBC batch update > at > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) > at > org.hibernate.exception.JDBCExceptionHelper.convert > (JDBCExceptionHelper.java:43) > at > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253) > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237) > at org.hibernate.engine.ActionQueue.executeActions > (ActionQueue.java:141) > at > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:29 > 8) > at > org.hibernate.event.def.DefaultFlushEventListener.onFlush > (DefaultFlushEventListener.java:27) > at > org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) > at > org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390) > at > org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373) > at > org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:686) > at > com.dnt.dao.hibernate.UserDaoHibernate.saveUser(UserDaoHibernate.java:36) > at > com.dnt.dao.UserDaoTest.testUpdateUser(UserDaoTest.java:62) > at > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke (Method.java:585) > at > junit.framework.TestCase.runTest(TestCase.java:164) > at > junit.framework.TestCase.runBare(TestCase.java:130) > at > org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCase.java > :69) > at > junit.framework.TestResult$1.protect(TestResult.java:106) > at > junit.framework.TestResult.runProtected(TestResult.java:124) > at junit.framework.TestResult.run(TestResult.java:109) > > > > -- > /fadhli -- http://raibledesigns.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
