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

Reply via email to