20 Mar
2011
20 Mar
'11
1:14 p.m.
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
20 Mar
20 Mar
1:43 p.m.
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%27X…
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
1:55 p.m.
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 <vincent(a)massol.net>
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%27X…
suggest an issue with the driver you're using.
Hope to helps,
-Vincent
On Mar 20, 2011, at 1:14 PM, 许凌志 wrote:
--
Best wishes,
许凌志
MOE KLINNS Lab and SKLMS Lab, Xi'an Jiaotong University
Department of Computer Science and Technology, Xi’an Jiaotong University
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
> users(a)xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
1:58 p.m.
New subject: [xwiki-users] Improving doc for beginners (was Re: Have error when install XWIKI v3)
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 <vincent(a)massol.net>
> 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%27X…
> 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]
2:04 p.m.
New subject: [xwiki-users] Improving doc for beginners (was Re: Have error when install XWIKI v3)
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 <vincent(a)massol.net>
On Mar 20, 2011, at 1:55 PM, 许凌志 wrote:
--
Best wishes,
许凌志
MOE KLINNS Lab and SKLMS Lab, Xi'an Jiaotong University
Department of Computer Science and Technology, Xi’an Jiaotong University
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
<vincent(a)massol.net>
> 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%27X…
> 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
11:29 p.m.
New subject: [xwiki-users] Improving doc for beginners (was Re: Have error when install XWIKI v3)
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<vincent(a)massol.net>
>
> 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<vincent(a)massol.net>
>>
>>> 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%27X…
>>> 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/
21 Mar
21 Mar
2:22 a.m.
New subject: [xwiki-users] Improving doc for beginners (was Re: Have error when install XWIKI v3)
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 <sergiu(a)xwiki.com> wrote:
On 03/20/2011 02:04 PM, 许凌志 wrote:
--
Best wishes,
许凌志(Jame Xu)
MOE KLINNS Lab and SKLMS Lab, Xi'an Jiaotong University
Department of Computer Science and Technology, Xi’an Jiaotong University
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<vincent(a)massol.net>
>
> 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<vincent(a)massol.net>
>>
>>> 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%27X…
>>> 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
3:39 a.m.
New subject: [xwiki-users] Improving doc for beginners (was Re: Have error when install XWIKI v3)
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 <sergiu(a)xwiki.com> wrote:
--
Best wishes,
许凌志(Jame Xu)
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:
--
Best wishes,
许凌志(Jame Xu)
MOE KLINNS Lab and SKLMS Lab, Xi'an Jiaotong University
Department of Computer Science and Technology, Xi’an Jiaotong University
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<vincent(a)massol.net>
>
> 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<vincent(a)massol.net>
>>
>>> 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%27X…
>>> 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
5025
days inactive
5026
days old
7 comments
4 participants
participants (4)
-
Sergiu Dumitriu -
Vincent Massol -
许凌志 -
许凌志(Jamesxu)