Oracle Installation

Installation steps

Warning: Oracle support is available in XWiki 1.0 RC1 and above only and has been tested only with Oracle Express 10g 10.0.2.3

Steps: 

"connect system;" (type the password)
  • Create the wiki database:
"create user xwiki identified by xwiki;"
  • Give all privileges to the xwiki user:
"grant all privileges to xwiki;"
  • Tell XWiki to use Oracle Express. To do this, edit the WEB-INF/hibernate.cfg.xml file where you have expanded the XWiki WAR file. Replace the matching properties with the following ones (or uncomment them if they are present):
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwiki</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="dialect">org.hibernate.dialect.OracleDialect</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>
<!-- Tell Oracle to allow CLOBs larger than 32K -->
<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"/>

Note 1: 'XE' is the default name of the ORACLE SID created by default by the installation. If it is another you should change it. You can find the correct SID in app/oracle/product/10.2.0/server/NETWORK/ADMIN/tnsnames.ora in the Oracle installation directory (for Windows).

Note 2: The xwiki.oracle.hbm.xml and feeds.oracle.hbm.xml files are modified hibernate models working with Oracle. We are not using them as default models for other Database because they might create some columns with incorrect types for these databases. Do not use them with other databases.

Troubleshooting

First, make sure you're using the xwiki.oracle.hbm.xml and feeds.oracle.hbm.xml files (see above).

SetString can only process strings of less than 32766 chararacters

If you see an error that says something like:

Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences
Wrapped Exception: could not update: [com.xpn.xwiki.doc.XWikiDocumentArchive#104408758]
com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences
Wrapped Exception: could not update: [com.xpn.xwiki.doc.XWikiDocumentArchive#104408758]
...
Wrapped Exception:
java.sql.SQLException: setString can only process strings of less than 32766 chararacters
...

Then that's because Oracle has a limitation of 32K for CLOBs. To overcome it you need to add the following 2 properties in the hibernate.cfg.xml file, as specified in the installation steps section above:

<property name="hibernate.connection.SetBigStringTryClob">true</property>
<property name="hibernate.jdbc.batch_size">0</property>

Version 1.10 last modified by VincentMassol on 10/04/2008 at 16:35

Comments 1

JosueSantos | 10.04.2008 at 04:35 PM
In the release notes for the version 1.3.X that was released in March 2008 says that it has better support for Oracle. This entry here showing how to configure a oracle DB is up to date with this better support?

Thanks

Attachments 0

No attachments for this document
Creator: VincentMassol on 2007/04/16 11:02
This wiki is licensed under a Creative Commons license
1.3.2.9174