Hi Christian, If you are running with the Out of the box H2 database, you might need to "clean" it by removing the db file from /tmp. This will remove the entire database and regenerate it on next startup. We recommend using something like MySQL, Oracle, MS SQL for real deployments.
-Matt >-----Original Message----- >From: Christian Fischer [mailto:[email protected]] >Sent: Wednesday, July 11, 2012 12:51 PM >To: [email protected] >Subject: Re: DuplicateItemException after login > >Appendix: > >When registering a new user and logging on with it, all works perfectly. > >Only the pre-defined username/password doesn't work. But why? >(canonical / canonical) > >Greets, >Christian > > >Am 11.07.2012 17:28, schrieb Christian Fischer: >> Hi all, >> >> i tried to log into RAVE, but i get the "Rave has suffered a brief >> meltdown" Error because of a DuplicateItem exception: >> >> Request processing failed; nested exception is >> org.apache.rave.exception.DuplicateItemException: DUPLICATE_ITEM; >> nested exception is org.h2.jdbc.JdbcSQLException: Eindeutiger Index >> oder Primarschlüssel verletzt: "U_PAGE_OWNER_ID_INDEX_2 ON >> PUBLIC.PAGE(OWNER_ID, NAME, PAGE_TYPE)" >> Unique index or primary key violation: "U_PAGE_OWNER_ID_INDEX_2 ON >> PUBLIC.PAGE(OWNER_ID, NAME, PAGE_TYPE)"; SQL statement: >> INSERT INTO page (entity_id, name, page_type, owner_id, >> page_layout_id, parent_page_id) VALUES (?, ?, ?, ?, ?, ?) >> [23505- >154]org.apache.rave.persistence.jpa.impl.H2OpenJpaDialect.translateExcepti >onIfPossible(H2OpenJpaDialect.java:55) >> >> >org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransact >ionManager.java:516) >> >> >org.springframework.transaction.support.AbstractPlatformTransactionManag >er.processCommit(AbstractPlatformTransactionManager.java:754) >> >> >org.springframework.transaction.support.AbstractPlatformTransactionManag >er.commit(AbstractPlatformTransactionManager.java:723) >> >> >org.springframework.transaction.interceptor.TransactionAspectSupport.com >mitTransactionAfterReturning(TransactionAspectSupport.java:393) >> >> >org.springframework.transaction.interceptor.TransactionInterceptor.invoke(T >ransactionInterceptor.java:120) >> >> >org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(R >eflectiveMethodInvocation.java:172) >> >> >org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDyna >micAopProxy.java:202) >> >> $Proxy60.addNewDefaultUserPage(Unknown Source) >> >> >org.apache.rave.portal.web.controller.PageController.getAllPagesForAuthent >icatedUser(PageController.java:131) >> >> >org.apache.rave.portal.web.controller.PageController.viewDefault(PageContr >oller.java:75) >> >> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> >> >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.j >ava:39) >> >> >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess >orImpl.java:25) >> >> java.lang.reflect.Method.invoke(Method.java:597) >> >> >org.springframework.web.method.support.InvocableHandlerMethod.invoke( >InvocableHandlerMethod.java:212) >> >> >org.springframework.web.method.support.InvocableHandlerMethod.invoke >ForRequest(InvocableHandlerMethod.java:126) >> >> >org.springframework.web.servlet.mvc.method.annotation.ServletInvocableH >andlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) >> >> >org.springframework.web.servlet.mvc.method.annotation.RequestMapping >HandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.jav >a:617) >> >> >org.springframework.web.servlet.mvc.method.annotation.RequestMapping >HandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) >> >> >org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdap >ter.handle(AbstractHandlerMethodAdapter.java:80) >> >> >org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherSe >rvlet.java:900) >> >> >org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSer >vlet.java:827) >> >> >org.springframework.web.servlet.FrameworkServlet.processRequest(Frame >workServlet.java:882) >> >> >org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServl >et.java:778) >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:617) >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> >> >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt >erChain.java:290) >> >> >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain >.java:206) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:311) >> >> >org.springframework.security.web.access.intercept.FilterSecurityInterceptor.i >nvoke(FilterSecurityInterceptor.java:116) >> >> >org.springframework.security.web.access.intercept.FilterSecurityInterceptor. >doFilter(FilterSecurityInterceptor.java:83) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.access.ExceptionTranslationFilter.doFilter( >ExceptionTranslationFilter.java:113) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.session.SessionManagementFilter.doFilter >(SessionManagementFilter.java:101) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.authentication.AnonymousAuthentication >Filter.doFilter(AnonymousAuthenticationFilter.java:113) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.authentication.rememberme.Remember >MeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.servletapi.SecurityContextHolderAwareRe >questFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.savedrequest.RequestCacheAwareFilter.d >oFilter(RequestCacheAwareFilter.java:45) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.authentication.www.BasicAuthenticationF >ilter.doFilter(BasicAuthenticationFilter.java:150) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.authentication.AbstractAuthenticationPro >cessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.authentication.AbstractAuthenticationPro >cessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.authentication.logout.LogoutFilter.doFilter >(LogoutFilter.java:105) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.context.SecurityContextPersistenceFilter. >doFilter(SecurityContextPersistenceFilter.java:87) >> >> >org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilte >r(FilterChainProxy.java:323) >> >> >org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy. >java:173) >> >> >org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(Delega >tingFilterProxy.java:346) >> >> >org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilte >rProxy.java:259) >> >> >org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt >erChain.java:235) >> >> >org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain >.java:206) >> >> >org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal >ve.java:233) >> >> >org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv >e.java:191) >> >> >org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: >127) >> >> >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:10 >2) >> >> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:615) >> >> >org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j >ava:109) >> >> >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:29 >3) >> >> >org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859 >) >> >> >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process( >Http11Protocol.java:602) >> >> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >> >> java.lang.Thread.run(Thread.java:619) >> >> What is wrong? >> >> Same Problem by 0.12 Release AND 0.14-SNAPSHOT >> >> I Think der SQl Statement by >> >> VALUES (?, ?, ?, ?, ?, ?) >> >> is wrong? >> >> http://localhost:8080/portal/app/admin/ works perfectly - >> http://localhost:8080/portal NOT. >> >> Thanks, >> Christian >> >
