XWiki Platform

Invalid mapping with Oracle 11g and Hibernate 3.6

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Blocker Blocker
  • Resolution: Fixed
  • Affects Version/s: 3.2, 3.3-rc-1
  • Fix Version/s: 3.3, 3.4-milestone-1, 3.2.1
  • Component/s: Storage
  • Labels:
    None
  • Environment:
    Windows Server 2008 R2 x64, Oracle Enterprise 11g
  • keywords:
    oracle
  • Difficulty:
    Unknown
  • Similar issues:
    XWIKI-5576Upgrade to Hibernate 3.6.4.Final
    XWIKI-6685Configure extra indexes in the hibernate mapping file for improved performance
    XWIKI-6521JNDI options for hibernate in Oracle do not work
    XWIKI-6606Upgrade to a recent version of hibernate
    XWIKI-838XWiki cannot handle Oracle CLOB/BLOB properly via Hibernate
    XWIKI-2038Use "text" instead of "string" in the hibernate mapping, where appropriate
    XWIKI-2047DB2 Hibernate Mapping for 1.2
    XWIKI-5389DB2 Hibernate Mapping for 2.4
    XWIKI-9019Unable to delete attachments, rename documents and delete documents from Main wiki on Oracle 11G R2
    XWIKI-2355Hibernate queries not working with Oracle 9

Description

It seems that starting with the Hibernate upgrade after 3.1.1 (from Hibernate 3.2.6 to 3.6.7 Final) there is a incompatibility between Hibernate and Oracle. It seems that some Oracle constraints are violated or some wrong data types are used by Hibernate to create the database in Oracle.

I tested 3.1.1 which uses Hibernate 3.2.6 and it works.
But 3.2 and 3.3 RC1 (Hibernate 3.6.7 Final) don't work

Steps to reproduce the issue:

  • Install Oracle DB, create user xwiki, grant all privileges to xwiki;
  • modify the hiernate.cfg.xml to point to the Oracle DB
  • put the Oracle JDBC driver in libs
  • Start the Wiki
  • You will get a stacktrace as in "Vanilla_first_run_error.txt" attached to the issue

Workaround found:

  • rename the "xwiki.oracle.hbm.xml_MODIFIED" and "feeds.oracle.hbm.xml_MODIFIED" to "xwiki.oracle.hbm.xml" and "feeds.oracle.hbm.xml" (originally found in xwiki-platform-legacy-oldcore-3.3-rc-1) and put them in /WEB-INF/classes
  • you also might want to set logging to "debug" in logback.xml
  • below I have attached the original "xwiki.oracle.hbm.xml" and "feeds.oracle.hbm.xml" as along with the modified versions (that work) + also 2 diff files between the original and modified ones.
  • start the xwiki and check "Modified_first_run.txt" for the stack trace. The wiki starts, I am able to import the XAR, and I also briefly tested to see if I get any breakages. Note that with the files attached, I get a lot of console messages, indicating there might be other underlying issues, or maybe some logger leftovers left enabled.

This might be similar or even identical to XWIKI-7107

I have also attached some Jetty logs in different stages until it worked. You can see there Oracle complaining about data types which it doesn't like
Also, see attached diffs and jetty logs to different stages to see different places where Oracle complained about data types.

THE DIFF FILES ARE NOT PATCHES, they only illustrate a possible (but less probable) way to make it work. They come aiding a developer to fix the issue.

  1. XML File
    feeds.oracle.hbm.xml
    08/Dec/11 16:59
    4 kB
    Sorin Burjan
  2. File
    feeds.oracle.hbm.xml_MODIFIED
    08/Dec/11 16:59
    4 kB
    Sorin Burjan
  3. File
    feeds.oracle.hbm.xml.diff
    08/Dec/11 16:59
    1 kB
    Sorin Burjan
  4. Text File
    jetty2.log
    08/Dec/11 17:02
    28 kB
    Sorin Burjan
  5. Text File
    jetty3.log
    08/Dec/11 17:02
    28 kB
    Sorin Burjan
  6. Text File
    jetty4.log
    08/Dec/11 17:02
    150 kB
    Sorin Burjan
  7. Text File
    jetty5.log
    08/Dec/11 17:02
    129 kB
    Sorin Burjan
  8. Text File
    jetty6.log
    08/Dec/11 17:02
    5.56 MB
    Sorin Burjan
  9. XML File
    logback.xml
    08/Dec/11 17:00
    3 kB
    Sorin Burjan
  10. Text File
    Modified_first_run.txt
    08/Dec/11 17:01
    2.47 MB
    Sorin Burjan
  11. File
    Vanilla_first_run_error
    08/Dec/11 17:01
    20 kB
    Sorin Burjan
  12. XML File
    xwiki.oracle.hbm.xml
    08/Dec/11 17:00
    26 kB
    Sorin Burjan
  13. File
    xwiki.oracle.hbm.xml_MODIFIED
    08/Dec/11 17:00
    27 kB
    Sorin Burjan
  14. File
    xwiki.oracle.hbm.xml.diff
    08/Dec/11 17:00
    2 kB
    Sorin Burjan

Issue Links

is duplicated by

Bug - A problem which impairs or prevents the functions of the product. XE-1032 Error at first-time starting after upgrade to XE 3.2: $Proxy148 cannot be cast to oracle.sql.CLOB

  • Critical - Crashes, loss of data, severe memory leak.
  • Closed - The issue is considered finished, the resolution is correct and has been pushed to production. Issues which are not closed can be reopened.

Bug - A problem which impairs or prevents the functions of the product. XWIKI-7107 Installation fails on ORACLE 10.2 with Error ORA-01754

  • Major - Major loss of function.
  • Closed - The issue is considered finished, the resolution is correct and has been pushed to production. Issues which are not closed can be reopened.
is related to

Bug - A problem which impairs or prevents the functions of the product. XWIKI-5759 Error at first-time importing xar-file: ORA-01400: cannot insert NULL into ("XWIKI"."XWIKILARGESTRINGS"."XWL_ID") s

  • Critical - Crashes, loss of data, severe memory leak.
  • Closed - The issue is considered finished, the resolution is correct and has been pushed to production. Issues which are not closed can be reopened.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Vincent Massol added a comment -

Applied with more documentation and small changes.

One thing I still need to sort out is why using the following doesn't work:

<typedef name="materialized_clob" class="org.hibernate.type.MaterializedClobType" />

since StringClobType is deprecated, see http://docs.jboss.org/hibernate/core/3.5/javadoc/org/hibernate/type/StringClobType.html

I still get the following class cast:

java.lang.ClassCastException: $Proxy47 cannot be cast to oracle.sql.CLOB
	at oracle.jdbc.driver.OraclePreparedStatement.setClob(OraclePreparedStatement.java:6926)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187)
Show
Vincent Massol added a comment - Applied with more documentation and small changes. One thing I still need to sort out is why using the following doesn't work: <typedef name="materialized_clob" class="org.hibernate.type.MaterializedClobType" /> since StringClobType is deprecated, see http://docs.jboss.org/hibernate/core/3.5/javadoc/org/hibernate/type/StringClobType.html I still get the following class cast: java.lang.ClassCastException: $Proxy47 cannot be cast to oracle.sql.CLOB at oracle.jdbc.driver.OraclePreparedStatement.setClob(OraclePreparedStatement.java:6926) at org.apache.commons.dbcp.DelegatingPreparedStatement.setClob(DelegatingPreparedStatement.java:187)
Hide
Permalink
Sergiu Dumitriu added a comment -

https://hibernate.onjira.com/browse/HHH-5659 suggests that hibernate.jdbc.use_streams_for_binary=true should be used to solve the classcast exception.

Show
Sergiu Dumitriu added a comment - https://hibernate.onjira.com/browse/HHH-5659 suggests that hibernate.jdbc.use_streams_for_binary=true should be used to solve the classcast exception.
Hide
Permalink
Vincent Massol added a comment - - edited

I've tried using:

<property name="hibernate.jdbc.use_streams_for_binary">true</property>

And I've removed the typedef (actually I've also tried to keep the typedef but use MaterializedClobType instead of StringClobType).

And I get the following error:

2011-12-10 09:33:51,339 [http://localhost:8080/xwiki/bin/import/XWiki/XWikiPreferences?editor=globaladmin&section=Import] ERROR c.x.x.p.s.SchedulerPlugin      - Failed to restore job with in document [[Scheduler.WatchListHourlyNotifier, xwiki]] and wiki [com.xpn.xwiki.plugin.scheduler.SchedulerPluginException: Error number 90006 in 5: Exception in plugin [com.xpn.xwiki.plugin.scheduler.SchedulerPlugin]: Error while saving job status for job : WatchList hourly notifier
Wrapped Exception: Error number 90011 in 5: Exception in plugin [com.xpn.xwiki.plugin.scheduler.SchedulerPlugin]: Failed to prepare context for job with job name WatchList hourly notifier
Wrapped Exception: Error number 3201 in 3: Exception while saving document xwiki:Scheduler.WatchListHourlyNotifier
Wrapped Exception: $Proxy46 cannot be cast to oracle.sql.CLOB]

According to https://hibernate.onjira.com/browse/HHH-5659?focusedCommentId=39801&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-39801 I think it's not necessary to add this property (if I read it correctly).

Show
Vincent Massol added a comment - - edited I've tried using: <property name="hibernate.jdbc.use_streams_for_binary">true</property> And I've removed the typedef (actually I've also tried to keep the typedef but use MaterializedClobType instead of StringClobType). And I get the following error: 2011-12-10 09:33:51,339 [http://localhost:8080/xwiki/bin/import/XWiki/XWikiPreferences?editor=globaladmin&section=Import] ERROR c.x.x.p.s.SchedulerPlugin - Failed to restore job with in document [[Scheduler.WatchListHourlyNotifier, xwiki]] and wiki [com.xpn.xwiki.plugin.scheduler.SchedulerPluginException: Error number 90006 in 5: Exception in plugin [com.xpn.xwiki.plugin.scheduler.SchedulerPlugin]: Error while saving job status for job : WatchList hourly notifier Wrapped Exception: Error number 90011 in 5: Exception in plugin [com.xpn.xwiki.plugin.scheduler.SchedulerPlugin]: Failed to prepare context for job with job name WatchList hourly notifier Wrapped Exception: Error number 3201 in 3: Exception while saving document xwiki:Scheduler.WatchListHourlyNotifier Wrapped Exception: $Proxy46 cannot be cast to oracle.sql.CLOB] According to https://hibernate.onjira.com/browse/HHH-5659?focusedCommentId=39801&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-39801 I think it's not necessary to add this property (if I read it correctly).
Hide
Permalink
Vincent Massol added a comment - - edited

Note: I've tested this new mapping on Oracle 10g Express 10.2.0.1.0 and JDBC Driver 10.2.0.1.0

Show
Vincent Massol added a comment - - edited Note: I've tested this new mapping on Oracle 10g Express 10.2.0.1.0 and JDBC Driver 10.2.0.1.0
Hide
Permalink
Vincent Massol added a comment -

Note that the 2 pages don't fail anymore after upgrading from JDBC driver 10.2.0.1.0 to 10.2.0.2!

Show
Vincent Massol added a comment - Note that the 2 pages don't fail anymore after upgrading from JDBC driver 10.2.0.1.0 to 10.2.0.2!

People

  • Assignee:
    Vincent Massol
    Reporter:
    Sorin Burjan
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
    Date of First Response: