November 2006 - xwiki-users@xwiki.org

Antwort: [xwiki-users] How can i change/move a xwiki page
by Kristian Marinkovic 29 Nov '06

29 Nov '06

4 7

xwiki.renameDocument()
by kristian.marinkovic＠porsche.co.at 29 Nov '06

29 Nov '06

hi, has anyone successfully used the renameDocument method ? i experience odd errors when using it. when i rename a page the attachments disappear and you get a velocity exception. Before you delete such a corrupted/renamed page you have to delete the attachments beforehand, otherwise you'll get a hibernate exception. org.hibernate.StaleStateException: Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1 greetings, kris

3 2

Re: [xwiki-users] xwiki & oracle 10g R2
by Victor Orgos 28 Nov '06

28 Nov '06

Hi, My DB guys got the mysql database across and now when I try to access it, it displays part of the page with errors in the middle. The error starts with: Error number 3202 in 3: Exception while reading document Main.WebHome Wrapped Exception: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of com.xpn.xwiki.doc.XWikiDocument.setParent com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document Main.WebHomeand in the xwiki.log file I get: XWikiHibernateStore:updateSchema:172 - Schema update deactivated for wiki xwiki ORA-00932: inconsistent datatypes: expected - got CLOB Makes no difference if I use your xwiki.hbm.xml or the default one. How can I find out which table/field its having problems with? Vic ----- Original Message ---- From: Victor Orgos <v_orgos(a)yahoo.com.au> To: xwiki-users(a)objectweb.org Sent: Friday, 24 November, 2006 5:41:46 PM Subject: Re: [xwiki-users] xwiki & oracle 10g R2 Thanks for clearing that up John. I got our Oracle/SQL guru involved and he tells me that there is a program to convert the MySQL data to Oracle. So we'll give that a go. Regards, Vic ----- Original Message ---- From: "Turner, John" <John.Turner3(a)team.telstra.com> To: xwiki-users(a)objectweb.org Sent: Friday, 24 November, 2006 1:37:36 PM Subject: RE: [xwiki-users] xwiki & oracle 10g R2 Vic, You need to seed your database with the data that is shipped for the XWiki MySQL database. If you haven't done that it could explain why you get nothing when you fire up the application. The seed data includes stuff like the admin user and admin pages, etc. There is a database script that I think you can download separately from the XWiki site. It will insert the seed data into a MySQL database. You some how need to get that data into your Oracle DB. I had to load the data into a MySQL database and then write a program that copied the data to my Oracle 9i DB (unfortunately I can't release my program, or a copy of my data to you). You'll have to come up with some strategy for doing something similar - maybe you can edit the script to make it insert into a 10g DB? One other point is that the Oracle 9i JDBC thin driver had a limitation on the size of LOBs it could handle - that's why I used the thick driver. You need an Oracle client install on your application server in order to use the thick driver. This may no longer be an issue with the Oracle 10g JDBC driver. Regards, John ________________________________ From: Victor Orgos [mailto:v_orgos@yahoo.com.au] Sent: Friday, 24 November 2006 10:52 AM To: xwiki-users(a)objectweb.org Subject: [xwiki-users] xwiki & oracle 10g R2 Hi, I am attempting to get xwiki (version 0-9-840) to work with Oracle 10g R2 and I'm stuck. My DBA has created the user and loaded the schema. I'm using the ojdbc14.jar that comes with this version of Oracle. When I try to access http://localhost:8080/xwiki/bin/view/Main/WebHome with the following settings: <property name="connection.url">jdbc:oracle:thin:@localhost:1521:vicdev</property> <property name="connection.username">wiki</property> <property name="connection.password">itadmin</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property > <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvi der</property> <property name="connection.pool_size">50</property> <property name="statement_cache.size">50</property> <property name="dialect">org.hibernate.dialect.OracleDialect</property> it fails with the following in the logs: 12:32:11,861 WARN http-8080-Processor25 RequestUtils:createActionForm:177 - No FormBeanConfig found under 'view' 12:32:13,968 WARN http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers Configurator:configure:126 - No c onfiguration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: file:/usr/local/jakarta-tomcat-5.0.28/work /Catalina/localhost/xwiki/loader/ehcache-failsafe.xml 12:32:16,657 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:updateSchema: 177 - Schema update for wiki xwiki 12:32:19,766 WARN http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCExceptionReporter:logExceptio ns:71 - SQL Error: 932, SQLState: 42000 12:32:19,768 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCExceptionReporter:logExceptio ns:72 - ORA-00932: inconsistent datatypes: expected - got CLOB When I saw the ORA-00932 error, I found John Turner's String2 java class and configuration files in an earlier thread. I've since compiled the class and created a jar which I've placed in WEB-INF/lib/ directory. This didn't work and I got an error about the connection URL <property name="connection.url">jdbc:oracle:oci:@localhost:1521:vicdev</property> I changed this back to thin instead and now xwiki can connect successfully to the database. BUT nothing happens! Browser says loading and nothing much else happens. Its very frustrating. I've been trying to get this to work for the last 4 days with no luck. - Do I need to make any configuration changes to Tomcat after installation? - There has been talk in the list about importing a MySQL dump into Oracle to get this working, but no mention of this in the xwiki.org site. I'd appreciate any help to get this working. Regards, Vic Send instant messages to your online friends http://au.messenger.yahoo.com -- You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws Send instant messages to your online friends http://au.messenger.yahoo.com -- You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws Send instant messages to your online friends http://au.messenger.yahoo.com

2 1

Canno't access to the login page
by Xavier MOGHRABI 27 Nov '06

27 Nov '06

Dear XWiki Users, I've a critical problem with a wiki inside the ObjectWeb XWiki farm. In fact, we cannot acess any more to the login page. Thus it is impossible to us to modify the wiki. The affected wiki is : http://wiki.bonita.objectweb.org/xwiki/bin/login/XWiki/XWikiLogin When I look at the log of Tomcat. I can see that the URL is transform into : 17:31:18,260 WARN TP-Processor30 http://wiki.bonita.objectweb.org/xwiki/bin/loginerror/XWiki/XWikiLogin MonitorData:log:188 - MONITOR : 2ms 17:31:18,295 WARN TP-Processor30 http://wiki.bonita.objectweb.org/xwiki/bin/loginerror/XWiki/XWikiLogin MonitorData:log:188 - MONITOR XWiki.XWikiLogin: 35ms Does anyone know what happened on my Wiki ? Regards -- Xavier MOGHRABI - Consortium ObjectWeb Jabber: moghrabi(a)jabber.objectweb.org Phone: +33 4 76 61 52 35

2 1

How can i change/move a xwiki page
by kristian.marinkovic＠porsche.co.at 24 Nov '06

24 Nov '06

Hello, my xwiki system has several documents with incorrect names eg.: A.B.C.index should be A.B.D.index which datafields (and what tables) do i have to change in order to achieve a page move? i tried to modify the xwd_fullname, xwd_web, xwd_parent and xwd_name columns in the XWIKIDOC table but it doesnt work. I also checked the data within XWIKILINKS. I was also unable to determine where xwiki get its document ids (XWD_ID) at startup. Maybe someone could point me to the correct sources :) can somebody help me? g, kris

1 0

Re: [xwiki-users] xwiki & oracle 10g R2
by Victor Orgos 24 Nov '06

24 Nov '06

Thanks for clearing that up John. I got our Oracle/SQL guru involved and he tells me that there is a program to convert the MySQL data to Oracle. So we'll give that a go. Regards, Vic ----- Original Message ---- From: "Turner, John" <John.Turner3(a)team.telstra.com> To: xwiki-users(a)objectweb.org Sent: Friday, 24 November, 2006 1:37:36 PM Subject: RE: [xwiki-users] xwiki & oracle 10g R2 Vic, You need to seed your database with the data that is shipped for the XWiki MySQL database. If you haven't done that it could explain why you get nothing when you fire up the application. The seed data includes stuff like the admin user and admin pages, etc. There is a database script that I think you can download separately from the XWiki site. It will insert the seed data into a MySQL database. You some how need to get that data into your Oracle DB. I had to load the data into a MySQL database and then write a program that copied the data to my Oracle 9i DB (unfortunately I can't release my program, or a copy of my data to you). You'll have to come up with some strategy for doing something similar - maybe you can edit the script to make it insert into a 10g DB? One other point is that the Oracle 9i JDBC thin driver had a limitation on the size of LOBs it could handle - that's why I used the thick driver. You need an Oracle client install on your application server in order to use the thick driver. This may no longer be an issue with the Oracle 10g JDBC driver. Regards, John ________________________________ From: Victor Orgos [mailto:v_orgos@yahoo.com.au] Sent: Friday, 24 November 2006 10:52 AM To: xwiki-users(a)objectweb.org Subject: [xwiki-users] xwiki & oracle 10g R2 Hi, I am attempting to get xwiki (version 0-9-840) to work with Oracle 10g R2 and I'm stuck. My DBA has created the user and loaded the schema. I'm using the ojdbc14.jar that comes with this version of Oracle. When I try to access http://localhost:8080/xwiki/bin/view/Main/WebHome with the following settings: <property name="connection.url">jdbc:oracle:thin:@localhost:1521:vicdev</property> <property name="connection.username">wiki</property> <property name="connection.password">itadmin</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property > <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvi der</property> <property name="connection.pool_size">50</property> <property name="statement_cache.size">50</property> <property name="dialect">org.hibernate.dialect.OracleDialect</property> it fails with the following in the logs: 12:32:11,861 WARN http-8080-Processor25 RequestUtils:createActionForm:177 - No FormBeanConfig found under 'view' 12:32:13,968 WARN http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers Configurator:configure:126 - No c onfiguration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: file:/usr/local/jakarta-tomcat-5.0.28/work /Catalina/localhost/xwiki/loader/ehcache-failsafe.xml 12:32:16,657 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:updateSchema: 177 - Schema update for wiki xwiki 12:32:19,766 WARN http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCExceptionReporter:logExceptio ns:71 - SQL Error: 932, SQLState: 42000 12:32:19,768 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCExceptionReporter:logExceptio ns:72 - ORA-00932: inconsistent datatypes: expected - got CLOB When I saw the ORA-00932 error, I found John Turner's String2 java class and configuration files in an earlier thread. I've since compiled the class and created a jar which I've placed in WEB-INF/lib/ directory. This didn't work and I got an error about the connection URL <property name="connection.url">jdbc:oracle:oci:@localhost:1521:vicdev</property> I changed this back to thin instead and now xwiki can connect successfully to the database. BUT nothing happens! Browser says loading and nothing much else happens. Its very frustrating. I've been trying to get this to work for the last 4 days with no luck. - Do I need to make any configuration changes to Tomcat after installation? - There has been talk in the list about importing a MySQL dump into Oracle to get this working, but no mention of this in the xwiki.org site. I'd appreciate any help to get this working. Regards, Vic Send instant messages to your online friends http://au.messenger.yahoo.com -- You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws Send instant messages to your online friends http://au.messenger.yahoo.com

1 0

xwiki & oracle 10g R2
by Victor Orgos 24 Nov '06

24 Nov '06

Hi, I am attempting to get xwiki (version 0-9-840) to work with Oracle 10g R2 and I'm stuck. My DBA has created the user and loaded the schema. I'm using the ojdbc14.jar that comes with this version of Oracle. When I try to access http://localhost:8080/xwiki/bin/view/Main/WebHome with the following settings: <property name="connection.url">jdbc:oracle:thin:@localhost:1521:vicdev</property> <property name="connection.username">wiki</property> <property name="connection.password">itadmin</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">50</property> <property name="statement_cache.size">50</property> <property name="dialect">org.hibernate.dialect.OracleDialect</property> it fails with the following in the logs: 12:32:11,861 WARN http-8080-Processor25 RequestUtils:createActionForm:177 - No FormBeanConfig found under 'view' 12:32:13,968 WARN http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers Configurator:configure:126 - No c onfiguration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: file:/usr/local/jakarta-tomcat-5.0.28/work /Catalina/localhost/xwiki/loader/ehcache-failsafe.xml 12:32:16,657 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers XWikiHibernateStore:updateSchema: 177 - Schema update for wiki xwiki 12:32:19,766 WARN http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCExceptionReporter:logExceptio ns:71 - SQL Error: 932, SQLState: 42000 12:32:19,768 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/XWiki/XWikiUsers JDBCExceptionReporter:logExceptio ns:72 - ORA-00932: inconsistent datatypes: expected - got CLOB When I saw the ORA-00932 error, I found John Turner's String2 java class and configuration files in an earlier thread. I've since compiled the class and created a jar which I've placed in WEB-INF/lib/ directory. This didn't work and I got an error about the connection URL <property name="connection.url">jdbc:oracle:oci:@localhost:1521:vicdev</property> I changed this back to thin instead and now xwiki can connect successfully to the database. BUT nothing happens! Browser says loading and nothing much else happens. Its very frustrating. I've been trying to get this to work for the last 4 days with no luck. - Do I need to make any configuration changes to Tomcat after installation? - There has been talk in the list about importing a MySQL dump into Oracle to get this working, but no mention of this in the xwiki.org site. I'd appreciate any help to get this working. Regards, Vic Send instant messages to your online friends http://au.messenger.yahoo.com

2 1

RE: [xwiki-users] Dates and Groovy
by BOUSQUET Jeremie 23 Nov '06

23 Nov '06

Hi, Ok, many thanks, I understand better the lot of strange errors I got ... ;) Jérémie > -----Original Message----- > From: jeremi23(a)gmail.com [mailto:jeremi23@gmail.com] On > Behalf Of jeremi joslin > Sent: jeudi 23 novembre 2006 10:21 > To: xwiki-users(a)objectweb.org > Subject: Re: [xwiki-users] Dates and Groovy > > hi, > this is not groovy. in groovy, you don't have to put a $ in > front of a variable. Because velocity is the first parser to > render the page, the code $xwiki... is executed. > > your script should be like this : > <% > def timestamp = xwiki.formatDate(xwiki.getCurrentDate(),"yyyyMM") > def oldtime = xwiki.getDate().getTime()-(1000*60*60*24*30) > def olddate = new java.util.Date(oldtime) def oldtimestamp = > xwiki.formatDate(olddate, "yyyyMM") %> > > > jeremi > > On 11/23/06, BOUSQUET Jeremie <Jeremie.BOUSQUET(a)gemalto.com> wrote: > > > > > > Sorry, I forgot to tell that I'm using a local installation > of xwiki > > 0.9.840 > > > > BR > > Jérémie > > > > > > ________________________________ > > From: BOUSQUET Jeremie [mailto:Jeremie.BOUSQUET@gemalto.com] > > Sent: mercredi 22 novembre 2006 17:31 > > To: xwiki-users(a)objectweb.org > > Subject: [xwiki-users] Dates and Groovy > > > > > > > > Hello, > > > > I'm having a hard time manipulating Date objects in Groovy > > implementation ... > > I basically want to get a timestamp of a month ago. For > example I get > > a timestamp "200611" for now, and I want to retrieve the > "200610" string. > > > > This is what I'm doing: > > > > <% > > timestamp = > > $xwiki.formatDate($xwiki.getCurrentDate(),"yyyyMM") > > oldtime = $xwiki.getDate().getTime()-(1000*60*60*24*30) > > def olddate = new java.util.Date(oldtime) oldtimestamp = > > $xwiki.formatDate(olddate, "yyyyMM") %> > > > > olddate contains a modified date (maybe the computation is > wrong but > > for now it's not my problem). I get an error on last line, a > > NullPointerException occurring in the formatDate method. > But I logged > > that olddate is not null (it contains a Date), so I don't really > > understand from where would come the NullPointerException ????? > > > > Many thanks in advance, > > > > Jérémie > > > > -- > > You receive this message as a subscriber of the > > xwiki-users(a)objectweb.org mailing list. > > To unsubscribe: > > mailto:xwiki-users-unsubscribe@objectweb.org > > For general help: mailto:sympa@objectweb.org?subject=help > > ObjectWeb mailing lists service home page: > > http://www.objectweb.org/wws > > > > > > > > > -- > jeremi >

1 0

MediaWiki features
by Roland Bauer 23 Nov '06

23 Nov '06

Hi, I am new to XWiki and I cannot find some features which I know from MediaWiki. Please, can you give me a hint whether these features exist in XWiki? 1) How can I _directly_ jump to a page which name I know? If I enter a pagename into the search field, a full text search is done and I get a lot of hits. 2) Are umlauts (e. g. "ä", which is ä) in pagenames possible? 3) Can I have redirects to another page (not URLs)? Like #REDIRECT [[pagename]] in MediaWiki. 4) How do categories work? Like [[Category:catname]] in MediaWiki. 5) Can I edit just paragraphs/chapters of a page, instead of the whole page? Like in MediaWiki ... ;-) 6) Is there a preview function to check the layout of a page before saving it? Thanks Roland ------------------------------------------------------------------------------- Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -------------------------------------------------------------------------------

4 4

re:[xwiki-users] Continuing numbered list
by jimmy＠comkraft.com 23 Nov '06

23 Nov '06

This is also a show stopper we faced. Is this a bug that will be fixed or it is suppose to be like this? Thanks! -Jimmy ----- Original Message ----- From: Duke Tantiprasut To: xwiki-users(a)objectweb.org Sent: Wednesday, November 15, 2006 5:43 PM Subject: [xwiki-users] Continuing numbered list Is there a way to continue the numbered list? For example the result I want to achieve is something is: 1. Step A some text goes here 2. Step B 3. Step C with the wiki syntax below: 1. Step A some text goes here 1. Step B 1. Step C would produce 1. Step A some text goes here 1. Step B 2. Step C Any ideas? Thanks Duke -------------------------------------------------------------------------------- -- You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

1 0