[xwiki-users] Can't get XWiki to work with Oracle
I had the same problem with my first attempts of XWiki installation. As a trial I used the xwiki user in oracle and it worked. For my installations I have to always use xwiki oracle user in order to get passed this point. Can you try it ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Can't get XWiki to work with Oracle
What I have discovered is that this is happening when I try to use an Oracle user other than xwiki. Somehow the code to run the initialization oracle script has been bound to this user. It is a problem cause you can never have two different xwiki installations working with the same oracle SID (i.e. on the same instance of oracle XE). anyone that can look in the code and try to verify this? ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Can't get XWiki to work with Oracle
Hi, I also remember having some trouble to get Xwiki + tomcat + oracle to work. My biggest problem was that I had a too old version of ojdbc14.jar that didn't work with Oracle 10 G. I first thought that the 14 part of the ojdbc14.jar file name was a version number. But that was an incorrect assumption. To check wich ojdbc14.jar version you have, you can do like this: Rename the .jar file to ojdbc14.zip, unzip it and take a look at the manifest file in ojdbc14.zip/META-INF/MANIFEST.MF Containing (among others) a couple of lines looking something like this: *Specification-Version: Oracle JDBC Driver version - 10.2.0.4.0 Implementation-Version: Oracle JDBC Driver version - 10.2.0.4.0 * The 10.2.0.4.0 version of the driver works fine for me/xwiki with both oracle 9 and oragle 10G databases. Kind regards, Jonas 2009/7/15 Gallois Frédéric frederic.gall...@insee.fr Hi I'm running Xwiki with Tomcat5.5 and Oracle 10g. Here's what I've done : - unpack the war under the webapps directory of Tomcat - change the ojdbc.jar because of a bad version - change the hibernate.cfg.xml file : - uncomment only the oracle part - change connection.url, connection.username and connection.password As long as I remember, the Error number 3... came because of a bad version of ojdc14.jar. Hope This Helps Frédéric -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Dean Weber Envoyé : mardi 14 juillet 2009 22:29 À : users@xwiki.org Objet : Re: [xwiki-users] Can't get XWiki to work with Oracle I ran a diff and found only cosmetic changes. However, I pulled that copy down and replaced mine to guarantee I had the most up to date one. Nothing changed. I still got: 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.XWikiHibernateMigratio nManager 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 I am not the only one that has seen this problem. I found another posting similar to mine: http://n2.nabble.com/Problems-with-Xwiki-Enterprise-1.8-on-Ora cle---get-Error-number-3001-in-3-td2517809.html#a2518188 It didn't have a resolution as well. If there are more details needed to help my situation please let me know and I will provide any information I can. Thanks Dean Marius Dumitru Florea wrote: Hi Dean, Is this http://svn.xwiki.org/svnroot/xwiki/platform/core/trunk/xwiki-c ore/src/main/resources/xwiki.oracle.hbm.xmlhttp://svn.xwiki.org/svnroot/xwiki/platform/core/trunk/xwiki-c%0Aore/src/main/resources/xwiki.oracle.hbm.xml the same as your xwiki.oracle.hbm.xml ? Hope this helps, Marius ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- View this message in context: http://n2.nabble.com/Can%27t-get-XWiki-to-work-with-Oracle-tp3 228059p3259203.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Can't get XWiki to work with Oracle
Gallois Originally, I dismissed the idea that I was having a connection problem because I was able to connect before. However, after reading your reply, I tested it one more time. I was not able to connect to the database. Something has broken with Oracle and our Linux installation. I will have to investigate this further. Thanks for making me stop to take another look at the obvious. -Dean Gallois Frédéric wrote: Hi Dean This sounds like a connection problem. Did you test the connection with the same parameters (user, host) but outside Xwiki in Jetty ? -- View this message in context: http://n2.nabble.com/Can%27t-get-XWiki-to-work-with-Oracle-tp3228059p3288617.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Can't get XWiki to work with Oracle
Hi Dean De la part de Dean Weber Here's the pertinent error output and stacktrace: Caused by: java.sql.SQLException: The Network Adapter could not establish the connection This sounds like a connection problem. Did you test the connection with the same parameters (user, host) but outside Xwiki in Jetty ? ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
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@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/IsthereasimplewaygettingxwikiworkingwithOracle#Attachments . 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.we...@raytheon.com ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users