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 -~----------~----~----~----~------~----~------~--~---
