Anil wrote: > Which specific MySQL 5.x server version are you using and > which JDBC driver are you using? > mysql-5.0.16 and JDBC driver: mysql-connector-java-3.0.17.
And I found for every column whose type is "bit" there is always an error: "Data too long for column '*******'". Thans a lot! > -----Original Message----- > From: Anil Gangolli [mailto:[EMAIL PROTECTED] > Sent: 28 November 2005 04:43 > To: [email protected] > Subject: Re: Can't add a new user with roller 2.0 > > Which specific MySQL 5.x server version are you using and > which JDBC driver are you using? > > --a. > > > zhangenpei wrote: > > >Hi, > > > >I just tried roller2.0 ( I am using tomcat5.5 and mysql 5.0 > ). But when > >I tried to register a new user, I got the following > exceptions. Could > >you tell me how to resolve it? > > > >ERROR 2005-11-27 05:48:03,284 UserNewAction:add - ERROR in addUser > >org.roller.RollerException > > at > >org.roller.business.hibernate.HibernateStrategy.commit(Hibern > ateStrateg > >y.jav > >a:440) > > at > >org.roller.business.hibernate.HibernateRollerImpl.commit(Hibe > rnateRolle > >rImpl > >.java:115) > > at > >org.roller.presentation.website.actions.UserNewAction.add(Use > rNewAction > >.java > >:160) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces > sorImpl.ja > >va:39 > >) > > at > >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet > hodAccesso > >rImpl > >.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > >org.apache.struts.actions.DispatchAction.dispatchMethod(Dispa > tchAction.java: > >276) > > at > >org.apache.struts.actions.DispatchAction.execute(DispatchActi > on.java:196) > > at > >org.apache.struts.action.RequestProcessor.processActionPerfor > m(RequestP > >roces > >sor.java:421) > > at > >org.apache.struts.action.RequestProcessor.process(RequestProc > essor.java:226) > > at > >org.apache.struts.action.ActionServlet.process(ActionServlet. > java:1164) > > at > >org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:252) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.roller.presentation.filters.BreadCrumbFilter.doFilter(Bre > adCrumbFil > >ter.j > >ava:77) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:202) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.roller.presentation.filters.RequestFilter.doFilter(Reques > tFilter.ja > >va:13 > >4) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:202) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.roller.presentation.filters.PersistenceSessionFilter.doFi > lter(Persi > >stenc > >eSessionFilter.java:53) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:202) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.roller.presentation.filters.SchemeEnforcementFilter.doFil > ter(Scheme > >Enfor > >cementFilter.java:97) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:202) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.roller.presentation.filters.CharEncodingFilter.doFilter(C > harEncodin > >gFilt > >er.java:94) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:202) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.apache.catalina.core.StandardWrapperValve.invoke(Standard > WrapperVal > >ve.ja > >va:213) > > at > >org.apache.catalina.core.StandardContextValve.invoke(Standard > ContextVal > >ve.ja > >va:178) > > at > >org.apache.catalina.authenticator.AuthenticatorBase.invoke(Au > thenticato > >rBase > >.java:407) > > at > >org.apache.catalina.core.StandardHostValve.invoke(StandardHos > tValve.jav > >a:126 > >) > > at > >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepor > tValve.jav > >a:105 > >) > > at > >org.apache.catalina.core.StandardEngineValve.invoke(StandardE > ngineValve > >.java > >:107) > > at > >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAda > pter.java:148) > > at > >org.apache.coyote.http11.Http11Processor.process(Http11Proces > sor.java:856) > > at > >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandl > er.process > >Conne > >ction(Http11Protocol.java:744) > > at > >org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Pool > TcpEndpoin > >t.jav > >a:527) > > at > >org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(L > eaderFollo > >werWo > >rkerThread.java:80) > > at > >org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run > (ThreadPoo > >l.jav > >a:684) > > at java.lang.Thread.run(Thread.java:534) > >--- ROOT CAUSE --- > >org.hibernate.exception.GenericJDBCException: Could not execute JDBC > >batch update > > at > >org.hibernate.exception.ErrorCodeConverter.handledNonSpecific > Exception( > >Error > >CodeConverter.java:92) > > at > >org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeC > onverter.j > >ava:8 > >0) > > at > >org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep > tionHelper > >.java > >:43) > > at > >org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatch > er.java:181) > > at > >org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractB > atcher.java:74) > > at > >org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractB > atcher.java:69) > > at > >org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(Abst > ractBatche > >r.jav > >a:150) > > at > >org.hibernate.persister.entity.BasicEntityPersister.insert(Ba > sicEntityP > >ersis > >ter.java:1839) > > at > >org.hibernate.persister.entity.BasicEntityPersister.insert(Ba > sicEntityP > >ersis > >ter.java:2200) > > at > >org.hibernate.action.EntityInsertAction.execute(EntityInsertA > ction.java:46) > > at > org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239) > > at > >org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223) > > at > >org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136) > > at > >org.hibernate.event.def.AbstractFlushingEventListener.perform > Executions > >(Abst > >ractFlushingEventListener.java:274) > > at > >org.hibernate.event.def.DefaultFlushEventListener.onFlush(Def > aultFlushE > >ventL > >istener.java:27) > > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730) > > at > >org.roller.business.hibernate.HibernateStrategy.commit(Hibern > ateStrateg > >y.jav > >a:428) > > at > >org.roller.business.hibernate.HibernateRollerImpl.commit(Hibe > rnateRolle > >rImpl > >.java:115) > > at > >org.roller.presentation.website.actions.UserNewAction.add(Use > rNewAction > >.java > >:160) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces > sorImpl.ja > >va:39 > >) > > at > >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet > hodAccesso > >rImpl > >.java:25) > > at java.lang.reflect.Method.invoke(Method.java:324) > > at > >org.apache.struts.actions.DispatchAction.dispatchMethod(Dispa > tchAction.java: > >276) > > at > >org.apache.struts.actions.DispatchAction.execute(DispatchActi > on.java:196) > > at > >org.apache.struts.action.RequestProcessor.processActionPerfor > m(RequestP > >roces > >sor.java:421) > > at > >org.apache.struts.action.RequestProcessor.process(RequestProc > essor.java:226) > > at > >org.apache.struts.action.ActionServlet.process(ActionServlet. > java:1164) > > at > >org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:252) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.roller.presentation.filters.BreadCrumbFilter.doFilter(Bre > adCrumbFil > >ter.j > >ava:77) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:202) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.roller.presentation.filters.RequestFilter.doFilter(Reques > tFilter.ja > >va:13 > >4) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:202) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.roller.presentation.filters.PersistenceSessionFilter.doFi > lter(Persi > >stenc > >eSessionFilter.java:53) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:202) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.roller.presentation.filters.SchemeEnforcementFilter.doFil > ter(Scheme > >Enfor > >cementFilter.java:97) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:202) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.roller.presentation.filters.CharEncodingFilter.doFilter(C > harEncodin > >gFilt > >er.java:94) > > at > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil > ter(Applic > >ation > >FilterChain.java:202) > > at > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl > icationFil > >terCh > >ain.java:173) > > at > >org.apache.catalina.core.StandardWrapperValve.invoke(Standard > WrapperVal > >ve.ja > >va:213) > > at > >org.apache.catalina.core.StandardContextValve.invoke(Standard > ContextVal > >ve.ja > >va:178) > > at > >org.apache.catalina.authenticator.AuthenticatorBase.invoke(Au > thenticato > >rBase > >.java:407) > > at > >org.apache.catalina.core.StandardHostValve.invoke(StandardHos > tValve.jav > >a:126 > >) > > at > >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepor > tValve.jav > >a:105 > >) > > at > >org.apache.catalina.core.StandardEngineValve.invoke(StandardE > ngineValve > >.java > >:107) > > at > >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAda > pter.java:148) > > at > >org.apache.coyote.http11.Http11Processor.process(Http11Proces > sor.java:856) > > at > >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandl > er.process > >Conne > >ction(Http11Protocol.java:744) > > at > >org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Pool > TcpEndpoin > >t.jav > >a:527) > > at > >org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(L > eaderFollo > >werWo > >rkerThread.java:80) > > at > >org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run > (ThreadPoo > >l.jav > >a:684) > > at java.lang.Thread.run(Thread.java:534) > >Caused by: java.sql.BatchUpdateException: Data too long for column > >'isenabled' at row 1 > > at > >com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStateme > nt.java:1540) > > at > >org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch( > Delegating > >State > >ment.java:294) > > at > >org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBat > cher.java:57) > > at > >org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatch > er.java:174) > > ... 57 more > > > > > > > > > >
