RE: [xwiki-users] xwiki & oracle 10g R2

Vic, XWiki uses Hibernate in the object/relational mapping layer. It looks like the mapping - xwiki.hbm.xml - has mapped an Oracle data type to a Java data type that the JDBC driver cannot support. There is some good Hibernate documentation at http://www.hibernate.org/hib_docs/v3/reference/en/html/. You can alter the log level by changing the log4j.properties file - the Hibernate doco mentioned before has information on the Hibernate logging options. I think you need to find a mapping that supports Oracle CLOBs and Java Strings - I haven't used the Oracle 10g JDBC driver so cannot offer any advice on a mapping that works. Regards, John ________________________________ From: Victor Orgos [mailto:v_orgos@yahoo.com.au] Sent: Tuesday, 28 November 2006 4:07 PM To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] xwiki & oracle 10g R2 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 &lt;v_orgos(a)yahoo.com.auTo: xwiki-users(a)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" &lt;John.Turner3(a)team.telstra.comTo: xwiki-users(a)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(a)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(a)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 -- You receive this message as a subscriber of the xwiki-users(a)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