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