On Mon, Oct 17, 2011 at 3:39 PM, Eugen Colesnicov <[email protected]> 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"/> ---------------------------------------------------------------------------

shouldbe q931 wrote

On Mon, Oct 17, 2011 at 3:39 PM, Eugen Colesnicov <ecolesnicov@> wrote:

...

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

The same issue on upgrade 3.1 -> 3.2. I also tried to deploy 3.2.war as a new installation and got the same exception - "Exception while saving document xwiki:XWiki.XWikiPreferences Wrapped Exception: $Proxy89 cannot be cast to oracle.sql.CLOB" Envinroment: WindowsXP, Tomcat, Oracle 10.2 Best Regards, Alla ----- Best Regards, Alla -- View this message in context: http://xwiki.475771.n2.nabble.com/XE-Upgrade-to-3-2-on-Oracle-failed-tp69008... Sent from the XWiki- Users mailing list archive at Nabble.com.

Unfortunatly, XE 3.3 Millestone 2 have same bug with Oracle. -- View this message in context: http://xwiki.475771.n2.nabble.com/XE-Upgrade-to-3-2-on-Oracle-failed-tp69008... Sent from the XWiki- Users mailing list archive at Nabble.com.