Hello Thomas, thank you for your reply. You're right. I checked my installation guide of February 2011 and I created the database without setting the default character set. Because at that the time this information was missing in the guide. This must have been added after my installation in 2011. Since then we merged to version 3 and a few weeks ago to version 4.2 Milestone 2. Is it possible to fix that ptoblem and how can I do that?
Thank you in advance. > Date: Fri, 14 Sep 2012 09:31:11 +0200 > From: thomas.morta...@xwiki.com > To: users@xwiki.org > Subject: Re: [xwiki-users] Problems saving special charachters: Error 3201 > > On Fri, Sep 14, 2012 at 8:49 AM, Enzo Promatiker <promati...@live.de> wrote: > > > > > > Hello everybody, > > > > we have problems when our users want to save special characters like the > > polish "Ż" (https://secure.wikimedia.org/wikipedia/en/wiki/%C%%BB) in a > > xwiki page. We are currently using Xwiki .. Milestone with an mysql > > database. And as far as I can ascertain, all parameters are set to UTF-8. > > The mysql tables seem to be also UTF-8 encoded. But we are still getting > > this error here: > > > > Error number 3201 in 3: Exception while saving document xwiki:EDV.Office2010 > > Wrapped Exception: Failed to commit or rollback transaction. Root cause [] > > com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while > > saving document xwiki:EDV.Office2010 > > Wrapped Exception: Failed to commit or rollback transaction. Root cause [] > > at > > com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:698) > > at > > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:177) > > at > > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:170) > > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1358) > > at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:163) > > at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:180) > > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:230) > > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) > > 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.doPost(ActionServlet.java:432) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > > 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:120) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) > > 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:208) > > 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:111) > > 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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) > > at > > org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) > > at > > org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) > > at > > org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) > > at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:110) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:141) > > 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:66) > > 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:208) > > 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:111) > > 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:636) > > Caused by: org.hibernate.HibernateException: Failed to commit or rollback > > transaction. Root cause [] > > at > > com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:924) > > at > > com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:688) > > ... 56 more > > Caused by: org.hibernate.exception.GenericJDBCException: Could not execute > > JDBC batch update > > at > > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) > > at > > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) > > at > > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) > > at > > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) > > at > > org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114) > > at > > org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) > > at > > org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244) > > at > > org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2541) > > at > > org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2494) > > at > > org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2821) > > at > > org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113) > > at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273) > > at > > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265) > > at > > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185) > > at > > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) > > at > > org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) > > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) > > at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) > > at > > org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) > > at > > com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:917) > > ... 57 more > > Caused by: java.sql.BatchUpdateException: Incorrect string value: > > '\xC5\xBB\x0A\x0AAu...' for column 'XWR_PATCH' at row 1 > > at > > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2024) > > at > > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449) > > 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:70) > > at > > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) > > ... 73 more > > Caused by: java.sql.SQLException: Incorrect string value: > > '\xC5\xBB\x0A\x0AAu...' for column 'XWR_PATCH' at row 1 > > This error generally indicates that you did not created the MySQL > database for XWiki with utf8 character set while XWiki is configured > by default to communicate with MySQL in utf8. > > Did you looked at > http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL#HInstallationSteps > ? > > > > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) > > at > > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) > > at > > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415) > > at > > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1976) > > ... 79 more > > > > > > Wrapped Exception: > > > > org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch > > update > > at > > org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) > > at > > org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) > > at > > org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) > > at > > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) > > at > > org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114) > > at > > org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) > > at > > org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244) > > at > > org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2541) > > at > > org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2494) > > at > > org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2821) > > at > > org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113) > > at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273) > > at > > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265) > > at > > org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185) > > at > > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) > > at > > org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) > > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) > > at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) > > at > > org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) > > at > > com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:917) > > at > > com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:688) > > at > > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:177) > > at > > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:170) > > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1358) > > at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:163) > > at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:180) > > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:230) > > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) > > 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.doPost(ActionServlet.java:432) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > > 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:120) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) > > 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:208) > > 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:111) > > 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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646) > > at > > org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) > > at > > org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) > > at > > org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) > > at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:110) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > > org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:141) > > 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:66) > > 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:208) > > 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:111) > > 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:636) > > Caused by: java.sql.BatchUpdateException: Incorrect string value: > > '\xC5\xBB\x0A\x0AAu...' for column 'XWR_PATCH' at row 1 > > at > > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2024) > > at > > com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449) > > 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:70) > > at > > org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) > > ... 73 more > > Caused by: java.sql.SQLException: Incorrect string value: > > '\xC5\xBB\x0A\x0AAu...' for column 'XWR_PATCH' at row 1 > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603) > > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535) > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989) > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150) > > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) > > at > > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) > > at > > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415) > > at > > com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1976) > > ... 79 more > > > > _______________________________________________ > > users mailing list > > users@xwiki.org > > http://lists.xwiki.org/mailman/listinfo/users > > > > -- > Thomas Mortagne > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
