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