Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. LudovicDubost1 +XWiki.VincentMassol - Content
-
... ... @@ -1,5 +1,9 @@ 1 1 1 Oracle Installation 2 2 3 +#toc("" "" "") 4 + 5 +1.1 Installation steps 6 + 3 3 #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") 4 4 5 5 Steps: ... ... @@ -28,6 +28,9 @@ 28 28 <property name="connection.pool_size">2</property> 29 29 <property name="statement_cache.size">2</property> 30 30 35 +<property name="hibernate.connection.SetBigStringTryClob">true</property> 36 +<property name="hibernate.jdbc.batch_size">0</property> 37 + 31 31 <mapping resource="xwiki.oracle.hbm.xml"/> 32 32 <mapping resource="feeds.oracle.hbm.xml"/> 33 33 {code} ... ... @@ -35,3 +35,32 @@ 35 35 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). 36 36 37 37 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. 45 + 46 +1.1 Troubleshooting 47 + 48 +First, make sure you're using the ~~xwiki.oracle.hbm.xml~~ and ~~feeds.oracle.hbm.xml~~ files (see above). 49 + 50 +1.1.1 SetString can only process strings of less than 32766 chararacters 51 + 52 +If you see an error that says something like: 53 + 54 +{code:none} 55 +Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences 56 +Wrapped Exception: could not update: [com.xpn.xwiki.doc.XWikiDocumentArchive#104408758] 57 +com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences 58 +Wrapped Exception: could not update: [com.xpn.xwiki.doc.XWikiDocumentArchive#104408758] 59 +... 60 +Wrapped Exception: 61 + 62 +java.sql.SQLException: setString can only process strings of less than 32766 chararacters 63 +... 64 +{code} 65 + 66 +Then that's because Oracle has a [limitation of 32K for CLOBs>http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/clob10g/handlingclobsinoraclejdbc10g.html#how1]. To overcome it you need to add the following 2 properties in the <tt>hibernate.cfg.xml</tt> file, as specified in the installation steps section above: 67 + 68 +{code} 69 +<property name="hibernate.connection.SetBigStringTryClob">true</property> 70 +<property name="hibernate.jdbc.batch_size">0</property> 71 +{code} 72 + 73 +