It turns out I also have problems signing up a new user, with error messages that Tony has been describing.
I'll try again tomorrow. Hiroki On 2/9/07, Anthony Perritano <[EMAIL PROTECTED]> wrote: > > restarted my machine and tried all those steps in that order. same > problem. i captured the db.init in a log. when db.init is done it says > build successful. however, there are many errors like: > > [exec] [DEBUG,JDBCExceptionReporter,main] could not insert: [ > net.sf.sail.webapp.domain.authentication.impl.PersistentUserDetails] [/* > insert net.sf.sail.webapp.domain.authentication.impl.PersistentUserDetails*/ > insert into user_details (id, OPTLOCK, password, username, email_address, > account_not_expired, account_not_locked, credentials_not_expired, enabled) > values (null, ?, ?, ?, ?, ?, ?, ?, ?)] > [exec] java.sql.SQLException: Violation of unique constraint $$: > duplicate value(s) for column(s) $$: SYS_CT_54 in statement [/* insert > net.sf.sail.webapp.domain.authentication.impl.PersistentUserDetails */ > insert into user_details (id, OPTLOCK, password, username, email_address, > account_not_expired, account_not_locked, credentials_not_expired, enabled) > values (null, ?, ?, ?, ?, ?, ?, ?, ?)] > [exec] at org.hsqldb.jdbc.Util.throwError(Unknown Source) > [exec] at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown > Source) > [exec] at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate ( > DelegatingPreparedStatement.java:101) > [exec] at > org.hibernate.id.insert.AbstractSelectingDelegate.performInsert( > AbstractSelectingDelegate.java:33) > [exec] at > org.hibernate.persister.entity.AbstractEntityPersister.insert ( > AbstractEntityPersister.java:2108) > [exec] at > org.hibernate.persister.entity.AbstractEntityPersister.insert( > AbstractEntityPersister.java:2588) > [exec] at org.hibernate.action.EntityIdentityInsertAction.execute( > EntityIdentityInsertAction.java:48) > [exec] at org.hibernate.engine.ActionQueue.execute( > ActionQueue.java:248) > [exec] at > org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate( > AbstractSaveEventListener.java :290) > [exec] at > org.hibernate.event.def.AbstractSaveEventListener.performSave( > AbstractSaveEventListener.java:180) > [exec] at > org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId( > AbstractSaveEventListener.java :108) > [exec] at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId > (DefaultSaveOrUpdateEventListener.java:186) > [exec] at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient( > DefaultSaveOrUpdateEventListener.java:175) > [exec] at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate > (DefaultSaveOrUpdateEventListener.java:98) > [exec] at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate ( > DefaultSaveOrUpdateEventListener.java:70) > [exec] at org.hibernate.impl.SessionImpl.fireSaveOrUpdate( > SessionImpl.java:507) > [exec] at org.hibernate.impl.SessionImpl.saveOrUpdate( > SessionImpl.java:499) > [exec] at org.hibernate.impl.SessionImpl.saveOrUpdate( > SessionImpl.java:495) > [exec] at > org.springframework.orm.hibernate3.HibernateTemplate$16.doInHibernate( > HibernateTemplate.java:684) > [exec] at > org.springframework.orm.hibernate3.HibernateTemplate.execute( > HibernateTemplate.java:367) > [exec] at > org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate( > HibernateTemplate.java:681) > [exec] at net.sf.sail.webapp.dao.impl.AbstractHibernateDao.save( > AbstractHibernateDao.java:52) > [exec] at > net.sf.sail.webapp.dao.authentication.impl.HibernateUserDetailsDaoTest.testSave > (HibernateUserDetailsDaoTest.java:175) > [exec] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > [exec] at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:39) > [exec] at sun.reflect.DelegatingMethodAccessorImpl.invoke ( > DelegatingMethodAccessorImpl.java:25) > [exec] at java.lang.reflect.Method.invoke(Method.java:585) > [exec] at junit.framework.TestCase.runTest(TestCase.java:164) > [exec] at junit.framework.TestCase.runBare (TestCase.java:130) > [exec] at org.springframework.test.ConditionalTestCase.runBare( > ConditionalTestCase.java:69) > [exec] at junit.framework.TestResult$1.protect(TestResult.java > :106) > [exec] at junit.framework.TestResult.runProtected(TestResult.java > :124) > [exec] at junit.framework.TestResult.run(TestResult.java:109) > [exec] at junit.framework.TestCase.run(TestCase.java:120) > [exec] at junit.framework.TestSuite.runTest(TestSuite.java:230) > [exec] at junit.framework.TestSuite.run(TestSuite.java:225) > [exec] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > [exec] at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:39) > [exec] at sun.reflect.DelegatingMethodAccessorImpl.invoke( > DelegatingMethodAccessorImpl.java:25) > [exec] at java.lang.reflect.Method.invoke (Method.java:585) > [exec] at org.apache.maven.surefire.junit.JUnitTestSet.execute( > JUnitTestSet.java:210) > [exec] at > org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet( > AbstractDirectoryTestSuite.java :135) > [exec] at > org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute( > AbstractDirectoryTestSuite.java:122) > [exec] at org.apache.maven.surefire.Surefire.run(Surefire.java > :129) > [exec] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > [exec] at sun.reflect.NativeMethodAccessorImpl.invoke( > NativeMethodAccessorImpl.java:39) > [exec] at sun.reflect.DelegatingMethodAccessorImpl.invoke ( > DelegatingMethodAccessorImpl.java:25) > [exec] at java.lang.reflect.Method.invoke(Method.java:585) > [exec] at > org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess( > SurefireBooter.java:225) > [exec] at org.apache.maven.surefire.booter.SurefireBooter.main( > SurefireBooter.java:747) > [exec] [WARN,JDBCExceptionReporter,main] SQL Error: -104, SQLState: > 23000 > [exec] [ERROR,JDBCExceptionReporter,main] Violation of unique > constraint $$: duplicate value(s) for column(s) $$: SYS_CT_54 in statement > [/* insert > net.sf.sail.webapp.domain.authentication.impl.PersistentUserDetails */ > insert into user_details (id, OPTLOCK, password, username, email_address, > account_not_expired, account_not_locked, credentials_not_expired, enabled) > values (null, ?, ?, ?, ?, ?, ?, ?, ?)] > [exec] [DEBUG,HibernateTemplate,main] Not closing pre-bound Hibernate > Session after HibernateTemplate > [exec] [DEBUG,DefaultListableBeanFactory,main] Creating instance of > bean 'mutableUserDetails' with merged definition [Root bean: class [null]; > scope=prototype; abstract=false; lazyInit=false; autowireCandidate=true; > autowireMode=0; dependencyCheck=0; factoryBeanName=userDetailsDao; > factoryMethodName=createDataObject; initMethodName=null; > destroyMethodName=null; defined in class path resource [ > applicationContext-security.xml]] > [exec] [DEBUG,DefaultListableBeanFactory,main] Returning cached > instance of singleton bean 'userDetailsDao' > [exec] [DEBUG,DefaultListableBeanFactory,main] Bean > 'mutableUserDetails' instantiated via factory method 'public > net.sf.sail.webapp.domain.authentication.MutableUserDetails > net.sf.sail.webapp.dao.authentication.impl.HibernateUserDetailsDao.createDataObject > ()' > [exec] [DEBUG,DefaultListableBeanFactory,main] Returning cached > instance of singleton bean ' > org.springframework.transaction.interceptor.TransactionAttributeSourceAdvi > > > On 2/9/07, laurel <[EMAIL PROTECTED] > wrote: > > > > > > Hi Tony, > > > > Sorry for the frustrating time you must be having...you'll get you > > there. Wish we could be > > there in person to work this out (particularly given the -20 wind > > chill we are experiencing > > this week <grin>. I think Cynick may have neglected to mention that > > you need to stop tomcat > > for the ant db.create and ant db.init. So try this please and see if > > this works. > > > > update the code again. > > stop tomcat. > > ant db.create > > ant db.init > > restart tomcat > > undeploy the code > > recompile the code > > redeploy the code. > > > > Try to sign up again. > > > > Can you also check in with Hiroki and see if it is working for him > > too? > > He may have to do the whole cycle described above as well. > > Hopefully the code will be working for both of you for pairing next > > week, but > > otherwise Cynick will work with you both to get it working as part of > > the > > pairing exercise. > > > > I know you guys have a busy day today, but let us know if you run into > > more problems as soon as you can. > > > > Laurel > > > > On Feb 8, 7:11 pm, "Anthony Perritano" <[EMAIL PROTECTED]> wrote: > > > this is what happens when i click sign up with a username and pass in > > the > > > textareas: > > > > > > ibernate: > > > select > > > persistent0_.id as id1_, > > > persistent0_.OPTLOCK as OPTLOCK1_, > > > persistent0_.password as password1_, > > > persistent0_.username as username1_, > > > persistent0_.email_address as email5_1_, > > > persistent0_.account_not_expired as account6_1_, > > > persistent0_.account_not_locked as account7_1_, > > > persistent0_.credentials_not_expired as credenti8_1_, > > > persistent0_.enabled as enabled1_ > > > from > > > user_details persistent0_ > > > where > > > persistent0_.username=? > > > Hibernate: > > > select > > > persistent0_.id as id0_, > > > persistent0_.OPTLOCK as OPTLOCK0_, > > > persistent0_.role as role0_ > > > from > > > roles persistent0_ > > > where > > > persistent0_.role=? > > > [INFO,HttpRestTransportImpl,http-8080-Processor25] POST: > > http://rails.dev.concord.org/sds/4/user > > > Hibernate: > > > insert > > > into > > > sds_users > > > (id, OPTLOCK, user_id, first_name, last_name) > > > values > > > (null, ?, ?, ?, ?) > > > Hibernate: > > > call identity() > > > Hibernate: > > > insert > > > into > > > user_details > > > (id, OPTLOCK, password, username, email_address, > > > account_not_expired, account_not_locked, credentials_not_expired, > > enabled) > > > values > > > (null, ?, ?, ?, ?, ?, ?, ?, ?) > > > Hibernate: > > > call identity() > > > Hibernate: > > > insert > > > into > > > users > > > (id, OPTLOCK, sds_user_fk, user_details_fk) > > > values > > > (null, ?, ?, ?) > > > Hibernate: > > > call identity() > > > Hibernate: > > > insert > > > into > > > users_roles > > > (user_fk, role_fk) > > > values > > > (?, ?) > > > [WARN,JDBCExceptionReporter,http-8080-Processor25] SQL Error: 0, > > SQLState: > > > null > > > [ERROR,JDBCExceptionReporter,http-8080-Processor25] failed batch > > > [ERROR,AbstractFlushingEventListener,http-8080-Processor25] Could not > > > synchronize database state with session > > > 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 > > > :143) > > > 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 > > > > > org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit( > > > HibernateTransactionManager.java :562) > > > at > > > > > org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit > > > (AbstractPlatformTransactionManager.java:654) > > > at > > > > > org.springframework.transaction.support.AbstractPlatformTransactionManager.commit > > > (AbstractPlatformTransactionManager.java:624) > > > at > > > > > org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning > > > (TransactionAspectSupport.java :307) > > > at > > > > > org.springframework.transaction.interceptor.TransactionInterceptor.invoke > > ( > > > TransactionInterceptor.java:117) > > > at > > > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed ( > > > ReflectiveMethodInvocation.java:176) > > > at org.springframework.aop.framework.JdkDynamicAopProxy.invoke > > ( > > > JdkDynamicAopProxy.java:210) > > > at $Proxy33.createUser(Unknown Source) > > > at > > > > > net.sf.sail.webapp.presentation.web.controllers.SignupController.onSubmit > > ( > > > SignupController.java:58) > > > at > > > > > org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission > > > (SimpleFormController.java:267) > > > at > > > > > org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal > > > (AbstractFormController.java:250) > > > at > > > org.springframework.web.servlet.mvc.AbstractController.handleRequest ( > > > AbstractController.java:153) > > > at > > > > > org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle > > ( > > > SimpleControllerHandlerAdapter.java:45) > > > at > > org.springframework.web.servlet.DispatcherServlet.doDispatch ( > > > DispatcherServlet.java:820) > > > at org.springframework.web.servlet.DispatcherServlet.doService > > ( > > > DispatcherServlet.java:755) > > > at > > org.springframework.web.servlet.FrameworkServlet.processRequest ( > > > FrameworkServlet.java:396) > > > at org.springframework.web.servlet.FrameworkServlet.doPost( > > > FrameworkServlet.java:360) > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java > > :802) > > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter( > > > ApplicationFilterChain.java:252) > > > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > > > ApplicationFilterChain.java:173) > > > at > > > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > > > FilterChainProxy.java :264) > > > at > > org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke( > > > FilterSecurityInterceptor.java:107) > > > at > > > org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter ( > > > FilterSecurityInterceptor.java:72) > > > at > > > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > > > FilterChainProxy.java:274) > > > at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter ( > > > ExceptionTranslationFilter.java:110) > > > at > > > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > > > FilterChainProxy.java:274) > > > at > > > > > org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter( > > > AnonymousProcessingFilter.java:125) > > > at > > > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > > > FilterChainProxy.java:274) > > > at org.acegisecurity.ui.AbstractProcessingFilter.doFilter ( > > > AbstractProcessingFilter.java:217) > > > at > > > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > > > FilterChainProxy.java:274) > > > at > > > org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter( > > > HttpSessionContextIntegrationFilter.java:229) > > > at > > > org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter( > > > FilterChainProxy.java:274) > > > at org.acegisecurity.util.FilterChainProxy.doFilter ( > > > FilterChainProxy.java:148) > > > at org.acegisecurity.util.FilterToBeanProxy.doFilter( > > > FilterToBeanProxy.java:98) > > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter ( > > > ApplicationFilterChain.java:202) > > > at org.apache.catalina.core.ApplicationFilterChain.doFilter( > > > ApplicationFilterChain.java:173) > > > at org.apache.catalina.core.StandardWrapperValve.invoke ( > > > StandardWrapperValve.java:213) > > > at org.apache.catalina.core.StandardContextValve.invoke( > > > StandardContextValve.java:178) > > > at org.apache.catalina.core.StandardHostValve.invoke ( > > > StandardHostValve.java:126) > > > at org.apache.catalina.valves.ErrorReportValve.invoke( > > > ErrorReportValve.java:105) > > > at org.apache.catalina.core.StandardEngineValve.invoke( > > > StandardEngineValve.java:107) > > > at org.apache.catalina.connector.CoyoteAdapter.service( > > > CoyoteAdapter.java:148) > > > at org.apache.coyote.http11.Http11Processor.process( > > > Http11Processor.java :869) > > > at > > > > > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection > > > (Http11BaseProtocol.java:664) > > > at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket ( > > > PoolTcpEndpoint.java:527) > > > at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt > > ( > > > LeaderFollowerWorkerThread.java:80) > > > at > > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run ( > > > ThreadPool.java:684) > > > at java.lang.Thread.run(Thread.java:613) > > > 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.apache.commons.dbcp.DelegatingStatement.executeBatch( > > > DelegatingStatement.java:294) > > > at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch( > > > BatchingBatcher.java:48) > > > at org.hibernate.jdbc.AbstractBatcher.executeBatch( > > > AbstractBatcher.java:242) > > > ... 56 more > > > [ERROR,[dispatcher],http-8080-Processor25] Servlet.service() for > > servlet > > > dispatcher threw exception > > > 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 > > > :143) > > > 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 > > > > > org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit( > > > HibernateTransactionManager.java:562) > > > at... > > > > > > read more ยป > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SAIL-Dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/SAIL-Dev?hl=en -~----------~----~----~----~------~----~------~--~---
