I see,
You are building 1.2 and the oracle hbm files are probably not up to=20
date for the 1.2 store changes.
You might want to try with 1.1 or help fix this. You can compare the=20
mysql hbm with the oracle hbm to see the missing tables.
From the log file: com.xpn.xwiki.store.migration.XWikiDBVersion is not=20
declared in the oracle hbm
Ludovic
Colin Tay a écrit :
> Hi,
>
> I am sure that i have change the hibernate config to use ORavle
> specific hbm files. The details of the log are attached below:
>
> ERROR store.XWikiHibernateBaseStore - Failed updating schema: 2
> ERROR store.XWikiHibernateBaseStore - While executing query: update
> xwikidoc set xwd_translation=0 where xwd_translation is null
> ERROR store.XWikiHibernateBaseStore - Failed updating schema:
> ORA-00942: table or view does not exist
> WARN hql.QuerySplitter - no persistent classes found
> for query class: delete from com.xpn.xwiki.store.migration.XWikiDBVersion
> WARN query.HQLQueryPlan - manipulation query [delete
> from com.xpn.xwiki.store.migration.XWikiDBVersion] resulted in [0]
> split queries
> WARN action.RequestProcessor - Unhandled Exception thrown:
> class com.xpn.xwiki.XWikiException
> ERROR store.XWikiHibernateBaseStore - Failed updating schema: 2
> ERROR store.XWikiHibernateBaseStore - While executing query: update
> xwikidoc set xwd_translation=0 where xwd_translation is null
> ERROR store.XWikiHibernateBaseStore - Failed updating schema:
> ORA-00942: table or view does not exist
> WARN hql.QuerySplitter - no persistent classes found
> for query class: delete from com.xpn.xwiki.store.migration.XWikiDBVersion
> WARN query.HQLQueryPlan - manipulation query [delete
> from com.xpn.xwiki.store.migration.XWikiDBVersion] resulted in [0]
> split queries
> WARN action.RequestProcessor - Unhandled Exception thrown:
> class com.xpn.xwiki.XWikiException
> ERROR store.XWikiHibernateBaseStore - Failed updating schema: 2
>
> and the list goes on.....
>
> I have also look into XWikiHibernateBaseStore file. In the
> getSchemaUpdateScript(Configuration config, XWikiContext context)
> method, the if(isOracle) {
> dschema = config.getProperty(Environment.DEFAULT_SCHEMA);
>
> always return a null value. Why issit so?
>
> Need your help!
>
> */Ludovic Dubost <[EMAIL PROTECTED]>/* wrote:
>
>
> Hi,
>
> Normally the schema should be created before calling this query.
> Don't
> you have more logs ?
> Did you change the hibernate config to use the Oracle specific hbm
> files ?
>
> Ludovic
>
> > Hi,
> >
> > I have successfully build Xwiki-1.2-SNAPSHOT and try to use it
> > on oracle database. I have also followed the instructions on
> >
> http://www.xwiki.org/xwiki/bin/view/AdminGuide/InstallationOracle
> closely.
> > But error message were display instead as follow in the xwiki.log
> >
> > ERROR store.XWikiHibernateBaseStore - Failed updating schema: 2
> > ERROR store.XWikiHibernateBaseStore - While executing query: update
> > xwikidoc set xwd_translation=0 where xwd_translation is null
> > ................................
> >
> > To clarify, i understand that i need to create the database schema
> > manually but do i need to insert anything in the tables? Or else
> there
> > were be nothing show to the users?
> >
> > Need your guidances!
> >
> >
> ------------------------------------------------------------------------
> >
> > *Real people. Real questions. Real answers. Share what you know
> > *.
> >
> ------------------------------------------------------------------------
> >
> > _______________________________________________
> > devs mailing list
> > [email protected]
> > http://lists.xwiki.org/mailman/listinfo/devs
> >
>
>
> --
> Ludovic Dubost
> Blog: http://www.ludovic.org/blog/
> XWiki: http://www.xwiki.com
> Skype: ldubost GTalk: ldubost
> AIM: nvludo Yahoo: ludovic
>
> _______________________________________________
> devs mailing list
> [email protected]
> http://lists.xwiki.org/mailman/listinfo/devs
>
>
> ------------------------------------------------------------------------
> Yahoo! Movies
> <http://sg.rd.yahoo.com/mail/sg/footer/def/*http://sg.movies.yahoo.com>
> - Search movie info and celeb profiles and photos.
--
Ludovic Dubost
Blog: http://www.ludovic.org/blog/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
AIM: nvludo Yahoo: ludovic
_______________________________________________
devs mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/devs