On Jan 21, 2010, at 2:00 PM, Vincent Massol wrote: > > On Jan 21, 2010, at 1:52 PM, Oskar Marek Rzepinski wrote: > >> Hello Vincent. >> >> Thank you for your kindly reply. >> >> Yes we used the HBM file for oracle. We did all the things that were >> mentioned in the installtion guide for the xwiki. Creation of user on >> oracle, deployment, changement of the hibernate-cfg and copying the jdbc >> driver to the right place. I don't know if the problem is an issue of the >> xwiki. I would rather think that it is a problem of the geronimo server that >> we use. On the log of the geronimo server there is a warning that in the war >> file there is no geronimo-web.xml configuration. In that file you should >> give the geronimo server the information of using the database connection as >> I could read it form the geronimo doc > > Well maybe you've configured Geronimo to use connection pools and you haven't > configured xwiki to do so. > >> The second big problem of using the xwiki is that we have here a deadline >> and there is simple no more time for trying to install it. >> >> I don't regret to try this lot on installing xwiki but I had hoped, when >> there is on the official page an info about xwikis compatibility for oracle >> that it would work. I cannot also say that we won't try xwiki in the future >> for an another project but currently it is because of the time. Maybe you >> can make some more tests in the future to really prove the oracle-support >> for xwiki. I think it would make it much more easier for slightly bigger >> companies to use xwiki if they really knew that it works properly. > > Well not mean people here uses Oracle in the XWiki community. However since > you mention "bigger companies" I'd recommend that you contact XWiki SAS > (http://xwiki.com) who offers professional services. I'm sure they'll be able > to help and quickly at that.
typo: s/mean/many/ We're not mean here :) -Vincent > > You could also sponsor increased support for Oracle (through XWiki SAS for > example). > > Thanks > -Vincent > >> Altough thank you very much for the help. >> >> >> >> Best regards Oskar >> >> >> 2010/1/21 Vincent Massol <[email protected]> >> >>> Hi Oskar, >>> >>> Too bad that you couldn't get it to work. I haven't followed but you're use >>> the xwiki oracle HBM mapping file right? >>> >>> AFAIK several users of xwiki are using Oracle. I know for sure it used to >>> work and we haven't done changes to the database mapping so it would be >>> strange it's not working anymore. What's possible though is that some >>> features don't work without tweaking of the hibernate mapping or minor >>> changes to the code (for ex Oracle considers NULL and empty strings as the >>> same thing AFAIR) but the majority of features should work fine. And for >>> features that don't work we can work together to fix them. >>> >>> Thanks >>> -Vincent >>> >>> On Jan 21, 2010, at 1:23 PM, Oskar Marek Rzepinski wrote: >>> >>>> Hello everybody, >>>> >>>> now after a lot of testing I think I have to look for an another wiki. I >>>> have the right driver, I checked this. The configuration is also not the >>>> problem, all parameters are O.K. I think that we have a problem with the >>>> geronimo server that don't let us connect to the database. It is really >>>> annoying that we won't get the xwiki running. The problem is, that for >>>> performance reasons we won't use any other database system or an another >>>> container than geronimo(tomcat). Thanks to all, who tried to help me. >>>> >>>> >>>> Best regards Oskar >>>> >>>> >>>> 2010/1/20 Alonso Isidoro Roman <[email protected]> >>>> >>>>> 2010/1/20 Caleb James DeLisle <[email protected]> >>>>> >>>>>> The problem is definitely that XWiki can't get at the jdbc connector so >>> I >>>>>> don't >>>>>> think creating the database will help, also XWiki uses a complicated >>>>> schema >>>>>> so creating the tables manually is not really an option. >>>>>> >>>>>> i think i did not suggest to create manually the schema! >>>>> >>>>> >>>>>> I would go into the WEB-INF/lib and find the jdbc connector jar you >>>>> added, >>>>>> open it with a zip program, (jar is just a special type of zip file) >>> look >>>>>> inside >>>>>> and make sure it has the file oracle/jdbc/driver/OracleDriver.class >>>>>> Maybe you are using the wrong jdbc. >>>>>> >>>>>> thats a good advice! >>>>> >>>>> >>>>>> Your persistence is admirable! >>>>>> >>>>>> Caleb >>>>>> >>>>>> Oskar Marek Rzepinski wrote: >>>>>>> Hi Alonso. >>>>>>> >>>>>>> Thank you for all the hints. You are writing about creating table. How >>>>> do >>>>>> I >>>>>>> create the table? I thought, that xwiki is doing this after the right >>>>>>> configuration. Am I right? Or have you a simple how-to for creating >>> the >>>>>>> table? I have on oracle the user xwiki with all privileges. The >>>>>> deployment >>>>>>> with the geronimo consle also worked fine. I am still thinking about >>>>> the >>>>>>> oracle if I have to do something more than creating only the user with >>>>>> the >>>>>>> right grants as it is said in the installation guide on the xwiki >>> page. >>>>>>> Thanks again >>>>>>> >>>>>>> >>>>>>> regards Oskar >>>>>>> >>>>>>> >>>>>>> 2010/1/20 Alonso Isidoro Roman <[email protected]> >>>>>>> >>>>>>>> Hi Oscar, >>>>>>>> i dont know about to think, only thing that i can imagine is the jar >>>>> is >>>>>> not >>>>>>>> ok, corrupted or something like that. >>>>>>>> >>>>>>>> pls, try downloading again the jar, put it in /WEB-INF/lib xwiki´s >>>>>> folder, >>>>>>>> create a user xwiki with proper grants (create database, create >>> table, >>>>>>>> etc...), put the war into webapps jboss folder and breathe! >>>>>>>> >>>>>>>> >>>>>>>> >>>>>> >>>>> >>> http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc101040.html >>>>>>>> >>>>>>>> sorry for not be able to help you anymore! >>>>>>>> >>>>>>>> regards _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
