21 Jan
2007
21 Jan
'07
5:44 a.m.
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:ludovic@xwiki.org]
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
21 Jan
21 Jan
8:23 a.m.
New subject: [xwiki-users] 1.0beta2 cannot auto create some tables in Oracle 10
Hi Eric,
On Jan 21, 2007, at 5:44 AM, feixingyu99(a)hotmail.com 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:ludovic@xwiki.org]
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-
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
___________________________________________________________________________
Yahoo! Mail r�invente le mail ! D�couvrez le nouveau Yahoo! Mail et son interface
r�volutionnaire.
http://fr.mail.yahoo.com
23 Jan
23 Jan
11:55 p.m.
New subject: 31 XWiki tables created in Oracle, but cannot read/write clob column
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)
8:22 p.m.
New subject: Some progress: still cannot read/write CLOB column in Oracle 10
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)
30 Jan
30 Jan
4:27 a.m.
New subject: CLOB column in Oracle 10 is alright, but it tried to insert NULL to XWD_TITLE
did anybody encounter such problem?
the program tried to insert NULL to xwikidoc.xwd_title
2 Feb
2 Feb
3:46 p.m.
New subject: CLOB column in Oracle 10 is alright, but it tried to insert NULL to 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.
24 Jan
24 Jan
12:03 a.m.
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!
1:34 a.m.
New subject: Migrating many HTML files
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
25 Jan
25 Jan
9:05 a.m.
New subject: [xwiki-users] Migrating many HTML files
Hi Greg,
On Jan 24, 2007, at 1:34 AM, <greg_j_miller(a)agilent.com> 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
6436
days inactive
6448
days old
8 comments
3 participants
participants (3)
-
feixingyu99＠hotmail.com -
greg_j_miller＠agilent.com -
Vincent Massol