org.hibernate.exception.ConstraintViolationException: could not insert: [org.jboss.seam.wiki.core.model.WikiDocument]

Hibernate JIRA | Pete Muir | 8 years ago
  1. 0

    This problem is apparent in the Seam wiki testsuite when run with Java6. The wiki runs Hibernate 3.2.3 by default, but Shane tested with 3.3.1 and the same problem manifests. Currently the tests aren't run with Java6, so to reproduce in Seam trunk, you need to enable the tests by editing examples/wiki/AllTests-jdk6.tng.xml and removing the excluded groups. [testng] org.hibernate.exception.ConstraintViolationException: could not insert: [org.jboss.seam.wiki.core.model.WikiDocument] [testng] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) [testng] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) [testng] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267) [testng] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660) [testng] at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52) [testng] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) [testng] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) [testng] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139) [testng] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) [testng] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) [testng] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) [testng] at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:297) [testng] at org.jboss.seam.persistence.EntityManagerProxy.flush(EntityManagerProxy.java:92) [testng] at org.hibernate.search.jpa.impl.FullTextEntityManagerImpl.flush(FullTextEntityManagerImpl.java:102) [testng] at org.jboss.seam.persistence.EntityManagerProxy.flush(EntityManagerProxy.java:92) [testng] at org.jboss.seam.framework.EntityHome.persist(EntityHome.java:85) [testng] at org.jboss.seam.wiki.core.action.NodeHome.persist(NodeHome.java:243) [testng] at org.jboss.seam.wiki.core.action.DocumentHome.persist(DocumentHome.java:195) [testng] at org.jboss.seam.wiki.plugin.forum.TopicHome.persist(TopicHome.java:92) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [testng] at java.lang.reflect.Method.invoke(Method.java:597) [testng] at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) [testng] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) [testng] at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.core.ConversationInterceptor.aroundInvoke(ConversationInterceptor.java:65) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:40) [testng] at org.jboss.seam.util.Work.workInTransaction(Work.java:47) [testng] at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:34) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.security.SecurityInterceptor.aroundInvoke(SecurityInterceptor.java:138) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) [testng] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166) [testng] at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102) [testng] at org.jboss.seam.wiki.plugin.forum.TopicHome_$$_javassist_54.persist(TopicHome_$$_javassist_54.java) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [testng] at java.lang.reflect.Method.invoke(Method.java:597) [testng] at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329) [testng] at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342) [testng] at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58) [testng] at org.jboss.el.parser.AstValue.invoke(AstValue.java:96) [testng] at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request.invokeMethod(AbstractSeamTest.java:464) [testng] at org.jboss.seam.wiki.test.plugin.TopicHomeTests$2.invokeApplication(TopicHomeTests.java:69) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request.invokeApplicationPhase(AbstractSeamTest.java:647) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request.emulateJsfLifecycle(AbstractSeamTest.java:596) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request.access$300(AbstractSeamTest.java:178) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request$2.doFilter(AbstractSeamTest.java:498) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83) [testng] at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:38) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164) [testng] at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141) [testng] at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90) [testng] at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406) [testng] at org.jboss.seam.wiki.core.ui.WikiUrlRewriteFilter.doFilter(WikiUrlRewriteFilter.java:45) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:150) [testng] at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:267) [testng] at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:379) [testng] at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:506) [testng] at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.jboss.seam.wiki.core.ui.WikiUrlSessionIdFilter.doFilter(WikiUrlSessionIdFilter.java:86) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request.run(AbstractSeamTest.java:492) [testng] at org.jboss.seam.mock.AbstractSeamTest$FacesRequest.run(AbstractSeamTest.java:863) [testng] at org.jboss.seam.wiki.test.plugin.TopicHomeTests.newTopic(TopicHomeTests.java:50) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [testng] at java.lang.reflect.Method.invoke(Method.java:597) [testng] at org.testng.internal.MethodHelper.invokeMethod(MethodHelper.java:604) [testng] at org.testng.internal.Invoker.invokeMethod(Invoker.java:470) [testng] at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:564) [testng] at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:830) [testng] at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125) [testng] at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109) [testng] at org.testng.TestRunner.runWorkers(TestRunner.java:678) [testng] at org.testng.TestRunner.privateRun(TestRunner.java:624) [testng] at org.testng.TestRunner.run(TestRunner.java:495) [testng] at org.testng.SuiteRunner.runTest(SuiteRunner.java:300) [testng] at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:295) [testng] at org.testng.SuiteRunner.privateRun(SuiteRunner.java:275) [testng] at org.testng.SuiteRunner.run(SuiteRunner.java:190) [testng] at org.testng.TestNG.createAndRunSuiteRunners(TestNG.java:792) [testng] at org.testng.TestNG.runSuitesLocally(TestNG.java:765) [testng] at org.testng.TestNG.run(TestNG.java:699) [testng] at org.testng.TestNG.privateMain(TestNG.java:824) [testng] at org.testng.TestNG.main(TestNG.java:802) [testng] Caused by: java.sql.SQLException: Violation of unique constraint SYS_PK_103: duplicate value(s) for column(s) $$ in statement [/* insert org.jboss.seam.wiki.core.model.WikiDocument */ insert into WIKI_NODE (AREA_NR, CREATED_BY_USER_ID, CREATED_ON, LAST_MODIFIED_BY_USER_ID, LAST_MODIFIED_ON, MESSAGE_ID, NAME, PARENT_NODE_ID, RATING, READ_ACCESS_LEVEL, OBJ_VERSION, WIKINAME, WRITE_ACCESS_LEVEL, WRITE_PROTECTED, NODE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [testng] at org.hsqldb.jdbc.Util.throwError(Unknown Source) [testng] at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) [testng] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:250) [testng] at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23) [testng] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247) [testng] ... 105 more

    Hibernate JIRA | 8 years ago | Pete Muir
    org.hibernate.exception.ConstraintViolationException: could not insert: [org.jboss.seam.wiki.core.model.WikiDocument]
  2. 0

    This problem is apparent in the Seam wiki testsuite when run with Java6. The wiki runs Hibernate 3.2.3 by default, but Shane tested with 3.3.1 and the same problem manifests. Currently the tests aren't run with Java6, so to reproduce in Seam trunk, you need to enable the tests by editing examples/wiki/AllTests-jdk6.tng.xml and removing the excluded groups. [testng] org.hibernate.exception.ConstraintViolationException: could not insert: [org.jboss.seam.wiki.core.model.WikiDocument] [testng] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) [testng] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) [testng] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267) [testng] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660) [testng] at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52) [testng] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) [testng] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) [testng] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139) [testng] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) [testng] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) [testng] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) [testng] at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:297) [testng] at org.jboss.seam.persistence.EntityManagerProxy.flush(EntityManagerProxy.java:92) [testng] at org.hibernate.search.jpa.impl.FullTextEntityManagerImpl.flush(FullTextEntityManagerImpl.java:102) [testng] at org.jboss.seam.persistence.EntityManagerProxy.flush(EntityManagerProxy.java:92) [testng] at org.jboss.seam.framework.EntityHome.persist(EntityHome.java:85) [testng] at org.jboss.seam.wiki.core.action.NodeHome.persist(NodeHome.java:243) [testng] at org.jboss.seam.wiki.core.action.DocumentHome.persist(DocumentHome.java:195) [testng] at org.jboss.seam.wiki.plugin.forum.TopicHome.persist(TopicHome.java:92) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [testng] at java.lang.reflect.Method.invoke(Method.java:597) [testng] at org.jboss.seam.util.Reflections.invoke(Reflections.java:22) [testng] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) [testng] at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.core.ConversationInterceptor.aroundInvoke(ConversationInterceptor.java:65) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:40) [testng] at org.jboss.seam.util.Work.workInTransaction(Work.java:47) [testng] at org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:34) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.security.SecurityInterceptor.aroundInvoke(SecurityInterceptor.java:138) [testng] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) [testng] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) [testng] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166) [testng] at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102) [testng] at org.jboss.seam.wiki.plugin.forum.TopicHome_$$_javassist_54.persist(TopicHome_$$_javassist_54.java) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [testng] at java.lang.reflect.Method.invoke(Method.java:597) [testng] at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329) [testng] at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342) [testng] at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58) [testng] at org.jboss.el.parser.AstValue.invoke(AstValue.java:96) [testng] at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request.invokeMethod(AbstractSeamTest.java:464) [testng] at org.jboss.seam.wiki.test.plugin.TopicHomeTests$2.invokeApplication(TopicHomeTests.java:69) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request.invokeApplicationPhase(AbstractSeamTest.java:647) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request.emulateJsfLifecycle(AbstractSeamTest.java:596) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request.access$300(AbstractSeamTest.java:178) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request$2.doFilter(AbstractSeamTest.java:498) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83) [testng] at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:38) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164) [testng] at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141) [testng] at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90) [testng] at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406) [testng] at org.jboss.seam.wiki.core.ui.WikiUrlRewriteFilter.doFilter(WikiUrlRewriteFilter.java:45) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:150) [testng] at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:267) [testng] at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:379) [testng] at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:506) [testng] at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.jboss.seam.wiki.core.ui.WikiUrlSessionIdFilter.doFilter(WikiUrlSessionIdFilter.java:86) [testng] at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69) [testng] at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158) [testng] at org.jboss.seam.mock.AbstractSeamTest$Request.run(AbstractSeamTest.java:492) [testng] at org.jboss.seam.mock.AbstractSeamTest$FacesRequest.run(AbstractSeamTest.java:863) [testng] at org.jboss.seam.wiki.test.plugin.TopicHomeTests.newTopic(TopicHomeTests.java:50) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [testng] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [testng] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [testng] at java.lang.reflect.Method.invoke(Method.java:597) [testng] at org.testng.internal.MethodHelper.invokeMethod(MethodHelper.java:604) [testng] at org.testng.internal.Invoker.invokeMethod(Invoker.java:470) [testng] at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:564) [testng] at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:830) [testng] at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125) [testng] at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109) [testng] at org.testng.TestRunner.runWorkers(TestRunner.java:678) [testng] at org.testng.TestRunner.privateRun(TestRunner.java:624) [testng] at org.testng.TestRunner.run(TestRunner.java:495) [testng] at org.testng.SuiteRunner.runTest(SuiteRunner.java:300) [testng] at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:295) [testng] at org.testng.SuiteRunner.privateRun(SuiteRunner.java:275) [testng] at org.testng.SuiteRunner.run(SuiteRunner.java:190) [testng] at org.testng.TestNG.createAndRunSuiteRunners(TestNG.java:792) [testng] at org.testng.TestNG.runSuitesLocally(TestNG.java:765) [testng] at org.testng.TestNG.run(TestNG.java:699) [testng] at org.testng.TestNG.privateMain(TestNG.java:824) [testng] at org.testng.TestNG.main(TestNG.java:802) [testng] Caused by: java.sql.SQLException: Violation of unique constraint SYS_PK_103: duplicate value(s) for column(s) $$ in statement [/* insert org.jboss.seam.wiki.core.model.WikiDocument */ insert into WIKI_NODE (AREA_NR, CREATED_BY_USER_ID, CREATED_ON, LAST_MODIFIED_BY_USER_ID, LAST_MODIFIED_ON, MESSAGE_ID, NAME, PARENT_NODE_ID, RATING, READ_ACCESS_LEVEL, OBJ_VERSION, WIKINAME, WRITE_ACCESS_LEVEL, WRITE_PROTECTED, NODE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [testng] at org.hsqldb.jdbc.Util.throwError(Unknown Source) [testng] at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source) [testng] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:250) [testng] at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23) [testng] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247) [testng] ... 105 more

    Hibernate JIRA | 8 years ago | Pete Muir
    org.hibernate.exception.ConstraintViolationException: could not insert: [org.jboss.seam.wiki.core.model.WikiDocument]
  3. 0

    UnrecognizedProfileTableNameException - when creating generic Address Profile Table instance - 2.1.2.FINAL

    Google Groups | 6 years ago | Tomasz Zieleniewski
    org.hibernate.exception.ConstraintViolationException: could not insert: [org.mobicents.slee.container.deployment.profile.jpa.JPAProfileTable]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]

    Stack Overflow | 3 years ago | user3269787
    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]
  6. 0

    When I Start Jboss I Got The Following Exception I, Struts Strutsdatasourcemanagerontomcat5

    roseindia.net | 1 year ago
    java.sql.SQLException: Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Violation of unique constraint SYS_PK_103: duplicate value(s) for column(s) $$ in statement [/* insert org.jboss.seam.wiki.core.model.WikiDocument */ insert into WIKI_NODE (AREA_NR, CREATED_BY_USER_ID, CREATED_ON, LAST_MODIFIED_BY_USER_ID, LAST_MODIFIED_ON, MESSAGE_ID, NAME, PARENT_NODE_ID, RATING, READ_ACCESS_LEVEL, OBJ_VERSION, WIKINAME, WRITE_ACCESS_LEVEL, WRITE_PROTECTED, NODE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]

      at org.hsqldb.jdbc.Util.throwError()
    2. HSQLDB
      jdbcPreparedStatement.executeUpdate
      1. org.hsqldb.jdbc.Util.throwError(Unknown Source)
      2. org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
      2 frames
    3. JBoss Application Server Connector
      WrappedPreparedStatement.executeUpdate
      1. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:250)
      1 frame
    4. Hibernate
      AbstractEntityPersister.insert
      1. org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
      2. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2247)
      3. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
      3 frames
    5. Hibernate
      EntityInsertAction.execute
      1. org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)
      1 frame
    6. Hibernate
      ActionQueue.executeActions
      1. org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
      2. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
      3. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
      3 frames
    7. Hibernate
      SessionImpl.flush
      1. org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
      2. org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
      3. org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
      3 frames
    8. Hibernate EJB
      AbstractEntityManagerImpl.flush
      1. org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:297)
      1 frame
    9. org.jboss.seam
      EntityManagerProxy.flush
      1. org.jboss.seam.persistence.EntityManagerProxy.flush(EntityManagerProxy.java:92)
      1 frame
    10. Hibernate Search ORM
      FullTextEntityManagerImpl.flush
      1. org.hibernate.search.jpa.impl.FullTextEntityManagerImpl.flush(FullTextEntityManagerImpl.java:102)
      1 frame
    11. org.jboss.seam
      TopicHome.persist
      1. org.jboss.seam.persistence.EntityManagerProxy.flush(EntityManagerProxy.java:92)
      2. org.jboss.seam.framework.EntityHome.persist(EntityHome.java:85)
      3. org.jboss.seam.wiki.core.action.NodeHome.persist(NodeHome.java:243)
      4. org.jboss.seam.wiki.core.action.DocumentHome.persist(DocumentHome.java:195)
      5. org.jboss.seam.wiki.plugin.forum.TopicHome.persist(TopicHome.java:92)
      5 frames
    12. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    13. org.jboss.seam
      TopicHome_$$_javassist_54.persist
      1. org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
      2. org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
      3. org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
      4. org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
      5. org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
      6. org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77)
      7. org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
      8. org.jboss.seam.core.ConversationInterceptor.aroundInvoke(ConversationInterceptor.java:65)
      9. org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
      10. org.jboss.seam.transaction.TransactionInterceptor$1.work(TransactionInterceptor.java:40)
      11. org.jboss.seam.util.Work.workInTransaction(Work.java:47)
      12. org.jboss.seam.transaction.TransactionInterceptor.aroundInvoke(TransactionInterceptor.java:34)
      13. org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
      14. org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
      15. org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
      16. org.jboss.seam.security.SecurityInterceptor.aroundInvoke(SecurityInterceptor.java:138)
      17. org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
      18. org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
      19. org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
      20. org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
      21. org.jboss.seam.wiki.plugin.forum.TopicHome_$$_javassist_54.persist(TopicHome_$$_javassist_54.java)
      21 frames
    14. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    15. org.jboss.el
      MethodExpressionImpl.invoke
      1. org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
      2. org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342)
      3. org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58)
      4. org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
      5. org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
      5 frames
    16. org.jboss.seam
      SeamFilter$FilterChainImpl.doFilter
      1. org.jboss.seam.mock.AbstractSeamTest$Request.invokeMethod(AbstractSeamTest.java:464)
      2. org.jboss.seam.wiki.test.plugin.TopicHomeTests$2.invokeApplication(TopicHomeTests.java:69)
      3. org.jboss.seam.mock.AbstractSeamTest$Request.invokeApplicationPhase(AbstractSeamTest.java:647)
      4. org.jboss.seam.mock.AbstractSeamTest$Request.emulateJsfLifecycle(AbstractSeamTest.java:596)
      5. org.jboss.seam.mock.AbstractSeamTest$Request.access$300(AbstractSeamTest.java:178)
      6. org.jboss.seam.mock.AbstractSeamTest$Request$2.doFilter(AbstractSeamTest.java:498)
      7. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
      8. org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:38)
      9. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
      10. org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
      11. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
      12. org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
      13. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
      13 frames
    17. UrlRewriteFilter
      UrlRewriteFilter.doFilter
      1. org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164)
      2. org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
      3. org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
      4. org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:406)
      4 frames
    18. org.jboss.seam
      SeamFilter$FilterChainImpl.doFilter
      1. org.jboss.seam.wiki.core.ui.WikiUrlRewriteFilter.doFilter(WikiUrlRewriteFilter.java:45)
      2. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
      2 frames
    19. org.ajax4jsf.webapp
      BaseFilter.doFilter
      1. org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:150)
      2. org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:267)
      3. org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:379)
      4. org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:506)
      4 frames
    20. org.jboss.seam
      TopicHomeTests.newTopic
      1. org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
      2. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
      3. org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
      4. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
      5. org.jboss.seam.wiki.core.ui.WikiUrlSessionIdFilter.doFilter(WikiUrlSessionIdFilter.java:86)
      6. org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
      7. org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
      8. org.jboss.seam.mock.AbstractSeamTest$Request.run(AbstractSeamTest.java:492)
      9. org.jboss.seam.mock.AbstractSeamTest$FacesRequest.run(AbstractSeamTest.java:863)
      10. org.jboss.seam.wiki.test.plugin.TopicHomeTests.newTopic(TopicHomeTests.java:50)
      10 frames
    21. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    22. TestNG
      TestNG.main
      1. org.testng.internal.MethodHelper.invokeMethod(MethodHelper.java:604)
      2. org.testng.internal.Invoker.invokeMethod(Invoker.java:470)
      3. org.testng.internal.Invoker.invokeTestMethod(Invoker.java:564)
      4. org.testng.internal.Invoker.invokeTestMethods(Invoker.java:830)
      5. org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:125)
      6. org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:109)
      7. org.testng.TestRunner.runWorkers(TestRunner.java:678)
      8. org.testng.TestRunner.privateRun(TestRunner.java:624)
      9. org.testng.TestRunner.run(TestRunner.java:495)
      10. org.testng.SuiteRunner.runTest(SuiteRunner.java:300)
      11. org.testng.SuiteRunner.runSequentially(SuiteRunner.java:295)
      12. org.testng.SuiteRunner.privateRun(SuiteRunner.java:275)
      13. org.testng.SuiteRunner.run(SuiteRunner.java:190)
      14. org.testng.TestNG.createAndRunSuiteRunners(TestNG.java:792)
      15. org.testng.TestNG.runSuitesLocally(TestNG.java:765)
      16. org.testng.TestNG.run(TestNG.java:699)
      17. org.testng.TestNG.privateMain(TestNG.java:824)
      18. org.testng.TestNG.main(TestNG.java:802)
      18 frames