Changes for page Oracle Installation

Last modified by Vincent Massol on 2023/12/07

<
From version < 1.6 >
edited by Ludovic Dubost
on 2007/04/16
To version < 1.7 >
edited by Vincent Massol
on 2007/09/25
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.LudovicDubost
1 +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 +

Get Connected