Re: [xwiki-users] Can't get XWiki to work with Oracle

Surely someone has tried to put XWiki together with Oracle using the limited instructions available on-line. I can't believe that no one has any pointers on why I can't get it working. Please help. Thanks Dean From: Dean G Weber/US/Raytheon To: users(a)xwiki.org Date: 07/08/2009 05:12 PM Subject: Can't get XWiki to work with Oracle I could use some help on getting an XWiki server working with Oracle. I followed the instructions here: http://platform.xwiki.org/XWiki/bin/view/AdminGuide/InstallationOracle The mentioned xwiki-oracle.hbm.xml file I finally found here: http://www.xwiki.org/XWiki/bin/view/FAQ/Isthereasimplewaygettingxwikiworkin… . I placed it in the suggested xwiki/Web-INF/classes sub-directory. But, I could not find a feeds.oracle.hbm.xml file anywhere. (Why would the page mention those XML files yet not provide them?) I made the necessary changes to hibernate.cfg.xml file in WEB-INF. I even placed the ojdbc5.jar (latest rev) in the webaps/WEB-INF/lib directory. I know that the JDBC jar file is correct because I had to put it in the jetty/ext directory to get groovy script on one of our pages to successfully connect to a different Oracle instance and pull data onto the page. (Side note: groovy classes really need to be on their own separate pages due to parsing issues with velocity and groovy. This was a heard learned lesson). So, I made the changes from the above instructions and created an xwiki user on my Oracle 10g express edition DB which I installed on our Red-Hat Linux server. So far things seemed to go well until I tried to pull it all together and fire up the xwiki server and connect to it from the browser. Below is the error I received: HTTP ERROR: 500 Error number 3 in 0: Could not initialize main xwiki context Wrapped Exception: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XwikiHibernateMigrationManager from param xwiki.store.migration.manager.class Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Could not parse mapping document from resource xwiki.oracle.hbm.xml RequestURI=/xwiki/bin/CEDSYard/ Powered by Jetty:// The request URI is the configured main page for our wiki. I see no new tables in the xe Oracle DB. All of the past emails on the subject in the user list haven't supplied any answers. I really hope I can get some help on this. What do I need to do to get Oracle and xwiki to work together since the instructions I've found miss crucial elements of the puzzle? Thanks, Dean Weber Sr Software Engineer II Raytheon Technical Services Company LLC 6125 E 21 Street, MS 36 Indianapolis, IN 46219 USA 317.306.2657 Phone 317.306.4253 Fax Dean.G.Weber(a)raytheon.com