Uploaded image for project: '{RETIRED} XWiki Workspaces'
  1. {RETIRED} XWiki Workspaces
  2. XWS-112

Installing XWiki Workspaces with Oracle 10g Enterprise Edition Release 10.2.0.3.0

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Blocker
    • None
    • 1.0
    • Other
    • None
    • Unix
      jboss_4.0.3SP1
      Oracle 10g Enterprise Edition Release 10.2.0.3.0.
    • Oracle 10g

    Description

      Error while Installing XWIki Workspaces with Oracle 10g Enterprise Edition Release 10.2.0.3.0.

      I dowloaded xwiki-workspaces-web-1.0.war and installed on jboss_4.0.3SP1.
      It works find with MYSQL but my DB guys can't install it on Oracle 10g.

      hibernate.cfg.xml :

      <property name="connection.url">jdbc:oracle:thin:@localhost:1521:MYSID</property>
      <property name="connection.username">xwiki</property>
      <property name="connection.password">xwiki</property>
      <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
      <property name="dialect">org.hibernate.dialect.Oracle10gDialect</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>
      <property name="hibernate.connection.SetBigStringTryClob">true</property>
      <property name="hibernate.jdbc.batch_size">0</property>
      <mapping resource="xwiki.oracle.hbm.xml"/>
      <mapping resource="feeds.oracle.hbm.xml"/>
      <mapping resource="activitystream.hbm.xml"/>

      Browser error:
      HTTP Status 500

      exception

      javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki context
      Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences
      Wrapped Exception: could not insert: [com.xpn.xwiki.doc.XWikiDocument]
      org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
      org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
      org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
      org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
      org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)

      root cause

      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.XWikiPreferences
      Wrapped Exception: could not insert: [com.xpn.xwiki.doc.XWikiDocument]
      com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:303)
      com.xpn.xwiki.XWiki.getXWiki(XWiki.java:491)
      com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:123)
      org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
      org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
      org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
      org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
      11:35:23,913 ERROR [JDBCExceptionReporter] Data size bigger than max size for th
      is type: 4210
      11:35:23,913 ERROR [AbstractFlushingEventListener] Could not synchronize databas
      e state with session
      org.hibernate.exception.GenericJDBCException: could not insert: [com.xpn.xwiki.d
      oc.XWikiDocument]
      at org.hibernate.exception.SQLStateConverter.handledNonSpecificException
      (SQLStateConverter.java:103)
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
      ava:91)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
      er.java:43)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
      tEntityPersister.java:2267)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
      tEntityPersister.java:2660)
      at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.ja
      va:56)
      at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
      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:783)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:754)
      at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:447)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
      at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1083)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1056)
      at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1050)
      at com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractXClassManager.checkClassDocument(AbstractXClassManager.java:402)
      at com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractXClassManager.check(AbstractXClassManager.java:368)
      at com.xpn.xwiki.plugin.applicationmanager.doc.XWikiApplicationClass.getInstance(XWikiApplicationClass.java:260)
      at com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.getApplicationList(ApplicationManager.java:184)
      at com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.updateAllApplicationTranslation(ApplicationManager.java:378)
      at com.xpn.xwiki.plugin.applicationmanager.ApplicationManagerPlugin.init(ApplicationManagerPlugin.java:92)
      at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:146)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:76)
      at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:107)
      at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:858)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:786)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:722)
      at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:293)
      at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:491)
      at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:123)
      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:697)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      at java.lang.Thread.run(Thread.java:595)
      Caused by: java.sql.SQLException: Data size bigger than max size for this type: 4210
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:155)
      at oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2531)
      at oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1248)
      at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:1690)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)
      at org.hibernate.type.StringType.set(StringType.java:26)
      at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136)
      at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:107)
      at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1997)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2243)
      ... 61 more

      We have tried every solutions provided at http://jira.xwiki.org/jira/browse/XWIKI-838 but we still have the problem.

      Thanks for your Help.
      Charles

      Attachments

        Activity

          People

            vmassol Vincent Massol
            jc.dus78dev Charles BAUD
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: