1.0beta2 cannot auto create some tables in Oracle 10
Hi everyone, Why can't I find the xwiki.hbm.xml file in 1.0B2 package? Am I required to create it by my self, or XWiki will provide one? Because once XWiki tried to recreate the tables, I got the error: [XWikiHibernateStore] Failed updating schema: ORA-01754: a table may contain only one column of type LONG It seems that we have to map some MySQL datatype to the proper Oracle type, in order to generate the proper DDL. Does anyone have a hbm.xml file that works with Oracle? Or what else need to be changed in the hibernate.cfg.xml? (I am using 10g JDBC driver) Best regards, Eric Sun -----Original Message----- From: Ludovic Dubost [mailto:[email protected]] Sent: Wed 1/18/2006 6:42 PM To: Eric Sun (Toronto) Subject: Re: Installation concerns for Oracle 10g Hi, You should post this to the users/dev lists. http://forge.objectweb.org/mail/?group_id=170 With XWiki 1.0B2 you should be able to run XWiki with an empty database (XWiki creates the tables automatically) and then try to import the ".xar" file available on xwiki.org into the XWiki running with the Oracle DB. Let us know how this works. Ludovic
Hi Eric, On Jan 21, 2007, at 5:44 AM, [email protected] wrote:
Hi everyone,
Why can't I find the xwiki.hbm.xml file in 1.0B2 package?
It's in the xwiki jar in the WEB-INF/lib of the xwiki WAR file.
Am I required to create it by my self, or XWiki will provide one?
XWiki provides one but it may not work OOB with all the different databases and may require tweakings.
Because once XWiki tried to recreate the tables, I got the error: [XWikiHibernateStore] Failed updating schema: ORA-01754: a table may contain only one column of type LONG
It seems that we have to map some MySQL datatype to the proper Oracle type, in order to generate the proper DDL.
Does anyone have a hbm.xml file that works with Oracle? Or what else need to be changed in the hibernate.cfg.xml?
(I am using 10g JDBC driver)
This is where I cannot help you much. I know some have been using XWiki with Oracle in the past. If someone can tell us what needs to be done we can put that information on the web site and try to provide configured files. Right now we're delivering a configuration that should work with MySQL and HSQLDB right away. There are some old information on http://old.xwiki.org/xwiki/bin/view/ AdminGuide/Oracle which we haven't migrated yet to the new xwiki.org web site. If someone can confirm they still work then I'll move them. Thanks -Vincent
-----Original Message----- From: Ludovic Dubost [mailto:[email protected]] Sent: Wed 1/18/2006 6:42 PM To: Eric Sun (Toronto) Subject: Re: Installation concerns for Oracle 10g
Hi,
You should post this to the users/dev lists. http://forge.objectweb.org/mail/?group_id=170
With XWiki 1.0B2 you should be able to run XWiki with an empty database (XWiki creates the tables automatically) and then try to import the ".xar" file available on xwiki.org into the XWiki running with the Oracle DB.
Let us know how this works.
Ludovic
-- You receive this message as a subscriber of the xwiki- [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/ wws
___________________________________________________________________________ Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface r�volutionnaire. http://fr.mail.yahoo.com
after changing all the "string" over 4K to "clob", my XWiki is able to create all 31 tables in Oracle now. I can publish the ddl @ http://docs.google.com/View?docid=ddqbx4zp_12s75qxw Here are all the 31 tables: xwikiattachment xwikiattachment_archive xwikiattachment_content xwikibooleanclasses xwikiclasses xwikiclassesprop xwikicomments xwikidateclasses xwikidates xwikidblistclasses xwikidoc xwikidoubles xwikifloats xwikiintegers xwikilargestrings xwikilinks xwikilistitems xwikilists xwikilock xwikilongs xwikinumberclasses xwikiobjects xwikipreferences xwikiproperties xwikislistclasses xwikistatsdoc xwikistatsreferer xwikistatsvisit xwikistringclasses xwikistrings xwikiusers ______________________________ Some java error here: Hibernate: /* insert com.xpn.xwiki.doc.XWikiDocument */ insert into xwikidoc (XWD_FULLNAME, XWD_NAME, XWD_TITLE, XWD_LANGUAGE, XWD_DEFAULT_LANGUAGE, XWD_TRANSLATION, XWD_DATE, XWD_CONTENT_UPDATE_DATE, XWD_CREATION_DATE, XWD_AUTHOR, XWD_CONTENT_AUTHOR, XWD_CREATOR, XWD_WEB, XWD_CONTENT, XWD_VERSION, XWD_CUSTOM_CLASS, XWD_PARENT, XWD_CLASS_XML, XWD_ELEMENTS, XWD_DEFAULT_TEMPLATE, XWD_VALIDATION_SCRIPT, XWD_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.CalendarEvent ...... Wrapped Exception: java.lang.String at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:310) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:96) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:90) Wrapped Exception: java.lang.ClassCastException: java.lang.String at org.hibernate.type.ClobType.set(ClobType.java:50) at org.hibernate.type.ClobType.nullSafeSet(ClobType.java:118) at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1826) at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1803) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2059) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51) ...... Hibernate: /* insert com.xpn.xwiki.doc.XWikiDocument */ insert into xwikidoc (XWD_FULLNAME, XWD_NAME, XWD_TITLE, XWD_LANGUAGE, XWD_DEFAULT_LANGUAGE, XWD_TRANSLATION, XWD_DATE, XWD_CONTENT_UPDATE_DATE, XWD_CREATION_DATE, XWD_AUTHOR, XWD_CONTENT_AUTHOR, XWD_CREATOR, XWD_WEB, XWD_CONTENT, XWD_VERSION, XWD_CUSTOM_CLASS, XWD_PARENT, XWD_CLASS_XML, XWD_ELEMENTS, XWD_DEFAULT_TEMPLATE, XWD_VALIDATION_SCRIPT, XWD_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: java.lang.String at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:310) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:96) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:90) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:750) at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:2010)
Hi Vincent, I modified all the type from string in xwiki.hbm.xml to CLOB if the size is > 4K, and from binary to BLOB if the size is > 4K. Then put the xml back into the xwiki.jar and delete all the tables in Oracle. Restart Tomcat, and now I get all tables created successfully. But it failed at saving CalendarEvent or reading XWikiPreferences. I am wondering if any developer can cast some light on this part. Maybe it is still a data type mapping issue for retreiving/saving CLOB/BLOB data. Thanks a lot _________________________________________________________________ Hibernate: select xwikidocum0_.XWD_ID as XWD1_0_0_, xwikidocum0_.XWD_ARCHIVE as XWD23_0_0_ from xwikidoc xwikidocum0_ where xwikidocum0_.XWD_ID=? 17:44:21,365 WARN http-80-1 http://localhost/xwiki/bin/view/Main/ WebHome JDBCExceptionReporter:logExceptions:71 - SQL Error: 17041, SQLState: null 17:44:21,365 ERROR http-80-1 http://localhost/xwiki/bin/view/Main/ WebHome JDBCExceptionReporter:logExceptions:72 - Missing IN or OUT parameter at index:: 1 com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.CalendarEvent Wrapped Exception: Error number 3212 in 3: Exception while loading archive XWiki.CalendarEvent Wrapped Exception: Error number 3212 in 3: Exception while loading archive -237,561,194 Wrapped Exception: could not load an entity: [com.xpn.xwiki.doc.XWikiDocumentArchive#-237561194] at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc (XWikiHibernateStore.java:310) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:96) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:90) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:750) at com.xpn.xwiki.plugin.calendar.CalendarPlugin.getCalendarEventClass (CalendarPlugin.java:83) at com.xpn.xwiki.plugin.calendar.CalendarPlugin.init (CalendarPlugin.java:332)
did anybody encounter such problem? the program tried to insert NULL to xwikidoc.xwd_title
Hi everyone, Does anybody get 1.0-b2 or 1.0-b3 work with Oracle database? My company's standard is Oracle, and MySQL is not supported in production env. Someone cast some light here, please? Thanks, E.
I published the modified xwiki.hbm.xml at http://docs.google.com/View?docid=ddqbx4zp_13g68r28 This mapping file can let xwiki generate all 31 tables in Oracle, but still can't read/write clob column correctly. Please help!
Does anyone have a suggestion on the best way to import many files at once? We are trying to migrate all of our legacy HTML docs into XWiki - is there a command line version of XAR that we can use to archive the docs and then import them? Thanks, -Greg
Hi Greg, On Jan 24, 2007, at 1:34 AM, <[email protected]> wrote:
Does anyone have a suggestion on the best way to import many files at once? We are trying to migrate all of our legacy HTML docs into XWiki - is there a command line version of XAR that we can use to archive the docs and then import them?
There is a command line version of the tool for importing/exporting XAR and XWiki documents in general. However it doesn't support importing HTML files right now, only XWiki XML files. This is a good idea for improvement though. Could you please create a JIRA issues for this? Also let us know if you're interested in contributing to this and I'll show you where the code is. Thanks -Vincent ___________________________________________________________________________ Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface r�volutionnaire. http://fr.mail.yahoo.com
participants (3)
-
feixingyu99＠hotmail.com -
greg_j_miller＠agilent.com -
Vincent Massol