xwiki & oracle 10g R2

Hi, I am attempting to get xwiki (version 0-9-840) to work with Oracle 10g R2 and I'm stuck. My DBA has created the user and loaded the schema. I'm using the ojdbc14.jar that comes with this version of Oracle. When I try to access http://localhost:8080/xwiki/bin/view/Main/WebHome with the following settings: <property name="connection.url">jdbc:oracle:thin:@localhost:1521:vicdev</property> <property name="connection.username">wiki</property> <property name="connection.password">itadmin</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">50</property> <property name="statement_cache.size">50</property> <property name="dialect">org.hibernate.dialect.OracleDialect</property> it fails with the following in the logs: 12:32:11,861 WARN http-8080-Processor25 RequestUtils:createActionForm:177 - No FormBeanConfig found under 'view' 12:32:13,968 WARN http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers Configurator:configure:126 - No c onfiguration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: file:/usr/local/jakarta-tomcat-5.0.28/work /Catalina/localhost/xwiki/loader/ehcache-failsafe.xml 12:32:16,657 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:updateSchema: 177 - Schema update for wiki xwiki 12:32:19,766 WARN http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCExceptionReporter:logExceptio ns:71 - SQL Error: 932, SQLState: 42000 12:32:19,768 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCExceptionReporter:logExceptio ns:72 - ORA-00932: inconsistent datatypes: expected - got CLOB When I saw the ORA-00932 error, I found John Turner's String2 java class and configuration files in an earlier thread. I've since compiled the class and created a jar which I've placed in WEB-INF/lib/ directory. This didn't work and I got an error about the connection URL <property name="connection.url">jdbc:oracle:oci:@localhost:1521:vicdev</property> I changed this back to thin instead and now xwiki can connect successfully to the database. BUT nothing happens! Browser says loading and nothing much else happens. Its very frustrating. I've been trying to get this to work for the last 4 days with no luck. - Do I need to make any configuration changes to Tomcat after installation? - There has been talk in the list about importing a MySQL dump into Oracle to get this working, but no mention of this in the xwiki.org site. I'd appreciate any help to get this working. Regards, Vic Send instant messages to your online friends http://au.messenger.yahoo.com