March 2006 - xwiki-users@xwiki.org

[xwiki-users] Plain text "select x into y" in any document breaks xwiki.com
by Robin Fernandes 24 Mar '06

24 Mar '06

Hi, Trying to view/preview any page on free xwiki.com hosted containing the text: select x into y causes nothing more than the following message to be displayed: We are currently doing performance maintenance of our servers. The service will be back in a few minutes. Sorry for the inconvenience. 'x' and 'y' can be any number of words. Note that this happens with plain text - no velocity or anything, e.g. simply a document containing the text: Press the 'add' button to select which plugin is loaded into the current effect slot. I haven't raised this as bug on JIRA since I can't reproduce it outside of xwiki.com hosted wikis. So I guess it's some configuration issue or some extra protection gone wrong on xwiki.com. Thanks, Robin.

2 3

How to use IPResolverPlugin
by Julien Bourdon 24 Mar '06

24 Mar '06

Hi all! I'm a newbie in XWiki application development and I'm trying to make sense of these plugins. I tried with the IPResolverPlugin which looks quite simple but I don't know how to access it from the Velocity context. Is this possible at least? Thanks a lot! -- _ _ Julien Bourdon (o)(o)--. http://purl.org/net/JulienBourdon \../ ( ) self isAddictedTo:(#Squeak&#linux) m\/m--m'`--. ^true

3 4

LDAP Integration
by Christian van der Leeden 24 Mar '06

24 Mar '06

Hi, just testing the LDAP integration on a development build (head). I do manage to authenticate against my LDAP server and I'm logged in afterwards, but the username is not displayed (only: $docuser.display("first_name", "view", $objuser)) and somehow I'm not really "logged in". I don't have the permissions I normally have, when I'm a logged in user. Do I have to do anything extra for the LDAP integration? Do I have to create each user which exists in ldap also in the xwiki db? (this apparently works..) Below my xwiki.cfg Christian xwiki.cfg for ldap: xwiki.authentication.ldap=1 xwiki.authentication.ldap.server=enron xwiki.authentication.ldap.check_level=1 xwiki.authentication.ldap.base_DN=dc=LogicUnited,dc=Com xwiki.authentication.ldap.bind_DN=cn=Manager,dc=logicunited,dc=com xwiki.authentication.ldap.bind_pass=**** xwiki.authentication.ldap.UID_attr=uid xwiki.authentication.ldap.fields_mapping=name=uid,last_name=sn,first_name=givenName,fullname=cn,mail=mail,ldap_dn=dn -- ------------------------------------------ Logic United GmbH Email: leeden(a)logicunited.com Tel: +49-89-189488-66

2 1

[xwiki-users] added some hql velocity examples in dev guide
by Robin Fernandes 24 Mar '06

24 Mar '06

I have written up some very simple velocity+hql examples in the dev guide: http://www.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples Perhaps this would turn into a more elaborate tutorial as we get answers to brain[sic]'s questions. :)

1 0

RE: HQL question (wasRE: [xwiki-users] SQL hair-pulling)
by THOMAS, BRIAN M (SBCSI) 24 Mar '06

24 Mar '06

Huh... Sounds intriguing, but I'm puzzled about a lot of details, like: how do you do that? Probably an example would be very useful. Do you have one handy? brain[sic] -----Original Message----- From: Mark Robinson [mailto:mark.robinson@hk.tntfreight.com] Sent: Friday, March 24, 2006 10:48 AM To: xwiki-users(a)objectweb.org Subject: Re: HQL question (wasRE: [xwiki-users] SQL hair-pulling) It seems to be like ADODB, forget about query strings. Create an object. Set variables, indicate the relationships (eg joins) and call the method fpr retrieving the data. Result data as an object. Updates are a breeze. Cheers, Mark On 25 Mar 2006, at 12:32 AM, THOMAS, BRIAN M ((SBCSI)) wrote: > Would this perhaps be why I can't use an arbitrary expression as a > result field? > > Specifically, my query for objects less than a week old used the > SQL expression: > > subdate(curdate(), 7) > > which worked fine when used in a comparison to a date field in the > WHERE clause, but provoked an error when I tried to use it in the > column-list, which is (I believe) clearly legal SQL syntax. If > this were a feature that HQL simply didn't support, it would > explain the problem. Indeed, that is what the error message seems > to say: > > Error number 4001 in 4: Error while parsing velocity page > Brian.WorkPagesTest > Wrapped Exception: Invocation of method 'search' in class > com.xpn.xwiki.api.XWiki threw exception class > com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception > while searching documents with sql select subdate(curdate(), 7), > prop.value, [...] where [...] or subdate(curdate(), 7) <= > prop.value ) [...] > Wrapped Exception: No data type for node: > org.hibernate.hql.ast.MethodNode > +-METHOD_CALL? MethodNode: '(' > | +-METHOD_NAME? IdentNode: 'subdate' {originalText=subdate} > | -EXPR_LIST? SqlNode: 'exprList' > | +-METHOD_CALL? MethodNode: '(' > | | +-METHOD_NAME? IdentNode: 'curdate' {originalText=curdate} > | | -EXPR_LIST? SqlNode: 'exprList' > | -NUM_INT? LiteralNode: '7' > > brain[sic] > -----Original Message----- > From: jeremi joslin [mailto:jeremi23@gmail.com] > Sent: Thursday, March 23, 2006 10:47 PM > To: xwiki-users(a)objectweb.org > Subject: Re: [xwiki-users] SQL hair-pulling > Yes, XWiki is using hibernate for the database mapping. So it's > not a sql query, but a hql query. You use the objects and members > name to make the request. (if you don't know the hql, you can take > a look to the hibernate documentation : > http://www.hibernate.org/hib_docs/v3/reference/en/html_single/ > #queryhql) > > Jérémi > > > -- > 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

2 1

HQL question (wasRE: [xwiki-users] SQL hair-pulling)
by THOMAS, BRIAN M (SBCSI) 24 Mar '06

24 Mar '06

Would this perhaps be why I can't use an arbitrary expression as a result field? Specifically, my query for objects less than a week old used the SQL expression: subdate(curdate(), 7) which worked fine when used in a comparison to a date field in the WHERE clause, but provoked an error when I tried to use it in the column-list, which is (I believe) clearly legal SQL syntax. If this were a feature that HQL simply didn't support, it would explain the problem. Indeed, that is what the error message seems to say: Error number 4001 in 4: Error while parsing velocity page Brian.WorkPagesTest Wrapped Exception: Invocation of method 'search' in class com.xpn.xwiki.api.XWiki threw exception class com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception while searching documents with sql select subdate(curdate(), 7), prop.value, [...] where [...] or subdate(curdate(), 7) <= prop.value ) [...] Wrapped Exception: No data type for node: org.hibernate.hql.ast.MethodNode +-METHOD_CALL? MethodNode: '(' | +-METHOD_NAME? IdentNode: 'subdate' {originalText=subdate} | -EXPR_LIST? SqlNode: 'exprList' | +-METHOD_CALL? MethodNode: '(' | | +-METHOD_NAME? IdentNode: 'curdate' {originalText=curdate} | | -EXPR_LIST? SqlNode: 'exprList' | -NUM_INT? LiteralNode: '7' brain[sic] -----Original Message----- From: jeremi joslin [mailto:jeremi23@gmail.com] Sent: Thursday, March 23, 2006 10:47 PM To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] SQL hair-pulling Yes, XWiki is using hibernate for the database mapping. So it's not a sql query, but a hql query. You use the objects and members name to make the request. (if you don't know the hql, you can take a look to the hibernate documentation : http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#queryhql) Jérémi

2 1

RE: [xwiki-users] SQL hair-pulling
by THOMAS, BRIAN M (SBCSI) 24 Mar '06

24 Mar '06

Jérémi: Aha! I should have read my mail before sending my last note, which I began composing last night. That clears a lot of the mystery. I will save my other questions until after I've read your reference; thank you. But it re-raises for me the issue I had thought resolved - that of where the boundary of queryability may be. I had assumed that it was the same as the boundary of the XWiki-defined object model, as it would seem logically if it had to be supported as a database map, but since it's a general-purpose persistence tool, might that assumption be wrong? Probably, any queryable object would have to be modeled in the database, but it's a grey area in my understanding. I do note that date fields are returned as java.sql.Timestamp rather than as java.util.Date, in case that has any bearing on the matter. brain[sic] -----Original Message----- From: jeremi joslin [mailto:jeremi23@gmail.com] Sent: Thursday, March 23, 2006 10:47 PM To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] SQL hair-pulling On 3/24/06, THOMAS, BRIAN M (SBCSI) <bt0008(a)att.com> wrote: > As mentioned in an earlier message, I got into the $xwiki.search() > world yesterday, and am thoroughly confused. > > The main problem seems to be that the XWiki database schema and the > schema used in all of the $xwiki.search() queries I have found are > completely disjoint. > > Instead of the documented tables and columns, what seems to be used is > a schema which reflects the object model within XWiki. This would > really be convenient if true; is it? Hi, Yes, XWiki is using hibernate for the database mapping. So it's not a sql query, but a hql query. You use the objects and members name to make the request. (if you don't know the hql, you can take a look to the hibernate documentation : http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#queryhql) Jérémi -- Blog: http://www.jeremi.info LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724 Project Manager XWiki: http://www.xwiki.org skype: jeremi23 -- msn et gtalk : jeremi23(a)gmail.com

1 0

[xwiki-users] Event Calendar abnormality
by SIM SOON HUAT, CTSID 24 Mar '06

24 Mar '06

Hi, I noticed the Previous month/Next month links on the event calendar does not function normally. Present month is March Previous month http://ctsid.citos.psa/xwiki/bin/view/Main/EventCalendar?month=-1 Next month http://ctsid.citos.psa/xwiki/bin/view/Main/EventCalendar?month=+1 I click on previous month 2 times Then I click on next month 1 time This puts me at February Previous month http://ctsid.citos.psa/xwiki/bin/view/Main/EventCalendar?month=-2 Next month http://ctsid.citos.psa/xwiki/bin/view/Main/EventCalendar?month=0 When I click on next month, which has http://ctsid.citos.psa/xwiki/bin/view/Main/EventCalendar?month=0 as the link, I go to January...... Is this a solvable problem? This communication contains confidential or privileged information. If you are not the intended recipient, please notify us IMMEDIATELY that you have received it and destroy it. We are not liable for any unauthorised sending of or interference with this communication.

2 1

SQL hair-pulling
by THOMAS, BRIAN M (SBCSI) 24 Mar '06

24 Mar '06

As mentioned in an earlier message, I got into the $xwiki.search() world yesterday, and am thoroughly confused. The main problem seems to be that the XWiki database schema and the schema used in all of the $xwiki.search() queries I have found are completely disjoint. Instead of the documented tables and columns, what seems to be used is a schema which reflects the object model within XWiki. This would really be convenient if true; is it? brain[sic]

2 1

AW: [xwiki-users] SQL hair-pulling
by Frank Häfemeier 23 Mar '06

23 Mar '06

>As mentioned in an earlier message, I got into the $xwiki.search() world >yesterday, and am thoroughly confused. > >The main problem seems to be that the XWiki database schema and the >schema used in all of the $xwiki.search() queries I have found are >completely disjoint. > >Instead of the documented tables and columns, what seems to be used is a >schema which reflects the object model within XWiki. This would really >be convenient if true; is it? This is right. Bye Frank

1 0