- xwiki-users@xwiki.org - lists.xwiki.org

[xwiki-users] Problem with getting Xwiki to work with Oracle10g
by Oskar Marek Rzepinski 21 Jan '10

21 Jan '10

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>   <property name="show_sql">false</ property> <property name="use_outer_join">true</property> <property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxActive">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWait">30000</property> <property name="dbcp.whenExhaustedAction">1</property> <property name="dbcp.ps.whenExhaustedAction">1</property> <property name="dbcp.ps.maxActive">20</property> <property name="dbcp.ps.maxWait">120000</property> <property name="dbcp.ps.maxIdle">20</property>  <property name="jdbc.use_scrollable_resultset">false</property>  <property name="connection.url">jdbc:oracle:thin:@10.233.106.132:1521 :devORA</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <property name="hibernate.connection.SetBigStringTryClob">true</property> <property name="hibernate.jdbc.batch_size">0</property> <mapping resource="xwiki.oracle.hbm.xml"/> <mapping resource="feeds.oracle.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <property name="hibernate.query.factory_class">org.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 cause 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 com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:341) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:402) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) 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) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs. _____ Apache Tomcat/6.0.18 sincerely Oskar

3 3

[xwiki-users] Problems with trying to add links to specific spaces in the Quick Links panel
by Xavier Bartholome 21 Jan '10

21 Jan '10

Hi All, I'm trying to add links to various Spaces to the QuickLinks panel, but I can't seem to get the code right ... I'm trying to link to a Space called 'Infos Utiles', which is at http://localhost:8080/xwiki/bin/view/Infos+utiles/ I copied the code that links to the Sandbox => * [$msg.get("xe.panels.quicklinks.sandbox")>Sandbox.WebHome] And I guess that I should adapt the xe.panels.quicklinks.sandbox to xe.panels.quicklinks.infos+utiles and the Sandbox.WebHome to Infos+Utiles.WebHome I'm not sure about the '+', but anyway, when I save it, my panel has the following link : xe.panels.quicklinks.infos+utiles<http://192.168.5.165:8080/xwiki/bin/edit/Infos%2BUtiles/WebHome?parent=Pane…>that goes to http://localhost:8080/xwiki/bin/edit/InfosUtiles/WebHome?parent=Panels.Quic… What am I doing wrong?

3 2

Re: [xwiki-users] Meta+G feature on XEM
by Dilipkumar Jadhav 20 Jan '10

20 Jan '10

Hi Sergiu, Thanks for filing this issue as a bug & your prompt response. > The JS code will have to be fixed, I'll work on it, see > http://jira.xwiki.org/jira/browse/XWIKI-4773

1 0

Re: [xwiki-users] Meta+G feature on XEM
by Dilipkumar Jadhav 20 Jan '10

20 Jan '10

Hi Sergiu, Sorry about the delay in response. I checked the httpheader. It is exactly what you had stated. It accesses the rest api & is in the "${request.contextPath}/rest/wikis/${context.database}/search?scope=name&number=10&media=json&" format. Even though I am in the child wiki the ${context.database} still says "xwiki"...It should say "draft" where draft is the name of the child wiki. Since, the wikis I use are path based wikis, do I need to make any change somewhere to make the auto suggest to work. Or would I have to go to url based wikis (with different domain names). At the same time, I've an application which uses XWiki RESTful api without any modifications at all despite the XEM being path based. Please help...thanks. > > Message: 1 > Date: Wed, 20 Jan 2010 12:17:58 -0500 > From: Dilipkumar Jadhav <jadhav.dilipkumar(a)gmail.com> > Subject: Re: [xwiki-users] Meta+G feature on XEM > To: users(a)xwiki.org > Message-ID: > <a5b160b51001200917q6f4e7116oee4e4e59c5a4ef46(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Thanks for your quick response Sergiu. The wiki is a path-based wiki. > > >> >> That is strange, it should work perfectly well in a virtual wiki, and >> you can try to see that it works on the *.xwiki.org farm, and on >> incubator.myxwiki.org. >> >> You can check with Firebug or HttpHeaders to check where does the >> suggest request go to, maybe there's something weird in the URL setup. >> >> Normally, the request goes to something like: >> >> "${request.contextPath}/rest/wikis/${context.database}/search?scope=name&number=10&media=json&" >> >> Here, ${request.contextPath} is usually /xwiki, and ${context.database} >> is the name of the virtual wiki. >> >> Could it be that you're using a path-based virtual wiki? >> >> -- >> Sergiu Dumitriu >> http://purl.org/net/sergiu/ >> > >

2 1

Re: [xwiki-users] Meta+G feature on XEM
by Dilipkumar Jadhav 20 Jan '10

20 Jan '10

Thanks for your quick response Sergiu. The wiki is a path-based wiki. > > That is strange, it should work perfectly well in a virtual wiki, and > you can try to see that it works on the *.xwiki.org farm, and on > incubator.myxwiki.org. > > You can check with Firebug or HttpHeaders to check where does the > suggest request go to, maybe there's something weird in the URL setup. > > Normally, the request goes to something like: > > "${request.contextPath}/rest/wikis/${context.database}/search?scope=name&number=10&media=json&" > > Here, ${request.contextPath} is usually /xwiki, and ${context.database} > is the name of the virtual wiki. > > Could it be that you're using a path-based virtual wiki? > > -- > Sergiu Dumitriu > http://purl.org/net/sergiu/ >

1 0

[xwiki-users] Meta+G feature on XEM
by Dilipkumar Jadhav 20 Jan '10

20 Jan '10

Hello folks, The Meta+G feature is one of the coolest & widely used feature at my organization. I am trying to use the Meta+G/Jump To Page feature over XEM 2.1.1 "wikis". The feature works fine over the "Main" XWiki instance. However, when I use this from a child wiki in a wiki farm, it still picks it's pages from the main XEM instance. It does not pickup any documents from the child farm. I checked the JIRA for the Meta+G feature but couldn't find any documentation in this regard. Can we change something in the ajaxSuggest.js so it will pick pages from the child wikis? Is there a page called XWiki.JumpToPage such as mentioned on http://jira.xwiki.org/jira/browse/XWIKI-1485 where we could probably point the ajax suggest to the appropriate child wiki. I looked up my XWiki instance but could not find this JumpToPage. Any help will be appreciated. Thank you.

2 1

Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
by PERINAUD Christophe 19 Jan '10

19 Jan '10

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-bounces(a)xwiki.org [mailto:users-bounces@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 <rzepinski(a)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 <calebdelisle(a)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_sql">false</property> > >> > <property name="use_outer_join">true</property> > >> > <property name="dbcp.defaultAutoCommit">false</property> > >> > <property name="dbcp.maxActive">50</property> > >> > <property name="dbcp.maxIdle">5</property> > >> > <property name="dbcp.maxWait">30000</property> > >> > <property name="dbcp.whenExhaustedAction">1</property> > >> > <property name="dbcp.ps.whenExhaustedAction">1</property> > >> > <property name="dbcp.ps.maxActive">20</property> > >> > <property name="dbcp.ps.maxWait">120000</property> > >> > <property name="dbcp.ps.maxIdle">20</property> > >> > <property > name="connection.url">jdbc:oracle:thin:@IP.IP.IP.IP > >> :1521:od46</property> > >> > <property name="connection.username">xwiki</property> > >> > <property name="connection.password">*********</property> > >> > <property > >> > name="connection.driver_class">oracle.jdbc.driver.OracleDriver > </property> > >> > <property > >> name="dialect">org.hibernate.dialect.Oracle10gDialect</property> > >> > <property > >> > name="connection.provider_class">com.xpn.xwiki.store.DBCPConne > ctionProvider</property> > >> > <property name="connection.pool_size">2</property> > >> > <property name="statement_cache.size">2</property> > >> > <property > >> name="hibernate.connection.SetBigStringTryClob">true</property> > >> > <property name="hibernate.jdbc.batch_size">0</property> > >> > <mapping resource="xwiki.oracle.hbm.xml"/> > >> > <mapping resource="feeds.oracle.hbm.xml"/> > >> > </session-factory> > >> > </hibernate-configuration> > >> > > >> > > >> >> -----Message d'origine----- > >> >> De : users-bounces(a)xwiki.org [mailto:users-bounces@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.PERINAUD(a)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-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] > >> >>>> De la part de Oskar Marek Rzepinski > >> >>>> Envoyé : mardi 19 janvier 2010 07:58 > >> >>>> À : users(a)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> > >> >>>> > >> >>>>  > >> >>>> > >> >>>>  > >> >>>> > >> >>>> <property name="show_sql">false</ > >> >>>> property> > >> >>>> <property name="use_outer_join">true</property> > >> >>>> > >> >>>> <property name="dbcp.defaultAutoCommit">false</property> > >> >>>> <property name="dbcp.maxActive">50</property> > >> >>>> <property name="dbcp.maxIdle">5</property> > >> >>>> <property name="dbcp.maxWait">30000</property> > >> >>>> <property name="dbcp.whenExhaustedAction">1</property> > >> >>>> <property name="dbcp.ps.whenExhaustedAction">1</property> > >> >>>> <property name="dbcp.ps.maxActive">20</property> > >> >>>> <property name="dbcp.ps.maxWait">120000</property> > >> >>>> <property name="dbcp.ps.maxIdle">20</property> > >> >>>>  > >> >>>> <property > name="jdbc.use_scrollable_resultset">false</property> > >> >>>> > >> >>>>  > >> >>>> <property > >> >>>> name="connection.url">jdbc:oracle:thin:@10.233.106.132:1521 > >> >>>> :devORA</property> > >> >>>> <property name="connection.username">xwiki</property> > >> >>>> <property name="connection.password">xwiki</property> > >> >>>> <property > >> >>>> name="connection.driver_class">oracle.jdbc.driver.OracleDriver > >> >>>> </property> > >> >>>> <property > >> >>>> > name="dialect">org.hibernate.dialect.Oracle10gDialect</property> > >> >>>> <property > >> >>>> name="connection.provider_class">com.xpn.xwiki.store.DBCPConne > >> >>>> ctionProvider</property> > >> >>>> <property name="connection.pool_size">2</property> > >> >>>> <property name="statement_cache.size">2</property> > >> >>>> <property > >> >>>> > name="hibernate.connection.SetBigStringTryClob">true</property> > >> >>>> <property name="hibernate.jdbc.batch_size">0</property> > >> >>>> <mapping resource="xwiki.oracle.hbm.xml"/> > >> >>>> <mapping resource="feeds.oracle.hbm.xml"/> > >> >>>> <mapping resource="activitystream.hbm.xml"/> > >> >>>> > >> >>>> <property > >> >>>> name="hibernate.query.factory_class">org.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(ActionServlet.j > >> >>>> ava: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(XWikiDavFi > >> >>>> lter.java:68) > >> >>>> > >> >>>> > >> >>>> com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedReq > >> >>>> uestRestorerFilter.java:295) > >> >>>> > >> >>>> > >> >>>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetChara > >> >>>> cterEncodingFilter.java:112) > >> >>>> > >> >>>> root cause > >> >>>> > >> >>>> 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 > >> >>>> com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:341) > >> >>>> com.xpn.xwiki.XWiki.getXWiki(XWiki.java:402) > >> >>>> > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) > >> >>>> > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) > >> >>>> > >> >>>> > >> >>>> org.apache.struts.action.RequestProcessor.processActionPerform > >> >>>> (RequestProcessor.java:431) > >> >>>> > >> >>>> > >> >>>> org.apache.struts.action.RequestProcessor.process(RequestProce > >> >>>> ssor.java:236) > >> >>>> > >> >>>> > >> >>>> org.apache.struts.action.ActionServlet.process(ActionServlet.j > >> >>>> ava: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(XWikiDavFi > >> >>>> lter.java:68) > >> >>>> > >> >>>> > >> >>>> com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedReq > >> >>>> uestRestorerFilter.java:295) > >> >>>> > >> >>>> > >> >>>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetChara > >> >>>> cterEncodingFilter.java:112) > >> >>>> > >> >>>> note The full stack trace of the root cause is available > >> >> in the Apache > >> >>>> Tomcat/6.0.18 logs. > >> >>>> > >> >>>> _____ > >> >>>> > >> >>>> > >> >>>> Apache Tomcat/6.0.18 > >> >>>> > >> >>>> > >> >>>> > >> >>>> > >> >>>> sincerely Oskar > >> >>>> _______________________________________________ > >> >>>> users mailing list > >> >>>> users(a)xwiki.org > >> >>>> http://lists.xwiki.org/mailman/listinfo/users > >> >>>> > >> >>> > >> >> -------------------------------------------------------------- > >> >> ------------------ > >> >>> This e-mail is intended only for the addressee named above. > >> >> It does not > >> >>> bind the sender, except in the case of an existing written > >> >> convention with > >> >>> the addressee. This e-mail may contain material that is > >> >> confidential and > >> >>> privileged for the sole use of the intended recipient. Any > >> >> review, reliance > >> >>> or distribution by others or forwarding without express > >> >> permission is > >> >>> strictly prohibited and may be unlawful. If you are > not the intended > >> >>> recipient, please contact the sender and delete all copies. > >> >>> > >> >>> While reasonable precautions have been taken to ensure that > >> >> this e-mail and > >> >>> any attachments are free from any computer virus or similar > >> >> defect, no > >> >>> liability will be accepted in that respect. Anyone > >> >> accessing this e-mail > >> >>> must take their own precautions as to security and > virus protection. > >> >>> > >> >>> KBL European Private Bankers S.A., 43 boulevard Royal > >> >> L-2955 Luxembourg, > >> >>> R.C.S. Luxembourg B 6395, T (352) 47 97 1 > >> >>> _______________________________________________ > >> >>> users mailing list > >> >>> users(a)xwiki.org > >> >>> http://lists.xwiki.org/mailman/listinfo/users > >> >>> > >> >> _______________________________________________ > >> >> users mailing list > >> >> users(a)xwiki.org > >> >> http://lists.xwiki.org/mailman/listinfo/users > >> >> > >> > > >> > -------------------------------------------------------------- > ------------------ > >> > > >> > This e-mail is intended only for the addressee named > above. It does not > >> bind the sender, except in the case of an existing written > convention with > >> the addressee. This e-mail may contain material that is > confidential and > >> privileged for the sole use of the intended recipient. Any > review, reliance > >> or distribution by others or forwarding without express > permission is > >> strictly prohibited and may be unlawful. If you are not > the intended > >> recipient, please contact the sender and delete all copies. > >> > > >> > While reasonable precautions have been taken to ensure > that this e-mail > >> and any attachments are free from any computer virus or > similar defect, no > >> liability will be accepted in that respect. Anyone > accessing this e-mail > >> must take their own precautions as to security and virus > protection. > >> > > >> > KBL European Private Bankers S.A., 43 boulevard Royal > L-2955 Luxembourg, > >> R.C.S. Luxembourg B 6395, T (352) 47 97 1 > >> > _______________________________________________ > >> > users mailing list > >> > users(a)xwiki.org > >> > http://lists.xwiki.org/mailman/listinfo/users > >> > > >> > >> _______________________________________________ > >> users mailing list > >> users(a)xwiki.org > >> http://lists.xwiki.org/mailman/listinfo/users > >> > > > > > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > -------------------------------------------------------------------------------- This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies. While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection. KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1

1 0

Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
by PERINAUD Christophe 19 Jan '10

19 Jan '10

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-bounces(a)xwiki.org [mailto:users-bounces@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 <rzepinski(a)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 <calebdelisle(a)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_sql">false</property> > >> > <property name="use_outer_join">true</property> > >> > <property name="dbcp.defaultAutoCommit">false</property> > >> > <property name="dbcp.maxActive">50</property> > >> > <property name="dbcp.maxIdle">5</property> > >> > <property name="dbcp.maxWait">30000</property> > >> > <property name="dbcp.whenExhaustedAction">1</property> > >> > <property name="dbcp.ps.whenExhaustedAction">1</property> > >> > <property name="dbcp.ps.maxActive">20</property> > >> > <property name="dbcp.ps.maxWait">120000</property> > >> > <property name="dbcp.ps.maxIdle">20</property> > >> > <property > name="connection.url">jdbc:oracle:thin:@IP.IP.IP.IP > >> :1521:od46</property> > >> > <property name="connection.username">xwiki</property> > >> > <property name="connection.password">*********</property> > >> > <property > >> > name="connection.driver_class">oracle.jdbc.driver.OracleDriver </property> > >> > <property > >> name="dialect">org.hibernate.dialect.Oracle10gDialect</property> > >> > <property > >> > name="connection.provider_class">com.xpn.xwiki.store.DBCPConne ctionProvider</property> > >> > <property name="connection.pool_size">2</property> > >> > <property name="statement_cache.size">2</property> > >> > <property > >> name="hibernate.connection.SetBigStringTryClob">true</property> > >> > <property name="hibernate.jdbc.batch_size">0</property> > >> > <mapping resource="xwiki.oracle.hbm.xml"/> > >> > <mapping resource="feeds.oracle.hbm.xml"/> > >> > </session-factory> > >> > </hibernate-configuration> > >> > > >> > > >> >> -----Message d'origine----- > >> >> De : users-bounces(a)xwiki.org [mailto:users-bounces@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.PERINAUD(a)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-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] > >> >>>> De la part de Oskar Marek Rzepinski > >> >>>> Envoyé : mardi 19 janvier 2010 07:58 > >> >>>> À : users(a)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> > >> >>>> > >> >>>>  > >> >>>> > >> >>>>  > >> >>>> > >> >>>> <property name="show_sql">false</ > >> >>>> property> > >> >>>> <property name="use_outer_join">true</property> > >> >>>> > >> >>>> <property name="dbcp.defaultAutoCommit">false</property> > >> >>>> <property name="dbcp.maxActive">50</property> > >> >>>> <property name="dbcp.maxIdle">5</property> > >> >>>> <property name="dbcp.maxWait">30000</property> > >> >>>> <property name="dbcp.whenExhaustedAction">1</property> > >> >>>> <property name="dbcp.ps.whenExhaustedAction">1</property> > >> >>>> <property name="dbcp.ps.maxActive">20</property> > >> >>>> <property name="dbcp.ps.maxWait">120000</property> > >> >>>> <property name="dbcp.ps.maxIdle">20</property> > >> >>>>  > >> >>>> <property > name="jdbc.use_scrollable_resultset">false</property> > >> >>>> > >> >>>>  > >> >>>> <property > >> >>>> name="connection.url">jdbc:oracle:thin:@10.233.106.132:1521 > >> >>>> :devORA</property> > >> >>>> <property name="connection.username">xwiki</property> > >> >>>> <property name="connection.password">xwiki</property> > >> >>>> <property > >> >>>> name="connection.driver_class">oracle.jdbc.driver.OracleDriver > >> >>>> </property> > >> >>>> <property > >> >>>> > name="dialect">org.hibernate.dialect.Oracle10gDialect</property> > >> >>>> <property > >> >>>> name="connection.provider_class">com.xpn.xwiki.store.DBCPConne > >> >>>> ctionProvider</property> > >> >>>> <property name="connection.pool_size">2</property> > >> >>>> <property name="statement_cache.size">2</property> > >> >>>> <property > >> >>>> > name="hibernate.connection.SetBigStringTryClob">true</property> > >> >>>> <property name="hibernate.jdbc.batch_size">0</property> > >> >>>> <mapping resource="xwiki.oracle.hbm.xml"/> > >> >>>> <mapping resource="feeds.oracle.hbm.xml"/> > >> >>>> <mapping resource="activitystream.hbm.xml"/> > >> >>>> > >> >>>> <property > >> >>>> name="hibernate.query.factory_class">org.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(ActionServlet.j > >> >>>> ava: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(XWikiDavFi > >> >>>> lter.java:68) > >> >>>> > >> >>>> > >> >>>> com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedReq > >> >>>> uestRestorerFilter.java:295) > >> >>>> > >> >>>> > >> >>>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetChara > >> >>>> cterEncodingFilter.java:112) > >> >>>> > >> >>>> root cause > >> >>>> > >> >>>> 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 > >> >>>> com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:341) > >> >>>> com.xpn.xwiki.XWiki.getXWiki(XWiki.java:402) > >> >>>> > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) > >> >>>> > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) > >> >>>> > >> >>>> > >> >>>> org.apache.struts.action.RequestProcessor.processActionPerform > >> >>>> (RequestProcessor.java:431) > >> >>>> > >> >>>> > >> >>>> org.apache.struts.action.RequestProcessor.process(RequestProce > >> >>>> ssor.java:236) > >> >>>> > >> >>>> > >> >>>> org.apache.struts.action.ActionServlet.process(ActionServlet.j > >> >>>> ava: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(XWikiDavFi > >> >>>> lter.java:68) > >> >>>> > >> >>>> > >> >>>> com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedReq > >> >>>> uestRestorerFilter.java:295) > >> >>>> > >> >>>> > >> >>>> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetChara > >> >>>> cterEncodingFilter.java:112) > >> >>>> > >> >>>> note The full stack trace of the root cause is available > >> >> in the Apache > >> >>>> Tomcat/6.0.18 logs. > >> >>>> > >> >>>> _____ > >> >>>> > >> >>>> > >> >>>> Apache Tomcat/6.0.18 > >> >>>> > >> >>>> > >> >>>> > >> >>>> > >> >>>> sincerely Oskar > >> >>>> _______________________________________________ > >> >>>> users mailing list > >> >>>> users(a)xwiki.org > >> >>>> http://lists.xwiki.org/mailman/listinfo/users > >> >>>> > >> >>> > >> >> -------------------------------------------------------------- > >> >> ------------------ > >> >>> This e-mail is intended only for the addressee named above. > >> >> It does not > >> >>> bind the sender, except in the case of an existing written > >> >> convention with > >> >>> the addressee. This e-mail may contain material that is > >> >> confidential and > >> >>> privileged for the sole use of the intended recipient. Any > >> >> review, reliance > >> >>> or distribution by others or forwarding without express > >> >> permission is > >> >>> strictly prohibited and may be unlawful. If you are > not the intended > >> >>> recipient, please contact the sender and delete all copies. > >> >>> > >> >>> While reasonable precautions have been taken to ensure that > >> >> this e-mail and > >> >>> any attachments are free from any computer virus or similar > >> >> defect, no > >> >>> liability will be accepted in that respect. Anyone > >> >> accessing this e-mail > >> >>> must take their own precautions as to security and > virus protection. > >> >>> > >> >>> KBL European Private Bankers S.A., 43 boulevard Royal > >> >> L-2955 Luxembourg, > >> >>> R.C.S. Luxembourg B 6395, T (352) 47 97 1 > >> >>> _______________________________________________ > >> >>> users mailing list > >> >>> users(a)xwiki.org > >> >>> http://lists.xwiki.org/mailman/listinfo/users > >> >>> > >> >> _______________________________________________ > >> >> users mailing list > >> >> users(a)xwiki.org > >> >> http://lists.xwiki.org/mailman/listinfo/users > >> >> > >> > > >> > -------------------------------------------------------------- > ------------------ > >> > > >> > This e-mail is intended only for the addressee named > above. It does not > >> bind the sender, except in the case of an existing written > convention with > >> the addressee. This e-mail may contain material that is > confidential and > >> privileged for the sole use of the intended recipient. Any > review, reliance > >> or distribution by others or forwarding without express > permission is > >> strictly prohibited and may be unlawful. If you are not > the intended > >> recipient, please contact the sender and delete all copies. > >> > > >> > While reasonable precautions have been taken to ensure > that this e-mail > >> and any attachments are free from any computer virus or > similar defect, no > >> liability will be accepted in that respect. Anyone > accessing this e-mail > >> must take their own precautions as to security and virus > protection. > >> > > >> > KBL European Private Bankers S.A., 43 boulevard Royal > L-2955 Luxembourg, > >> R.C.S. Luxembourg B 6395, T (352) 47 97 1 > >> > _______________________________________________ > >> > users mailing list > >> > users(a)xwiki.org > >> > http://lists.xwiki.org/mailman/listinfo/users > >> > > >> > >> _______________________________________________ > >> users mailing list > >> users(a)xwiki.org > >> http://lists.xwiki.org/mailman/listinfo/users > >> > > > > > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > -------------------------------------------------------------------------------- This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies. While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection. KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1

1 0

Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
by PERINAUD Christophe 19 Jan '10

19 Jan '10

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-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] > De la part de Oskar Marek Rzepinski > Envoyé : mardi 19 janvier 2010 07:58 > À : users(a)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> > >  > >  > > <property name="show_sql">false</ > property> > <property name="use_outer_join">true</property> > > <property name="dbcp.defaultAutoCommit">false</property> > <property name="dbcp.maxActive">50</property> > <property name="dbcp.maxIdle">5</property> > <property name="dbcp.maxWait">30000</property> > <property name="dbcp.whenExhaustedAction">1</property> > <property name="dbcp.ps.whenExhaustedAction">1</property> > <property name="dbcp.ps.maxActive">20</property> > <property name="dbcp.ps.maxWait">120000</property> > <property name="dbcp.ps.maxIdle">20</property> >  > <property name="jdbc.use_scrollable_resultset">false</property> > >  > <property > name="connection.url">jdbc:oracle:thin:@10.233.106.132:1521 > :devORA</property> > <property name="connection.username">xwiki</property> > <property name="connection.password">xwiki</property> > <property > name="connection.driver_class">oracle.jdbc.driver.OracleDriver > </property> > <property > name="dialect">org.hibernate.dialect.Oracle10gDialect</property> > <property > name="connection.provider_class">com.xpn.xwiki.store.DBCPConne > ctionProvider</property> > <property name="connection.pool_size">2</property> > <property name="statement_cache.size">2</property> > <property > name="hibernate.connection.SetBigStringTryClob">true</property> > <property name="hibernate.jdbc.batch_size">0</property> > <mapping resource="xwiki.oracle.hbm.xml"/> > <mapping resource="feeds.oracle.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > > <property > name="hibernate.query.factory_class">org.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(ActionServlet.j > ava: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(XWikiDavFi > lter.java:68) > > > com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedReq > uestRestorerFilter.java:295) > > > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetChara > cterEncodingFilter.java:112) > > root cause > > 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 > com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:341) > com.xpn.xwiki.XWiki.getXWiki(XWiki.java:402) > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) > com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) > > > org.apache.struts.action.RequestProcessor.processActionPerform > (RequestProcessor.java:431) > > > org.apache.struts.action.RequestProcessor.process(RequestProce > ssor.java:236) > > > org.apache.struts.action.ActionServlet.process(ActionServlet.j > ava: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(XWikiDavFi > lter.java:68) > > > com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedReq > uestRestorerFilter.java:295) > > > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetChara > cterEncodingFilter.java:112) > > note The full stack trace of the root cause is available in the Apache > Tomcat/6.0.18 logs. > > _____ > > > Apache Tomcat/6.0.18 > > > > > sincerely Oskar > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > -------------------------------------------------------------------------------- This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies. While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection. KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1

2 1

[xwiki-users] Tags auto suggest
by Ziggy 18 Jan '10

18 Jan '10

Im running a wiki farm and when i log on as the admin user on the wiki farm main page the "Tags auto suggest" feature does work. But when i log on as a normal user on one of the wikis, the auto suggest feature does not suggest any tags even though there are about 10 tags already in place. Does anyone know why this happens?

2 1