17 Oct
2011
17 Oct
'11
5:19 p.m.
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"/>
---------------------------------------------------------------------------