Hi,

My DB guys got the mysql database across and now when I try to access it, it displays part of the page with errors in the middle. The error starts with:

Error number 3202 in 3: Exception while reading document Main.WebHome
Wrapped Exception: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false 
for more info) setter of com.xpn.xwiki.doc.XWikiDocument.setParent
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document Main.WebHome

and in the xwiki.log file I get:

XWikiHibernateStore:updateSchema:172 - Schema update deactivated for wiki xwiki
ORA-00932: inconsistent datatypes: expected - got CLOB

Makes no difference if I use your xwiki.hbm.xml or the default one. How can I find out which table/field its having problems with?

Vic

----- Original Message ----
From: Victor Orgos <v_orgos@yahoo.com.au>
To: xwiki-users@objectweb.org
Sent: Friday, 24 November, 2006 5:41:46 PM
Subject: Re: [xwiki-users] xwiki & oracle 10g R2

Thanks for clearing that up John. I got our Oracle/SQL guru involved and he tells me that there is a program to convert the MySQL data to Oracle. So we'll give that a go.

Regards,

Vic

----- Original Message ----
From: "Turner, John" <John.Turner3@team.telstra.com>
To: xwiki-users@objectweb.org
Sent: Friday, 24 November, 2006 1:37:36 PM
Subject: RE: [xwiki-users] xwiki & oracle 10g R2

Vic,

You need to seed your database with the data that is shipped for the
XWiki MySQL database.  If you haven't done that it could explain why you
get nothing when you fire up the application.  The seed data includes
stuff like the admin user and admin pages, etc.

There is a database script that I think you can download separately from
the XWiki site.  It will insert the seed data into a MySQL database.
You some how need to get that data into your Oracle DB.  I had to load
the data into a MySQL database and then write a program that copied the
data to my Oracle 9i DB (unfortunately I can't release my program, or a
copy of my data to you).  You'll have to come up with some strategy for
doing something similar - maybe you can edit the script to make it
insert into a 10g DB?

One other point is that the Oracle 9i JDBC thin driver had a limitation
on the size of LOBs it could handle - that's why I used the thick
driver.  You need an Oracle client install on your application server in
order to use the thick driver.  This may no longer be an issue with the
Oracle 10g JDBC driver.

Regards, John

________________________________

From: Victor Orgos [mailto:v_orgos@yahoo.com.au]
Sent: Friday, 24 November 2006 10:52 AM
To: xwiki-users@objectweb.org
Subject: [xwiki-users] 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.DBCPConnectionProvi
der</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

--
You receive this message as a subscriber of the xwiki-users@objectweb.org mailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

Send instant messages to your online friends http://au.messenger.yahoo.com