[xwiki-users] Have error when install XWIKI v3
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
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%27XW... 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
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%27XW... 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
On Mar 20, 2011, at 1:55 PM, 许凌志 wrote:
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
We want to improve this. Do you have concrete suggestions to help us do what you say? Also why didn't you pick the standalone distribution which has everything bundled (it's for beginning user)? Thanks -Vincent
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%27XW... 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*".
[snip]
Cause I am familar with java dev, and I prefer to install all under my control, so I decide to install the war file and database by my own, that makes me feel safe. Have you ever use some php application like Drupal, the install is very easy through a wizard or install.php, I think it will be better if xwiki can supply such wizard function through a friend interface. 2011/3/20 Vincent Massol <[email protected]>
On Mar 20, 2011, at 1:55 PM, 许凌志 wrote:
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
We want to improve this. Do you have concrete suggestions to help us do what you say?
Also why didn't you pick the standalone distribution which has everything bundled (it's for beginning user)?
Thanks -Vincent
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%27XW...
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*".
[snip]
_______________________________________________ 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
On 03/20/2011 02:04 PM, 许凌志 wrote:
Cause I am familar with java dev, and I prefer to install all under my control, so I decide to install the war file and database by my own, that makes me feel safe.
Have you ever use some php application like Drupal, the install is very easy through a wizard or install.php, I think it will be better if xwiki can supply such wizard function through a friend interface.
Strange, I always say how easy it is to setup XWiki compared to most other PHP applications. It depends on what's your starting point and what do you want to do. Setting up XWiki for complete beginners is much easier than setting up a PHP application for complete beginners. XWiki has an .exe that brings in everything, or it has a .zip that can be unpacked on a portable USB drive. Other than a working JVM, there's no need for advanced setup. On the other hand, PHP applications expect an already configured working LAMP/WAMP environment, and once you manage to get that working, and you unpack the application in /var/www/, it is easy to finish the configuration. Sure, now it's easy to get a working LAMP machine in a few minutes, if you're an advanced user, but for a non-tech windows user just wanting to try this thing, "the droo pal or what's it called", how do you explain setting up PHP on top of Apache HTTPD, and that's just so that you can begin installing Drupal. There are two distinct phases here, the installation and the configuration. XWiki, as most java web applications, is easy to install, but we're lacking on the first-run configuration part. We're aware of this, and we'll try to improve it. However, this is not the top priority feature that we should work on, since: - the initial setup is done once, by one person, so features that will be used by every user every day take priority over features that are used once by one user - for a very quick setup, we do provide the standalone packages The initial setup has been bugging me as well, and I'd like to see that part improved, but the fastest way to see it implemented is to get patches from contributors. Now, coming to your specific problem, I'm not sure it's really a valid point. Installing the right database connector is not something that should be done by the application itself in a first-run wizard. If it were able to do that it would actually signal a bad system setup, security-wise. It's a good rule not to allow web applications read-write access to the machine it's sitting on. PHP applications don't have this problem since PHP already offers the needed connectors. We could overcome this by packaging a bunch of connectors by default, it would be only a slight increase in size and in required memory. But I'm not so sure about that, currently I'm -0 for this idea. And frankly, I don't understand why would you download the 3.x version when 5.x is available. You're not the first one to do this, it's quite often, so there could be a good reason. Did you intentionally use 3.x? Did you reach that version from someplace else where 5.x wasn't listed? Was it already there somehow?
2011/3/20 Vincent Massol<[email protected]>
On Mar 20, 2011, at 1:55 PM, 许凌志 wrote:
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
We want to improve this. Do you have concrete suggestions to help us do what you say?
Also why didn't you pick the standalone distribution which has everything bundled (it's for beginning user)?
Thanks -Vincent
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%27XW...
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*".
-- Sergiu Dumitriu http://purl.org/net/sergiu/
Vincent, thank you very much for your patient reply, I think I made a mistake that I stand by the side of advanced user to see the problem of the beginners who have litter idea of server side knowledge. For beginners, I think the .exe and .zip install files are easy and convienent enough for them to install xwiki. However, war file is also convienient for advanced users to install and confirure their xwiki with customized database and web container. The thing confused me was that I didn't get through all the docs, and finnally got a wrong jdbc jar for running xwiki properly. The reason I didn't got the 5.x version first because I used 3.x version often in my own java projects for almost 3 or 4 years, it worked fine all the time, so I didn't think too much for using it in xwiki. I think most of people who have the same mistake would have same situation with me: old version was existed in their computor, and they might not try to download one, it saves time. Another advice for improving the installation instruction for mysql was following: - Add version required beside the driver download url link, for example "You can download it from the MySQL Connector/J Driver page<http://www.mysql.com/products/connector/j/>( *! 5.x version required, 3.x version will result in errors*)or directly from the Maven Central Repository<http://repo1.maven.org/maven2/mysql/mysql-connector-java/> ." I think it might be helpful for the advanced users to emphasize this tips. On Mon, Mar 21, 2011 at 6:29 AM, Sergiu Dumitriu <[email protected]> wrote:
On 03/20/2011 02:04 PM, 许凌志 wrote:
Cause I am familar with java dev, and I prefer to install all under my control, so I decide to install the war file and database by my own, that makes me feel safe.
Have you ever use some php application like Drupal, the install is very easy through a wizard or install.php, I think it will be better if xwiki can supply such wizard function through a friend interface.
Strange, I always say how easy it is to setup XWiki compared to most other PHP applications.
It depends on what's your starting point and what do you want to do. Setting up XWiki for complete beginners is much easier than setting up a PHP application for complete beginners. XWiki has an .exe that brings in everything, or it has a .zip that can be unpacked on a portable USB drive. Other than a working JVM, there's no need for advanced setup.
On the other hand, PHP applications expect an already configured working LAMP/WAMP environment, and once you manage to get that working, and you unpack the application in /var/www/, it is easy to finish the configuration. Sure, now it's easy to get a working LAMP machine in a few minutes, if you're an advanced user, but for a non-tech windows user just wanting to try this thing, "the droo pal or what's it called", how do you explain setting up PHP on top of Apache HTTPD, and that's just so that you can begin installing Drupal.
There are two distinct phases here, the installation and the configuration. XWiki, as most java web applications, is easy to install, but we're lacking on the first-run configuration part. We're aware of this, and we'll try to improve it.
However, this is not the top priority feature that we should work on, since:
- the initial setup is done once, by one person, so features that will be used by every user every day take priority over features that are used once by one user - for a very quick setup, we do provide the standalone packages
The initial setup has been bugging me as well, and I'd like to see that part improved, but the fastest way to see it implemented is to get patches from contributors.
Now, coming to your specific problem, I'm not sure it's really a valid point. Installing the right database connector is not something that should be done by the application itself in a first-run wizard. If it were able to do that it would actually signal a bad system setup, security-wise. It's a good rule not to allow web applications read-write access to the machine it's sitting on. PHP applications don't have this problem since PHP already offers the needed connectors. We could overcome this by packaging a bunch of connectors by default, it would be only a slight increase in size and in required memory. But I'm not so sure about that, currently I'm -0 for this idea.
And frankly, I don't understand why would you download the 3.x version when 5.x is available. You're not the first one to do this, it's quite often, so there could be a good reason. Did you intentionally use 3.x? Did you reach that version from someplace else where 5.x wasn't listed? Was it already there somehow?
2011/3/20 Vincent Massol<[email protected]>
On Mar 20, 2011, at 1:55 PM, 许凌志 wrote:
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
We want to improve this. Do you have concrete suggestions to help us do what you say?
Also why didn't you pick the standalone distribution which has everything bundled (it's for beginning user)?
Thanks -Vincent
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%27XW...
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*".
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Best wishes, 许凌志(Jame Xu) MOE KLINNS Lab and SKLMS Lab, Xi'an Jiaotong University Department of Computer Science and Technology, Xi’an Jiaotong University
Dear Sergiu, thank you very much for your patient reply, I think I made a mistake that I stand by the side of advanced user to see the problem of the beginners who have litter idea of server side knowledge. For beginners, I think the .exe and .zip install files are easy and convienent enough for them to install xwiki. However, war file is also convienient for advanced users to install and confirure their xwiki with customized database and web container. The thing confused me was that I didn't get through all the docs, and finnally got a wrong jdbc jar for running xwiki properly. The reason I didn't got the 5.x version first because I used 3.x version often in my own java projects for almost 3 or 4 years, it worked fine all the time, so I didn't think too much for using it in xwiki. I think most of people who have the same mistake would have same situation with me: old version was existed in their computor, and they might not try to download one, it saves time. Another advice for improving the installation instruction for mysql was following: - Add version required beside the driver download url link, for example "You can download it from the MySQL Connector/J Driver page<http://www.mysql.com/products/connector/j/>( *! 5.x version required, 3.x version will result in errors*)or directly from the Maven Central Repository<http://repo1.maven.org/maven2/mysql/mysql-connector-java/> ." I think it might be helpful for the advanced users to emphasize this tips. On Mon, Mar 21, 2011 at 6:29 AM, Sergiu Dumitriu <[email protected]> wrote:
On 03/20/2011 02:04 PM, 许凌志 wrote:
Cause I am familar with java dev, and I prefer to install all under my control, so I decide to install the war file and database by my own, that makes me feel safe.
Have you ever use some php application like Drupal, the install is very easy through a wizard or install.php, I think it will be better if xwiki can supply such wizard function through a friend interface.
Strange, I always say how easy it is to setup XWiki compared to most other PHP applications.
It depends on what's your starting point and what do you want to do. Setting up XWiki for complete beginners is much easier than setting up a PHP application for complete beginners. XWiki has an .exe that brings in everything, or it has a .zip that can be unpacked on a portable USB drive. Other than a working JVM, there's no need for advanced setup.
On the other hand, PHP applications expect an already configured working LAMP/WAMP environment, and once you manage to get that working, and you unpack the application in /var/www/, it is easy to finish the configuration. Sure, now it's easy to get a working LAMP machine in a few minutes, if you're an advanced user, but for a non-tech windows user just wanting to try this thing, "the droo pal or what's it called", how do you explain setting up PHP on top of Apache HTTPD, and that's just so that you can begin installing Drupal.
There are two distinct phases here, the installation and the configuration. XWiki, as most java web applications, is easy to install, but we're lacking on the first-run configuration part. We're aware of this, and we'll try to improve it.
However, this is not the top priority feature that we should work on, since:
- the initial setup is done once, by one person, so features that will be used by every user every day take priority over features that are used once by one user - for a very quick setup, we do provide the standalone packages
The initial setup has been bugging me as well, and I'd like to see that part improved, but the fastest way to see it implemented is to get patches from contributors.
Now, coming to your specific problem, I'm not sure it's really a valid point. Installing the right database connector is not something that should be done by the application itself in a first-run wizard. If it were able to do that it would actually signal a bad system setup, security-wise. It's a good rule not to allow web applications read-write access to the machine it's sitting on. PHP applications don't have this problem since PHP already offers the needed connectors. We could overcome this by packaging a bunch of connectors by default, it would be only a slight increase in size and in required memory. But I'm not so sure about that, currently I'm -0 for this idea.
And frankly, I don't understand why would you download the 3.x version when 5.x is available. You're not the first one to do this, it's quite often, so there could be a good reason. Did you intentionally use 3.x? Did you reach that version from someplace else where 5.x wasn't listed? Was it already there somehow?
2011/3/20 Vincent Massol<[email protected]>
On Mar 20, 2011, at 1:55 PM, 许凌志 wrote:
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
We want to improve this. Do you have concrete suggestions to help us do what you say?
Also why didn't you pick the standalone distribution which has everything bundled (it's for beginning user)?
Thanks -Vincent
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%27XW...
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*".
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Best wishes,
许凌志(Jame Xu)
MOE KLINNS Lab and SKLMS Lab, Xi'an Jiaotong University
Department of Computer Science and Technology, Xi’an Jiaotong University
-- Best wishes, 许凌志(Jame Xu) MOE KLINNS Lab and SKLMS Lab, Xi'an Jiaotong University Department of Computer Science and Technology, Xi’an Jiaotong University
participants (4)
-
Sergiu Dumitriu -
Vincent Massol -
许凌志 -
许凌志(Jamesxu)