Re: [xwiki-devs] Problem With Oracle Database 10gR1 - xwiki-devs@xwiki.org

14 Sep 2007

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 &lt;ludovic(a)xwiki.org&gt;/* 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
 devs(a)xwiki.org
 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
     devs(a)xwiki.org
     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