On Mon, Oct 17, 2011 at 4:19 PM, shouldbe q931 <shouldbeq931(a)gmail.com> wrote:
  On Mon, Oct 17, 2011 at 3:39 PM, Eugen Colesnicov
<ecolesnicov(a)gmail.com> wrote:
  Hi Oracle users!
 My environment: Windows2003, Glassfish 3.1.1, OracleXE 10.2
 Today I tried to upgrade XE from 3.1 to 3.2 and on first-time loading I got
 error:
 javax.servlet.ServletException: 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: $Proxy148 cannot be cast to oracle.sql.CLOB
 ...
 I created a jira issue: 
http://jira.xwiki.org/browse/XE-1032 with detailed
 description and full log.
 Maybe somebody tried upgrade on OracleXE? What results you get (maybe its
 only my problem)?
 --
 Best regards
 Eugen Colesnicov
 -- 
 I'm seeing something rather similar. The environment is Ubuntu 10.01
 32bit, tomcat6 Oracle 10g (10.2)
 ---------------------------------------------------------------------------
 HTTP Status 500 -
 type Exception report
 message
 description The server encountered an internal error () that prevented
 it from fulfilling this request.
 exception
 javax.servlet.ServletException: 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: $Proxy64 cannot be cast to oracle.sql.CLOB
      
 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:617)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128)
      
 org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144)
        com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
      
 org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217)
      
 org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
 ---------------------------------------------------------------------------
 xwiki.cfg has been edited to change the original default from albatros
 to colibri, apart from that, the hibernate.cfg.xml, xwiki.cfg and
 xwiki.properties files are as per 3.1.1, the ojdbc14.jar is as also
 just copied from the 3.1.1 directory.
 hibernate Oracle section is as below
 ---------------------------------------------------------------------------
    <property
name="connection.url">jdbc:oracle:thin:@<redacted>:1521:orcl1</property>
    <property name="connection.username">xwiki</property>
    <property name="connection.password"><redacted></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"/>
 ---------------------------------------------------------------------------