Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
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 alons...@gmail.com 2010/1/20 Caleb James DeLisle calebdeli...@lavabit.com 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 alons...@gmail.com 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Alonso Isidoro Roman. La maquinaria de la corrupción se engrasa a diario con el sudor del trabajador conformista Aristóteles. ___ 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] Problem with getting Xwiki to work with Oracle10g
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 alons...@gmail.com 2010/1/20 Caleb James DeLisle calebdeli...@lavabit.com 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 alons...@gmail.com 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
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 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. Altough thank you very much for the help. Best regards Oskar 2010/1/21 Vincent Massol vinc...@massol.net 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 alons...@gmail.com 2010/1/20 Caleb James DeLisle calebdeli...@lavabit.com 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 alons...@gmail.com 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 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] Problem with getting Xwiki to work with Oracle10g
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. 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 vinc...@massol.net 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 alons...@gmail.com 2010/1/20 Caleb James DeLisle calebdeli...@lavabit.com 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 alons...@gmail.com 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
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
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 vinc...@massol.net 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 alons...@gmail.com 2010/1/20 Caleb James DeLisle calebdeli...@lavabit.com 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 alons...@gmail.com 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
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Hello Oscar, it's really pity you cannot use XWiki for your purposes - I have tried at least 6 - 7 other Wikis before we chosen this one. Sure, there are some bugs, but who's perfect? :-) It's getting better from version to version. Now we have experience with XWiki with different environments - XE 1.2 (Oracle 10g+OC4J), XE 1.5 (MySQL+Tomcat 5.5), XE 2.1.1 (Oracle 10g + Tomcat 6 and Oracle 10g +JBoss 5). For Oracle 10g we are using ojdbc14.jar (in WEB-INF/lib XWiki directory or in the \common\lib directory from Tomcat) - it works perfectly. I'm pretty sure, the problem might be geronimo server - we have no problems without using it :-) I'm not familiar with Apache geronimo but perhaps you need some more plugins (see i.e. http://www.geronimoplugins.com/entry_OracleXADriverforConsole.php) to get works all together? Best Regards, Alla -- View this message in context: http://n2.nabble.com/Problem-with-getting-Xwiki-to-work-with-Oracle10g-tp4418452p4434035.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] Problem with getting Xwiki to work with Oracle10g
Hi Adoro, On Jan 21, 2010, at 3:53 PM, adoro wrote: Hello Oscar, it's really pity you cannot use XWiki for your purposes - I have tried at least 6 - 7 other Wikis before we chosen this one. Sure, there are some bugs, but who's perfect? :-) It's getting better from version to version. Now we have experience with XWiki with different environments - XE 1.2 (Oracle 10g+OC4J), XE 1.5 (MySQL+Tomcat 5.5), XE 2.1.1 (Oracle 10g + Tomcat 6 and Oracle 10g +JBoss 5). For Oracle 10g we are using ojdbc14.jar (in WEB-INF/lib XWiki directory or in the \common\lib directory from Tomcat) - it works perfectly. Cool, thanks for the feedback Adoro. I wasn't sure since I haven't tried XE on Oracle for at least 1 year. Good to get confirmation it's working fine. Are all features working fine or are there some areas not working? Thanks -Vincent I'm pretty sure, the problem might be geronimo server - we have no problems without using it :-) I'm not familiar with Apache geronimo but perhaps you need some more plugins (see i.e. http://www.geronimoplugins.com/entry_OracleXADriverforConsole.php) to get works all together? Best Regards, Alla ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
On Jan 21, 2010, at 4:00 PM, Vincent Massol wrote: Hi Adoro, Sorry I meant Alla. -Vincent On Jan 21, 2010, at 3:53 PM, adoro wrote: Hello Oscar, it's really pity you cannot use XWiki for your purposes - I have tried at least 6 - 7 other Wikis before we chosen this one. Sure, there are some bugs, but who's perfect? :-) It's getting better from version to version. Now we have experience with XWiki with different environments - XE 1.2 (Oracle 10g+OC4J), XE 1.5 (MySQL+Tomcat 5.5), XE 2.1.1 (Oracle 10g + Tomcat 6 and Oracle 10g +JBoss 5). For Oracle 10g we are using ojdbc14.jar (in WEB-INF/lib XWiki directory or in the \common\lib directory from Tomcat) - it works perfectly. Cool, thanks for the feedback Adoro. I wasn't sure since I haven't tried XE on Oracle for at least 1 year. Good to get confirmation it's working fine. Are all features working fine or are there some areas not working? Thanks -Vincent I'm pretty sure, the problem might be geronimo server - we have no problems without using it :-) I'm not familiar with Apache geronimo but perhaps you need some more plugins (see i.e. http://www.geronimoplugins.com/entry_OracleXADriverforConsole.php) to get works all together? Best Regards, Alla ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
On 01/21/2010 01: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. I would suggest preparing a complete, configured war, then deploy it to the container. This means: - unzip the xwiki war - copy the connector jar into the lib folder - configure hibernate - zip the whole folder into xwiki.war - deploy this file Some containers don't take into account changes done in a deployed war, and always use the files from inside it. -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
I will look forward at this tommorow, but we have only time till morning midday to get a working wiki system. I will check the option with the configured war. How about the connection pool at geronimo. What do you mean by that Vincent? It would be great if you could explain in some common words how to configure xwiki for this. I will try all your new hints and whenever I will have the time at my work. For the first, if the time passes by a simple wiki like JSPwiki is fine for the beginning. But there will be in the future some new versions, so I admit that it will be good if I get the xwiki running on geronimo. Best greatings from Germany If you have some more hints, I will forward to check everything to get it working. And yes, I can say after testing about 8 wikis that xwiki is far more comfortable than the others, but I tried them all on a linux server with mysql. The current situations does not let us to install a second dbms on the server for security reasons and therefore it will be great if in the near future I will get the xwiki up and running on geronimo with oracle. : ) Thanks once again. If the installtions turns into a successful story tommorw I will post it for others that might have the same problem. Thanks once again to all and please don't mind if you have any more hints, just post them. 2010/1/21 Sergiu Dumitriu ser...@xwiki.com On 01/21/2010 01: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. I would suggest preparing a complete, configured war, then deploy it to the container. This means: - unzip the xwiki war - copy the connector jar into the lib folder - configure hibernate - zip the whole folder into xwiki.war - deploy this file Some containers don't take into account changes done in a deployed war, and always use the files from inside it. -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ 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] Problem with getting Xwiki to work with Oracle10g
hi, i have checked my /WEB-INF/lib xwiki' s folder and i dont have any orai18n.jar, pls try removing it! this message is clear, the class is not loaded! Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver 2010/1/20 Oskar Marek Rzepinski rzepin...@gmail.com Sorry, that I didn't answer yesterday. My message was bounced from the list. i hope it works now. This was my message: Thank you all for willing to help me. Now I checked the stack trace. You can see it below. I cannot understand the error log. It says, as far as I understand it, that it cannot load the jdbc driver, but why? I copied it into the lib folder. 2010-01-19 15:39:53,711 WARN [RequestUtils] No FormBeanConfig found under 'view' 2010-01-19 15:39:53,996 INFO [ PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server. 2010-01-19 15:39:53,996 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Malagueta' 3.2.1.GA http://3.2.1.ga/ 2010-01-19 15:39:54,274 INFO [PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server. 2010-01-19 15:39:54,274 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Malagueta' 3.2.1.GA http://3.2.1.ga/ 2010-01-19 15:39:54,275 WARN [DefaultObservationManager] The [com.xpn.xwiki.store.XWikiCacheStore] listener has overwritten a previously registered listener [com.xpn.xwiki.store.XWikiCacheStore] since they both are registered under the same id [XWikiCacheStore]. In the future consider removing a Listener first if you really want to register it again. 2010-01-19 15:39:54,277 INFO [XWiki] Running storage migrations 2010-01-19 15:39:54,279 INFO [Configuration] configuring from resource: /WEB-INF/hibernate.cfg.xml 2010-01-19 15:39:54,299 INFO [Configuration] Reading mappings from resource : xwiki.oracle.hbm.xml 2010-01-19 15:39:54,716 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiDocument - xwikidoc 2010-01-19 15:39:54,892 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo - xwikircs 2010-01-19 15:39:54,899 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent - xwikircs 2010-01-19 15:39:54,951 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiDeletedDocument - xwikirecyclebin 2010-01-19 15:39:54,982 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.DeletedAttachment - xwikiattrecyclebin 2010-01-19 15:39:55,005 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiLock - xwikilock 2010-01-19 15:39:55,007 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiLink - xwikilinks 2010-01-19 15:39:55,009 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachment - xwikiattachment 2010-01-19 15:39:55,012 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachmentContent - xwikiattachment_content 2010-01-19 15:39:55,014 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachmentArchive - xwikiattachment_archive 2010-01-19 15:39:55,015 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.classes.PropertyClass - xwikiclassesprop 2010-01-19 15:39:55,260 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.NumberClass - xwikinumberclasses 2010-01-19 15:39:55,290 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.StringClass - xwikistringclasses 2010-01-19 15:39:55,291 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.DateClass - xwikidateclasses 2010-01-19 15:39:55,292 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.PasswordClass - xwikistringclasses 2010-01-19 15:39:55,294 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.TextAreaClass - xwikistringclasses 2010-01-19 15:39:55,295 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.BooleanClass - xwikibooleanclasses 2010-01-19 15:39:55,296 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.StaticListClass - xwikislistclasses 2010-01-19 15:39:55,298 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.DBListClass - xwikidblistclasses 2010-01-19 15:39:55,299 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.classes.BaseClass - xwikiclasses 2010-01-19 15:39:55,301 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.BaseProperty - xwikiproperties 2010-01-19 15:39:55,302 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.IntegerProperty - xwikiintegers 2010-01-19 15:39:55,303 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.LongProperty - xwikilongs 2010-01-19 15:39:55,304 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.FloatProperty - xwikifloats 2010-01-19 15:39:55,305 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.DoubleProperty - xwikidoubles 2010-01-19 15:39:55,306 INFO [HbmBinder] Mapping joined-subclass:
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
The problem is still there. We still don't get it running, even if the orai18n.jar is not in the folder. 2010/1/20 Alonso Isidoro Roman alons...@gmail.com hi, i have checked my /WEB-INF/lib xwiki' s folder and i dont have any orai18n.jar, pls try removing it! this message is clear, the class is not loaded! Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver 2010/1/20 Oskar Marek Rzepinski rzepin...@gmail.com Sorry, that I didn't answer yesterday. My message was bounced from the list. i hope it works now. This was my message: Thank you all for willing to help me. Now I checked the stack trace. You can see it below. I cannot understand the error log. It says, as far as I understand it, that it cannot load the jdbc driver, but why? I copied it into the lib folder. 2010-01-19 15:39:53,711 WARN [RequestUtils] No FormBeanConfig found under 'view' 2010-01-19 15:39:53,996 INFO [ PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server. 2010-01-19 15:39:53,996 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Malagueta' 3.2.1.GA http://3.2.1.ga/ 2010-01-19 15:39:54,274 INFO [PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server. 2010-01-19 15:39:54,274 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Malagueta' 3.2.1.GA http://3.2.1.ga/ 2010-01-19 15:39:54,275 WARN [DefaultObservationManager] The [com.xpn.xwiki.store.XWikiCacheStore] listener has overwritten a previously registered listener [com.xpn.xwiki.store.XWikiCacheStore] since they both are registered under the same id [XWikiCacheStore]. In the future consider removing a Listener first if you really want to register it again. 2010-01-19 15:39:54,277 INFO [XWiki] Running storage migrations 2010-01-19 15:39:54,279 INFO [Configuration] configuring from resource: /WEB-INF/hibernate.cfg.xml 2010-01-19 15:39:54,299 INFO [Configuration] Reading mappings from resource : xwiki.oracle.hbm.xml 2010-01-19 15:39:54,716 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiDocument - xwikidoc 2010-01-19 15:39:54,892 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo - xwikircs 2010-01-19 15:39:54,899 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent - xwikircs 2010-01-19 15:39:54,951 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiDeletedDocument - xwikirecyclebin 2010-01-19 15:39:54,982 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.DeletedAttachment - xwikiattrecyclebin 2010-01-19 15:39:55,005 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiLock - xwikilock 2010-01-19 15:39:55,007 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiLink - xwikilinks 2010-01-19 15:39:55,009 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachment - xwikiattachment 2010-01-19 15:39:55,012 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachmentContent - xwikiattachment_content 2010-01-19 15:39:55,014 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachmentArchive - xwikiattachment_archive 2010-01-19 15:39:55,015 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.classes.PropertyClass - xwikiclassesprop 2010-01-19 15:39:55,260 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.NumberClass - xwikinumberclasses 2010-01-19 15:39:55,290 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.StringClass - xwikistringclasses 2010-01-19 15:39:55,291 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.DateClass - xwikidateclasses 2010-01-19 15:39:55,292 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.PasswordClass - xwikistringclasses 2010-01-19 15:39:55,294 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.TextAreaClass - xwikistringclasses 2010-01-19 15:39:55,295 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.BooleanClass - xwikibooleanclasses 2010-01-19 15:39:55,296 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.StaticListClass - xwikislistclasses 2010-01-19 15:39:55,298 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.DBListClass - xwikidblistclasses 2010-01-19 15:39:55,299 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.classes.BaseClass - xwikiclasses 2010-01-19 15:39:55,301 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.BaseProperty - xwikiproperties 2010-01-19 15:39:55,302 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.IntegerProperty - xwikiintegers 2010-01-19 15:39:55,303 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.LongProperty - xwikilongs 2010-01-19 15:39:55,304 INFO [HbmBinder] Mapping joined-subclass:
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
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 2010/1/20 Oskar Marek Rzepinski rzepin...@gmail.com The problem is still there. We still don't get it running, even if the orai18n.jar is not in the folder. 2010/1/20 Alonso Isidoro Roman alons...@gmail.com hi, i have checked my /WEB-INF/lib xwiki' s folder and i dont have any orai18n.jar, pls try removing it! this message is clear, the class is not loaded! Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver 2010/1/20 Oskar Marek Rzepinski rzepin...@gmail.com Sorry, that I didn't answer yesterday. My message was bounced from the list. i hope it works now. This was my message: Thank you all for willing to help me. Now I checked the stack trace. You can see it below. I cannot understand the error log. It says, as far as I understand it, that it cannot load the jdbc driver, but why? I copied it into the lib folder. 2010-01-19 15:39:53,711 WARN [RequestUtils] No FormBeanConfig found under 'view' 2010-01-19 15:39:53,996 INFO [ PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server. 2010-01-19 15:39:53,996 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Malagueta' 3.2.1.GA http://3.2.1.ga/ 2010-01-19 15:39:54,274 INFO [PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server. 2010-01-19 15:39:54,274 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Malagueta' 3.2.1.GA http://3.2.1.ga/ 2010-01-19 15:39:54,275 WARN [DefaultObservationManager] The [com.xpn.xwiki.store.XWikiCacheStore] listener has overwritten a previously registered listener [com.xpn.xwiki.store.XWikiCacheStore] since they both are registered under the same id [XWikiCacheStore]. In the future consider removing a Listener first if you really want to register it again. 2010-01-19 15:39:54,277 INFO [XWiki] Running storage migrations 2010-01-19 15:39:54,279 INFO [Configuration] configuring from resource: /WEB-INF/hibernate.cfg.xml 2010-01-19 15:39:54,299 INFO [Configuration] Reading mappings from resource : xwiki.oracle.hbm.xml 2010-01-19 15:39:54,716 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiDocument - xwikidoc 2010-01-19 15:39:54,892 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo - xwikircs 2010-01-19 15:39:54,899 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent - xwikircs 2010-01-19 15:39:54,951 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiDeletedDocument - xwikirecyclebin 2010-01-19 15:39:54,982 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.DeletedAttachment - xwikiattrecyclebin 2010-01-19 15:39:55,005 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiLock - xwikilock 2010-01-19 15:39:55,007 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiLink - xwikilinks 2010-01-19 15:39:55,009 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachment - xwikiattachment 2010-01-19 15:39:55,012 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachmentContent - xwikiattachment_content 2010-01-19 15:39:55,014 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachmentArchive - xwikiattachment_archive 2010-01-19 15:39:55,015 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.classes.PropertyClass - xwikiclassesprop 2010-01-19 15:39:55,260 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.NumberClass - xwikinumberclasses 2010-01-19 15:39:55,290 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.StringClass - xwikistringclasses 2010-01-19 15:39:55,291 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.DateClass - xwikidateclasses 2010-01-19 15:39:55,292 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.PasswordClass - xwikistringclasses 2010-01-19 15:39:55,294 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.TextAreaClass - xwikistringclasses 2010-01-19 15:39:55,295 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.BooleanClass - xwikibooleanclasses 2010-01-19 15:39:55,296 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.StaticListClass - xwikislistclasses 2010-01-19 15:39:55,298 INFO [HbmBinder] Mapping joined-subclass:
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
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 alons...@gmail.com 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
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 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. 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 alons...@gmail.com 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 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] Problem with getting Xwiki to work with Oracle10g
I will look on this tommorow. I don't have the access to the dev server from my house but only from my work site. I will post the results tommorow morning, when I tried this. Thanks for now. Oskar 2010/1/20 Caleb James DeLisle calebdeli...@lavabit.com 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 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. 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 alons...@gmail.com 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 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] Problem with getting Xwiki to work with Oracle10g
How can I unsubscribe from this list, I no longer need to be here. Thank you Alma -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Oskar Marek Rzepinski Sent: Wednesday, January 20, 2010 12:06 PM To: XWiki Users Subject: Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g I will look on this tommorow. I don't have the access to the dev server from my house but only from my work site. I will post the results tommorow morning, when I tried this. Thanks for now. Oskar 2010/1/20 Caleb James DeLisle calebdeli...@lavabit.com 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 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. 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 alons...@gmail.com 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 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 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Hi, On Jan 20, 2010, at 9:11 PM, Pim, Alma wrote: How can I unsubscribe from this list, I no longer need to be here. See http://dev.xwiki.org/xwiki/bin/view/Community/MailingLists -Vincent Thank you Alma -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Oskar Marek Rzepinski Sent: Wednesday, January 20, 2010 12:06 PM To: XWiki Users Subject: Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g I will look on this tommorow. I don't have the access to the dev server from my house but only from my work site. I will post the results tommorow morning, when I tried this. Thanks for now. Oskar 2010/1/20 Caleb James DeLisle calebdeli...@lavabit.com 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 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. 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 alons...@gmail.com 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
2010/1/20 Caleb James DeLisle calebdeli...@lavabit.com 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 alons...@gmail.com 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 users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Alonso Isidoro Roman. La maquinaria de la corrupción se engrasa a diario con el sudor del trabajador conformista Aristóteles. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory property name=show_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP:1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver/property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate configuration file, as you can see: ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory !-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) -- !-- Generic parameters common to all Databases -- property name=show_sqlfalse/ property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property !-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. -- property name=jdbc.use_scrollable_resultsetfalse/property !-- Oracle configuration. Uncomment if you want
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
We have now some meetings, after them we will try once again with the jetty pack. @Caleb James DeLisle The steps I mentioned already we have done with the war file. We deployed it with the geronimo console. I will get back to this after we have tried the jetty pack and than I will answer and report if we were successful or not. 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory property name=show_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP :1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver/property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate configuration file, as you can see: ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory !-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) -- !-- Generic parameters common to all Databases -- property name=show_sqlfalse/ property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Do shemas have been created in the DB ? Can you ask your DBA to see what is the last login date of the user ? It could help to know if the problem comes from the DB or if there is something wrong before trying to connect -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 11:48 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g So, we started our installation once again and it still does not work. Step-by-step: 1. We created a user xwiki on oracle with all privileges. We use oracle 10.2.0.40 2. We deployed the war file with the geronimo console. We use tomcat 6 javaee5 2.1.4 3. We than changed the configuration file, as already mentioned 4. We copied the ojdbc5.jar from oracle 11.1.0.7 and tried it also with ojdbc14.jar. 5. Then we restarted geronimo and started the xwiki container We use the oracle installtion and the geronimo server on a sun solaris server and solaris as the operating system. We still don't get the xwiki installed, and don't understand why. Thank you all for the pleasent help. 2010/1/19 Oskar Marek Rzepinski rzepin...@gmail.com We have now some meetings, after them we will try once again with the jetty pack. @Caleb James DeLisle The steps I mentioned already we have done with the war file. We deployed it with the geronimo console. I will get back to this after we have tried the jetty pack and than I will answer and report if we were successful or not. 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory property name=show_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP :1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver /property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConne ctionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Now i remember that we cancelled the use of the war because of identical problems (and running out of time and mainly budget) I think that the Architecture Dept created a new war based on the Jetty distribution -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 11:48 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g So, we started our installation once again and it still does not work. Step-by-step: 1. We created a user xwiki on oracle with all privileges. We use oracle 10.2.0.40 2. We deployed the war file with the geronimo console. We use tomcat 6 javaee5 2.1.4 3. We than changed the configuration file, as already mentioned 4. We copied the ojdbc5.jar from oracle 11.1.0.7 and tried it also with ojdbc14.jar. 5. Then we restarted geronimo and started the xwiki container We use the oracle installtion and the geronimo server on a sun solaris server and solaris as the operating system. We still don't get the xwiki installed, and don't understand why. Thank you all for the pleasent help. 2010/1/19 Oskar Marek Rzepinski rzepin...@gmail.com We have now some meetings, after them we will try once again with the jetty pack. @Caleb James DeLisle The steps I mentioned already we have done with the war file. We deployed it with the geronimo console. I will get back to this after we have tried the jetty pack and than I will answer and report if we were successful or not. 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory property name=show_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP :1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver /property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConne ctionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
unfortunately I am a little out of my league, my installation uses postgres and jetty but I would suggest you create a database called xwiki and make the user xwiki the owner of that database, It's possible that it is getting hung up in the create database part and doing it manually would make it work, hard to tell from the error log. Caleb Oskar Marek Rzepinski wrote: So, we started our installation once again and it still does not work. Step-by-step: 1. We created a user xwiki on oracle with all privileges. We use oracle 10.2.0.40 2. We deployed the war file with the geronimo console. We use tomcat 6 javaee5 2.1.4 3. We than changed the configuration file, as already mentioned 4. We copied the ojdbc5.jar from oracle 11.1.0.7 and tried it also with ojdbc14.jar. 5. Then we restarted geronimo and started the xwiki container We use the oracle installtion and the geronimo server on a sun solaris server and solaris as the operating system. We still don't get the xwiki installed, and don't understand why. Thank you all for the pleasent help. 2010/1/19 Oskar Marek Rzepinski rzepin...@gmail.com We have now some meetings, after them we will try once again with the jetty pack. @Caleb James DeLisle The steps I mentioned already we have done with the war file. We deployed it with the geronimo console. I will get back to this after we have tried the jetty pack and than I will answer and report if we were successful or not. 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory property name=show_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP :1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver/property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
first at all, sory for my poor english. Second, could you attach entire stack trace? You should see CAUSED BY clause. Thats you need to see. Third, with no entire stack trace i think that the problem comes from Oracle and you need to fullfilling hibernate.cfg.xml properly with proper connection url. this is my conn url: jdbc:oracle:thin:@ (description=(address_list=(load_balance=on)(address=(protocol=tcp)(host=X.X.X.X)(port=1521))(address=(protocol=tcp)(host=X.X.X.X)(port=1521)))(connect_data=(service_name=myService.name))) hope this helps! Alonso 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com unfortunately I am a little out of my league, my installation uses postgres and jetty but I would suggest you create a database called xwiki and make the user xwiki the owner of that database, It's possible that it is getting hung up in the create database part and doing it manually would make it work, hard to tell from the error log. Caleb Oskar Marek Rzepinski wrote: So, we started our installation once again and it still does not work. Step-by-step: 1. We created a user xwiki on oracle with all privileges. We use oracle 10.2.0.40 2. We deployed the war file with the geronimo console. We use tomcat 6 javaee5 2.1.4 3. We than changed the configuration file, as already mentioned 4. We copied the ojdbc5.jar from oracle 11.1.0.7 and tried it also with ojdbc14.jar. 5. Then we restarted geronimo and started the xwiki container We use the oracle installtion and the geronimo server on a sun solaris server and solaris as the operating system. We still don't get the xwiki installed, and don't understand why. Thank you all for the pleasent help. 2010/1/19 Oskar Marek Rzepinski rzepin...@gmail.com We have now some meetings, after them we will try once again with the jetty pack. @Caleb James DeLisle The steps I mentioned already we have done with the war file. We deployed it with the geronimo console. I will get back to this after we have tried the jetty pack and than I will answer and report if we were successful or not. 2010/1/19 Caleb James DeLisle calebdeli...@lavabit.com XWiki is built differently for the war installation than the jetty/HSQL pack I think If you download the war file and install that way it will work. Caleb PERINAUD Christophe wrote: Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory property name=show_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP :1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver/property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Sorry, that I didn't answer yesterday. My message was bounced from the list. i hope it works now. This was my message: Thank you all for willing to help me. Now I checked the stack trace. You can see it below. I cannot understand the error log. It says, as far as I understand it, that it cannot load the jdbc driver, but why? I copied it into the lib folder. 2010-01-19 15:39:53,711 WARN [RequestUtils] No FormBeanConfig found under 'view' 2010-01-19 15:39:53,996 INFO [ PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server. 2010-01-19 15:39:53,996 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Malagueta' 3.2.1.GA http://3.2.1.ga/ 2010-01-19 15:39:54,274 INFO [PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server. 2010-01-19 15:39:54,274 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Malagueta' 3.2.1.GA http://3.2.1.ga/ 2010-01-19 15:39:54,275 WARN [DefaultObservationManager] The [com.xpn.xwiki.store.XWikiCacheStore] listener has overwritten a previously registered listener [com.xpn.xwiki.store.XWikiCacheStore] since they both are registered under the same id [XWikiCacheStore]. In the future consider removing a Listener first if you really want to register it again. 2010-01-19 15:39:54,277 INFO [XWiki] Running storage migrations 2010-01-19 15:39:54,279 INFO [Configuration] configuring from resource: /WEB-INF/hibernate.cfg.xml 2010-01-19 15:39:54,299 INFO [Configuration] Reading mappings from resource : xwiki.oracle.hbm.xml 2010-01-19 15:39:54,716 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiDocument - xwikidoc 2010-01-19 15:39:54,892 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.rcs.XWikiRCSNodeInfo - xwikircs 2010-01-19 15:39:54,899 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent - xwikircs 2010-01-19 15:39:54,951 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiDeletedDocument - xwikirecyclebin 2010-01-19 15:39:54,982 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.DeletedAttachment - xwikiattrecyclebin 2010-01-19 15:39:55,005 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiLock - xwikilock 2010-01-19 15:39:55,007 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiLink - xwikilinks 2010-01-19 15:39:55,009 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachment - xwikiattachment 2010-01-19 15:39:55,012 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachmentContent - xwikiattachment_content 2010-01-19 15:39:55,014 INFO [HbmBinder] Mapping class: com.xpn.xwiki.doc.XWikiAttachmentArchive - xwikiattachment_archive 2010-01-19 15:39:55,015 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.classes.PropertyClass - xwikiclassesprop 2010-01-19 15:39:55,260 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.NumberClass - xwikinumberclasses 2010-01-19 15:39:55,290 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.StringClass - xwikistringclasses 2010-01-19 15:39:55,291 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.DateClass - xwikidateclasses 2010-01-19 15:39:55,292 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.PasswordClass - xwikistringclasses 2010-01-19 15:39:55,294 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.TextAreaClass - xwikistringclasses 2010-01-19 15:39:55,295 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.BooleanClass - xwikibooleanclasses 2010-01-19 15:39:55,296 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.StaticListClass - xwikislistclasses 2010-01-19 15:39:55,298 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.classes.DBListClass - xwikidblistclasses 2010-01-19 15:39:55,299 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.classes.BaseClass - xwikiclasses 2010-01-19 15:39:55,301 INFO [HbmBinder] Mapping class: com.xpn.xwiki.objects.BaseProperty - xwikiproperties 2010-01-19 15:39:55,302 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.IntegerProperty - xwikiintegers 2010-01-19 15:39:55,303 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.LongProperty - xwikilongs 2010-01-19 15:39:55,304 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.FloatProperty - xwikifloats 2010-01-19 15:39:55,305 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.DoubleProperty - xwikidoubles 2010-01-19 15:39:55,306 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.StringProperty - xwikistrings 2010-01-19 15:39:55,307 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.DateProperty - xwikidates 2010-01-19 15:39:55,307 INFO [HbmBinder] Mapping joined-subclass: com.xpn.xwiki.objects.LargeStringProperty - xwikilargestrings 2010-01-19 15:39:55,308 INFO [HbmBinder] Mapping joined-subclass:
[xwiki-users] Problem with getting Xwiki to work with Oracle10g
Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate configuration file, as you can see: ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory !-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) -- !-- Generic parameters common to all Databases -- property name=show_sqlfalse/ property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property !-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. -- property name=jdbc.use_scrollable_resultsetfalse/property !-- Oracle configuration. Uncomment if you want to use Oracle and comment out other database configurations. Note: the 2 properties named hibernate.connection.SetBigStringTryClob and hibernate.jdbc.batch_size. They are required to tell Oracle to allow CLOBs larger than 32K. -- property name=connection.urljdbc:oracle:thin:@10.233.106.132:1521 :devORA/property property name=connection.usernamexwiki/property property name=connection.passwordxwiki/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver/property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ mapping resource=activitystream.hbm.xml/ property name=hibernate.query.factory_classorg.hibernate.hql.classic.ClassicQueryTranslatorFactory/property /session-factory /hibernate-configuration 4. We still get this error. We can simply connect to the xwiki users on the solaris console with sqlplus, but we cannot get it work. The user for the xwiki has all privileges to work the database. We cannot understand what goes wrong. Is there a simple how to how to really xwiki working on oracle 10g? Thank you very much. HTTP Status 500 - _ type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: com.xpn.xwiki.XWikiException: 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: invalid configuration org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:693) javax.servlet.http.HttpServlet.service(HttpServlet.java:806) com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:117) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) root
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate configuration file, as you can see: ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory !-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) -- !-- Generic parameters common to all Databases -- property name=show_sqlfalse/ property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property !-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. -- property name=jdbc.use_scrollable_resultsetfalse/property !-- Oracle configuration. Uncomment if you want to use Oracle and comment out other database configurations. Note: the 2 properties named hibernate.connection.SetBigStringTryClob and hibernate.jdbc.batch_size. They are required to tell Oracle to allow CLOBs larger than 32K. -- property name=connection.urljdbc:oracle:thin:@10.233.106.132:1521 :devORA/property property name=connection.usernamexwiki/property property name=connection.passwordxwiki/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver /property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConne ctionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ mapping resource=activitystream.hbm.xml/ property name=hibernate.query.factory_classorg.hibernate.hql.classic .ClassicQueryTranslatorFactory/property /session-factory /hibernate-configuration 4. We still get this error. We can simply connect to the xwiki users on the solaris console with sqlplus, but we cannot get it work. The user for the xwiki has all privileges to work the database. We cannot understand what goes wrong. Is there a simple how to how to really xwiki working on oracle 10g? Thank you very much. HTTP Status 500 - _ type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: com.xpn.xwiki.XWikiException: 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: invalid configuration org.apache.struts.action.RequestProcessor.processException(Req uestProcessor.java:535) org.apache.struts.action.RequestProcessor.processActionPerform (RequestProcessor.java:433) org.apache.struts.action.RequestProcessor.process(RequestProce ssor.java:236) org.apache.struts.action.ActionServlet.process
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate configuration file, as you can see: ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory !-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) -- !-- Generic parameters common to all Databases -- property name=show_sqlfalse/ property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property !-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. -- property name=jdbc.use_scrollable_resultsetfalse/property !-- Oracle configuration. Uncomment if you want to use Oracle and comment out other database configurations. Note: the 2 properties named hibernate.connection.SetBigStringTryClob and hibernate.jdbc.batch_size. They are required to tell Oracle to allow CLOBs larger than 32K. -- property name=connection.urljdbc:oracle:thin:@10.233.106.132:1521 :devORA/property property name=connection.usernamexwiki/property property name=connection.passwordxwiki/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver /property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConne ctionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ mapping resource=activitystream.hbm.xml/ property name=hibernate.query.factory_classorg.hibernate.hql.classic .ClassicQueryTranslatorFactory/property /session-factory /hibernate-configuration 4. We still get this error. We can simply connect to the xwiki users on the solaris console with sqlplus, but we cannot get it work. The user for the xwiki has all privileges to work the database. We cannot understand what goes wrong. Is there a simple how to how to really xwiki working on oracle 10g? Thank you very much. HTTP Status 500 - _ type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: com.xpn.xwiki.XWikiException: 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: invalid
Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Here what we did is that we installed Xwiki from the pack jetty/HSQL. Once it work, we modified the hibernate configuration file to connect to Oracle DB. Here is our config file (if it helps ...) : ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory property name=show_sqlfalse/property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property property name=connection.urljdbc:oracle:thin:@IP.IP.IP.IP:1521:od46/property property name=connection.usernamexwiki/property property name=connection.password*/property property name=connection.driver_classoracle.jdbc.driver.OracleDriver/property property name=dialectorg.hibernate.dialect.Oracle10gDialect/property property name=connection.provider_classcom.xpn.xwiki.store.DBCPConnectionProvider/property property name=connection.pool_size2/property property name=statement_cache.size2/property property name=hibernate.connection.SetBigStringTryClobtrue/property property name=hibernate.jdbc.batch_size0/property mapping resource=xwiki.oracle.hbm.xml/ mapping resource=feeds.oracle.hbm.xml/ /session-factory /hibernate-configuration -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 08:13 À : XWiki Users Objet : Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g Yes, I forgot to mention it, we copied it from the oracle folder, we copied this files: ojdbc14.jar orai18n.jar And we also tried it with ojdbc5.jar It getting us really crazy on this. 2010/1/19 PERINAUD Christophe christophe.perin...@kbl-bank.com Hi, Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder ? Christophe Périnaud Windows Server 2003 SP2 in a VMWare instance Oracle 10g Java 1.6.0_12 Xwiki 2.0.3 from the pack Jetty/HSQL -Message d'origine- De : users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] De la part de Oskar Marek Rzepinski Envoyé : mardi 19 janvier 2010 07:58 À : users@xwiki.org Objet : [xwiki-users] Problem with getting Xwiki to work with Oracle10g Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate configuration file, as you can see: ?xml version='1.0' encoding='utf-8'? !DOCTYPE hibernate-configuration PUBLIC -//Hibernate/Hibernate Configuration DTD//EN http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd; hibernate-configuration session-factory !-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) -- !-- Generic parameters common to all Databases -- property name=show_sqlfalse/ property property name=use_outer_jointrue/property property name=dbcp.defaultAutoCommitfalse/property property name=dbcp.maxActive50/property property name=dbcp.maxIdle5/property property name=dbcp.maxWait3/property property name=dbcp.whenExhaustedAction1/property property name=dbcp.ps.whenExhaustedAction1/property property name=dbcp.ps.maxActive20/property property name=dbcp.ps.maxWait12/property property name=dbcp.ps.maxIdle20/property !-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. -- property name=jdbc.use_scrollable_resultsetfalse/property !-- Oracle configuration. Uncomment if you want to use Oracle and comment out other database configurations. Note
