On Mon, Oct 17, 2011 at 4:19 PM, shouldbe q931 <[email protected]> wrote:
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"/> ---------------------------------------------------------------------------
I've added a few files to the JIRA...