Try the latest MySQL JDBC Driver - I believe the version is 3.1.11. Matt
On 11/27/05, zhangenpei <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > > > > > > > > > > > >
