I know the problem now, I didn't look carefully through all the instuction doc, at the end, there are some tips for problems often occured, I used the low version of mysql driver(3.x), it should be newer than v3.x, I change to the newest mysql version, it works fine now.
I have an advice for xwiki team, as the beginner user, I can not find some resources effiently, I suggest to put some important resources and the install package, so that I can find it correctly and easily without going to some details of long documentation, it will be helpful for some new users, especially someone just wants to have a try 2011/3/20 Vincent Massol <[email protected]> > Hi, > > Have you tried searching on xwiki.markmail.org? > > For ex the following > > http://xwiki.markmail.org/search/?q=Data%20too%20long%20for%20column%20%27XWD_MINOREDIT%27 > suggest an issue with the driver you're using. > > Hope to helps, > -Vincent > > On Mar 20, 2011, at 1:14 PM, 许凌志 wrote: > > > I followed the instruction to install the xiwi to tomcat and using mysql > > database. > > I think database connection is right, because the tables of xwiki was > > installed to databse. according to the error log, it might caused by > > "*java.sql.BatchUpdateException: Data too long for column > > 'XWD_MINOREDIT' at > > row 1*". > > > > Anyone can help me out? > > > > here is my configuration file： > > > > hibernate： > > > > <property > > > name="connection.url">jdbc:mysql://localhost:3306/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=''</property> > > <property name="connection.username">root</property> > > <property name="connection.password">root</property> > > <property > > name="connection.driver_class">com.mysql.jdbc.Driver</property> > > <property name="dialect">org.hibernate.dialect.MySQLDialect</property> > > <property > > > name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> > > <property name="connection.pool_size">2</property> > > <property name="statement_cache.size">2</property> > > <mapping resource="xwiki.hbm.xml"/> > > <mapping resource="feeds.hbm.xml"/> > > <mapping resource="activitystream.hbm.xml"/> > > > > The error track： > > com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize > main > > XWiki context > > Wrapped Exception: Error number 3201 in 3: Exception while saving > document > > xwiki:XWiki.XWikiPreferences > > Wrapped Exception: Failed to commit or rollback transaction. Root cause > [] > > at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:425) > > at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:494) > > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:137) > > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:117) > > at > > > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > > at > > > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) > > at > > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > > at > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > > at > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > > at > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > > at > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > > at > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) > > at > > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > > at > > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > > at java.lang.Thread.run(Thread.java:619) > > > > > > Wrapped Exception: > > > > com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while > saving > > document xwiki:XWiki.XWikiPreferences > > Wrapped Exception: Failed to commit or rollback transaction. Root cause > [] > > at > > > com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:657) > > at > > > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:183) > > at > > > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:177) > > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1442) > > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1389) > > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1384) > > at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:3310) > > at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:873) > > at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:842) > > at com.xpn.xwiki.XWiki.<init>(XWiki.java:763) > > at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:406) > > at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:494) > > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:137) > > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:117) > > at > > > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > > at > > > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) > > at > > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > > at > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > > at > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > > at > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > > at > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > > at > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) > > at > > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > > at > > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > > at java.lang.Thread.run(Thread.java:619) > > > > > > Wrapped Exception: > > > > org.hibernate.exception.DataException: Could not execute JDBC batch > update > > at > > > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77) > > at > > > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) > > at > > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253) > > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) > > at > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) > > 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 > > > com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:871) > > at > > > com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:842) > > at > > > com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:647) > > at > > > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:183) > > at > > > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:177) > > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1442) > > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1389) > > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1384) > > at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:3310) > > at com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:873) > > at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:842) > > at com.xpn.xwiki.XWiki.<init>(XWiki.java:763) > > at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:406) > > at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:494) > > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:137) > > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:117) > > at > > > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > > at > > > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) > > at > > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > > at > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:129) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > > at > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > > at > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > > at > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > > at > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > > at > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) > > at > > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > > at > > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > > at java.lang.Thread.run(Thread.java:619) > > *Caused by: java.sql.BatchUpdateException: Data too long for column > > 'XWD_MINOREDIT' at row 1* > > at > > > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1566) > > at > > > org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) > > at > > > org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) > > at > > > org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) > > at > > > org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) > > at > > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) > > ... 56 more > > > > > > > > -- > > Best wishes, > > > > 许凌志 > > > > MOE KLINNS Lab and SKLMS Lab, Xi'an Jiaotong University > > > > Department of Computer Science and Technology, Xi’an Jiaotong University > > _______________________________________________ > > users mailing list > > [email protected] > > http://lists.xwiki.org/mailman/listinfo/users > > _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users > -- Best wishes, 许凌志 MOE KLINNS Lab and SKLMS Lab, Xi'an Jiaotong University Department of Computer Science and Technology, Xi’an Jiaotong University _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
