xwiki-users

xwiki-users@xwiki.org

10408 discussions

RE: HQL question (wasRE: [xwiki-users] SQL hair-pulling)

by THOMAS, BRIAN M (SBCSI)

Okay; will do. But I was just about to reply that if you omit the result-list ("select field, field, ...") then the returned value is the object type of the first object in the "from" list. Exactly what I wanted, and it sounds like what you were describing, but your examples didn't show it. brain[sic] -----Original Message----- From: Mark Robinson [mailto:mark.robinson@hk.tntfreight.com] Sent: Friday, March 24, 2006 11:35 AM To: xwiki-users(a)objectweb.org Subject: Re: HQL question (wasRE: [xwiki-users] SQL hair-pulling) Hi Brian. Check this thread out. http://mail-archive.objectweb.org/xwiki-dev/2005-11/msg00031.html Cheers, Mark On 25 Mar 2006, at 12:57 AM, THOMAS, BRIAN M ((SBCSI)) wrote: > 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 > > > > > -- > 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

18 years, 9 months

XWiki's feed plugin can't parse XWiki's RDF

by Robin Fernandes

As demonstrated by this page http://www.xwiki.org/xwiki/bin/view/Sandbox/includeOwnRSS the XWiki feed parser plugin appears to fall over when parsing a feed generated by XWiki. Other parsers have no problems. The the stack trace isn't reported with the error so it's a bit hard to see exactly what's going wrong... though I guess it's failing in FeedPlugin.getFeedForce(..). I thought it might be a formatting problem in the rdf template, exposing some fragility in the parser... However, invoking rome as follows (using rome 0.7) works fine: public class Feedread { public static void main(String[] args) throws IllegalArgumentException, IOException, FeedException, FetcherException { // FeedFetcher feedFetcher = new HttpURLFeedFetcher(); URL feedURL = new URL("http://www.xwiki.org/xwiki/bin/view/Main/WebRss?xpage=rdf"); SyndFeed feed = feedFetcher.retrieveFeed(feedURL); feedFetcher.setUserAgent("XWikiBot"); System.out.println(feed); } } So I'm not sure what's breaking when this happens inside XWiki. The reason want to do this is that on my xwiki homepage I'd like to include a bunch of feeds, some external, some from the wiki itself. It would make my life easier if I could use my same macro to display them all, rather than using the feed plug for the external ones, and direct hql queries for the local ones. Regards, Robin

18 years, 9 months

RSS feed/cache question

by KIDWELL, REX (SBCSI)

Can someone provide information on how RSS feeds and the Xwiki cache system work together? What's known so far. 1) The xwiki/WEB-INF/xwiki.cfg file contains the following lines xwiki.store.cache=1 xwiki.store.cache.capacity=100 2) Based on the build.xml file included in the source, xwiki is configured to use ehcache-1.1, oscache-2.0.2, and swarmcache. 3) grep results on source files indicate that OSCache is being used by Xwiki. Questions 4) Does item 1) mean caching is enabled for RSS feeds? 5) Does "xwiki.store.cache.capacity=100" relate to OSCache's "cache.capacity" configuration property? Are they the same? See the following URL http://wiki.opensymphony.com/display/CACHE/Configuration 6) Please confirm that OSCache is being used by Xwiki 0.9.840 for RSS feeds That's enough, for now and thanks for any help you can provide. Rex Kidwell

18 years, 9 months

[xwiki-users] Plain text "select x into y" in any document breaks xwiki.com

by Robin Fernandes

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.

18 years, 9 months

How to use IPResolverPlugin

by Julien Bourdon

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

18 years, 9 months

LDAP Integration

by Christian van der Leeden

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

18 years, 9 months

[xwiki-users] added some hql velocity examples in dev guide

by Robin Fernandes

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. :)

18 years, 9 months

RE: HQL question (wasRE: [xwiki-users] SQL hair-pulling)

by THOMAS, BRIAN M (SBCSI)

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

18 years, 9 months

HQL question (wasRE: [xwiki-users] SQL hair-pulling)

by THOMAS, BRIAN M (SBCSI)

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

18 years, 9 months

RE: [xwiki-users] SQL hair-pulling

by THOMAS, BRIAN M (SBCSI)

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

18 years, 9 months

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

xwiki-users