[xwiki-users] syntax nuances
Seems I haven't yet understood all the nuances of XWiki syntax: According to http://platform.xwiki.org/xwiki/bin/view/Main/XWikiSyntax I can have a sized image with [[image:img.png||width=25 height=25]] I can have an image with a link [[image:img.pnghttp://xwiki.org]] How can I have a sized image with a link ? not working: [[image:img.png||width=25 height=25http://xwiki.org]] [[image:img.pnghttp://xwiki.org||width=25 height=25]] not working either (with and without 'px'): (% style=height:25px;width:25px %) [[image:img.pnghttp://xwiki.org]] and (% style=height:25px;width:25px [[image:img.pnghttp://xwiki.org]] %) Hmmm... Once again I may not see the obvious ... How can I do it ? Thanks Andreas ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] syntax nuances
Hi Andreas, On Jan 6, 2011, at 10:59 AM, Andreas Hahn wrote: Seems I haven't yet understood all the nuances of XWiki syntax: According to http://platform.xwiki.org/xwiki/bin/view/Main/XWikiSyntax I can have a sized image with [[image:img.png||width=25 height=25]] I can have an image with a link [[image:img.pnghttp://xwiki.org]] How can I have a sized image with a link ? not working: [[image:img.png||width=25 height=25http://xwiki.org]] not correct [[image:img.pnghttp://xwiki.org||width=25 height=25]] not correct either You need: image:img.png||width=25 height=25]]http://xwiki.org]] Hope it helps, -Vincent not working either (with and without 'px'): (% style=height:25px;width:25px %) [[image:img.pnghttp://xwiki.org]] and (% style=height:25px;width:25px [[image:img.pnghttp://xwiki.org]] %) Hmmm... Once again I may not see the obvious ... How can I do it ? Thanks Andreas ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] syntax nuances
On Jan 6, 2011, at 11:09 AM, Vincent Massol wrote: Hi Andreas, On Jan 6, 2011, at 10:59 AM, Andreas Hahn wrote: Seems I haven't yet understood all the nuances of XWiki syntax: According to http://platform.xwiki.org/xwiki/bin/view/Main/XWikiSyntax I can have a sized image with [[image:img.png||width=25 height=25]] I can have an image with a link [[image:img.pnghttp://xwiki.org]] How can I have a sized image with a link ? not working: [[image:img.png||width=25 height=25http://xwiki.org]] not correct [[image:img.pnghttp://xwiki.org||width=25 height=25]] not correct either You need: image:img.png||width=25 height=25]]http://xwiki.org]] What you need to understand is that you have wiki syntax inside a link label In [[linklabelherereference]], linklabelhere is wiki syntax. The wiki syntax to specify an image with params is [[image:...||params]]. Please let us know how to fix the doc to make it more obvious. Thanks -Vincent Hope it helps, -Vincent not working either (with and without 'px'): (% style=height:25px;width:25px %) [[image:img.pnghttp://xwiki.org]] and (% style=height:25px;width:25px [[image:img.pnghttp://xwiki.org]] %) Hmmm... Once again I may not see the obvious ... How can I do it ? Thanks Andreas ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] wrapped exception: XXX is not mapped
Hi All, I am having an issue with an error when running a velocity macro in xwiki. Within the Oracle database I have a table containing a list of page names. I am trying to run a script where the system takes this list, cycles through all pages within a space and deletes any pages who's name appears on the list. Here's what I have so far... #set($sql = where doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)) #DeletePagesLocal($sql) #macro(DeletePagesLocal $sql) #foreach($item in $xwiki.searchDocuments($sql)) #set($itemdoc = $xwiki.getDocument($item)) $itemdoc.delete() #end #end The error I am getting is: Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with SQL [select distinct doc.space, doc.name from XWikiDocument as doc where (doc.hidden true or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)] Wrapped Exception: lovtestdata is not mapped [select distinct doc.space, doc.name from com.xpn.xwiki.doc.XWikiDocument as doc where (doc.hidden true or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)] Essentially it is saying that the table is not mapped. If anyone could point me in the right direction it would be great. Many thanks Luke LEGAL NOTICE This email and any files transmitted with it are confidential, may be privileged and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please telephone or email the sender on +44 (0) 1785 827 000 and delete this message and any attachment from your system; you must not copy or disclose the contents of this message or any attachment to any other person. Any views or opinions presented are solely those of the sender and do not necessarily represent those of Capula Limited and we accept no liability for its accuracy or completeness. Copyright in this email and any attachment created by us belongs to Capula Limited. Please ensure you have adequate virus protection before you open or detach any documents from this transmission. Capula Limited does not accept any liability for any loss or damage arising in any way from the receipt or use thereof. Any e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. Capula Limited Registered No 00953504 England Registered Office Orion House, Stone, Staffordshire, ST15 0LT. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Live Table filters on columns for stringsdates
Hi Jerome, thanks for the swift reply! As you asked, screenshot (and the code): https://wiki.noiv.nl/xwiki/bin/view/Sandbox/lists On Wed, Jan 5, 2011 at 6:18 PM, Jerome Velociter jer...@xwiki.com wrote: Hi Joris, While date filters are not supported yet (also I would like to work on that in a not-so-far future), the other property types should work as expected. We can't see your screenshot since this list does not support attachments. Can you post it somewhere on the web and point us to it ? Thanks, Jerome. On Wed, Jan 5, 2011 at 4:34 PM, Joris Dirks joris+xw...@user.stekje.nl wrote: I'm having fun with the livetable macro but can't seem to enable filtering for certain columns. It seems this is because they aren't TextArea but have the type 'String', 'Date' or 'Static List'. Screenshot for illustration. I am not sure anymore why I made the property 'indieneradres' in my example a string when I created a certain class but it bites me in the back now. (I probably wanted the form to validate the input). Should I just delete that property and make a new one of type TextArea? For the column with static list-values, I sort of expected a drop-down or multiselect filter of sorts. Thanks for your ideas! On a related note, the template for shown class shows up in the livetable (as IssueTemplate matches the option:className:Helpdesk.IssueClass). This results in a row with 'emptyvalue' for every value. Does anyone know of a quick fix for that? ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] syntax nuances
Am 06.01.2011 11:11, schrieb Vincent Massol: Yesss - so now I can remove the ugly {{html}} a href= {{/hmtl}} from my wiki. Maybe just an example on the Syntax page might help. However I'm still struggling to find a better way for customizing the visual appearance of my wiki. I just learned by accident that the parameters of an image [[image:myimage.png||theParamter=hi]] will go unparsed into the resulting img .. theParameter=hi /. That wasn't obvious to me either but it means that customization with a class=myImage should be easily possible. Also the scope of the Parameter - statement (% isn't completely clear to me - it seems to work on the subsequent syntax element - but not for [[image:...]] or it renders a paragraph p but if you want to render a span you need to use {{html }}span class=myclasstext/span{{/html}} - right ? Well I'm sort of casual user and it takes time finding out. thanks a lot Andreas On Jan 6, 2011, at 11:09 AM, Vincent Massol wrote: Hi Andreas, On Jan 6, 2011, at 10:59 AM, Andreas Hahn wrote: Seems I haven't yet understood all the nuances of XWiki syntax: According to http://platform.xwiki.org/xwiki/bin/view/Main/XWikiSyntax I can have a sized image with [[image:img.png||width=25 height=25]] I can have an image with a link [[image:img.pnghttp://xwiki.org]] How can I have a sized image with a link ? not working: [[image:img.png||width=25 height=25http://xwiki.org]] not correct [[image:img.pnghttp://xwiki.org||width=25 height=25]] not correct either You need: image:img.png||width=25 height=25]]http://xwiki.org]] What you need to understand is that you have wiki syntax inside a link label In [[linklabelherereference]], linklabelhere is wiki syntax. The wiki syntax to specify an image with params is [[image:...||params]]. Please let us know how to fix the doc to make it more obvious. Thanks -Vincent Hope it helps, -Vincent not working either (with and without 'px'): (% style=height:25px;width:25px %) [[image:img.pnghttp://xwiki.org]] and (% style=height:25px;width:25px [[image:img.pnghttp://xwiki.org]] %) Hmmm... Once again I may not see the obvious ... How can I do it ? Thanks Andreas ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] syntax nuances
On Jan 6, 2011, at 12:53 PM, Andreas Hahn wrote: Am 06.01.2011 11:11, schrieb Vincent Massol: Yesss - so now I can remove the ugly {{html}} a href= {{/hmtl}} from my wiki. Maybe just an example on the Syntax page might help. However I'm still struggling to find a better way for customizing the visual appearance of my wiki. I just learned by accident that the parameters of an image [[image:myimage.png||theParamter=hi]] will go unparsed into the resulting img .. theParameter=hi /. That wasn't obvious to me either but it means that customization with a class=myImage should be easily possible. Also the scope of the Parameter - statement (% isn't completely clear to me - it seems to work on the subsequent syntax element - but not for [[image:...]] or it renders a paragraph p but if you want to render a span you need to use {{html }}span class=myclasstext/span{{/html}} - right ? I've tried this on my local wiki: [[(% class=myclass %)[[image:XWikiLogo.png||width=25 height=25]]http://xwiki.org]] And it generates: pspan class=wikiexternallinka href=http://xwiki.org;span class=myclassimg src=http://localhost:8080/xwiki/bin/download/Sandbox/WebHome/XWikiLogo.png?width=25amp;height=25; width=25 height=25 alt=XWikiLogo.png//span/a/span/p So as you can see it does generate a span. Now if you want the params to apply to the img tag you need to pass them as image params: image:XWikiLogo.png||width=25 height=25 class=myclass]]http://xwiki.org]] which generates: pspan class=wikiexternallinka href=http://xwiki.org;img src=http://localhost:8080/xwiki/bin/download/Sandbox/WebHome/XWikiLogo.png?width=25amp;height=25; width=25 height=25 class=myclass alt=XWikiLogo.png//a/span/p Hope it's clear. Thanks -Vincent Well I'm sort of casual user and it takes time finding out. thanks a lot Andreas On Jan 6, 2011, at 11:09 AM, Vincent Massol wrote: Hi Andreas, On Jan 6, 2011, at 10:59 AM, Andreas Hahn wrote: Seems I haven't yet understood all the nuances of XWiki syntax: According to http://platform.xwiki.org/xwiki/bin/view/Main/XWikiSyntax I can have a sized image with [[image:img.png||width=25 height=25]] I can have an image with a link [[image:img.pnghttp://xwiki.org]] How can I have a sized image with a link ? not working: [[image:img.png||width=25 height=25http://xwiki.org]] not correct [[image:img.pnghttp://xwiki.org||width=25 height=25]] not correct either You need: image:img.png||width=25 height=25]]http://xwiki.org]] What you need to understand is that you have wiki syntax inside a link label In [[linklabelherereference]], linklabelhere is wiki syntax. The wiki syntax to specify an image with params is [[image:...||params]]. Please let us know how to fix the doc to make it more obvious. Thanks -Vincent Hope it helps, -Vincent not working either (with and without 'px'): (% style=height:25px;width:25px %) [[image:img.pnghttp://xwiki.org]] and (% style=height:25px;width:25px [[image:img.pnghttp://xwiki.org]] %) Hmmm... Once again I may not see the obvious ... How can I do it ? Thanks Andreas ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] wrapped exception: XXX is not mapped
The problem is that you are using SQL to query against the database and Hibernate is expecting HQL. I assume you added a table called lovtestdata manually. unfortunately hibernate doesn't know that it exists and will not allow you to query against it. The easy solution is to use: {{groovy}} xc = xcontext.getContext() hib = xc.getWiki().getHibernateStore(); hib.beginTransaction(xc); try { conn = hib.getSession().openConnection(); // conn will be a http://download.oracle.com/javase/1.3/docs/api/java/sql/Connection.html // which will give you raw access to the database. // commit hib.endTransaction(xc, true); } catch (Exception e) { // or rollback hib.endTransaction(xc, false); throw e; } {{/groovy}} The right solution is to use XObjects and query for their properties using HQL or XWQL instead of raw database queries. Caleb On 01/06/2011 05:09 AM, Richardson Luke wrote: Hi All, I am having an issue with an error when running a velocity macro in xwiki. Within the Oracle database I have a table containing a list of page names. I am trying to run a script where the system takes this list, cycles through all pages within a space and deletes any pages who's name appears on the list. Here's what I have so far... #set($sql = where doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)) #DeletePagesLocal($sql) #macro(DeletePagesLocal $sql) #foreach($item in $xwiki.searchDocuments($sql)) #set($itemdoc = $xwiki.getDocument($item)) $itemdoc.delete() #end #end The error I am getting is: Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with SQL [select distinct doc.space, doc.name from XWikiDocument as doc where (doc.hidden true or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)] Wrapped Exception: lovtestdata is not mapped [select distinct doc.space, doc.name from com.xpn.xwiki.doc.XWikiDocument as doc where (doc.hidden true or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)] Essentially it is saying that the table is not mapped. If anyone could point me in the right direction it would be great. Many thanks Luke LEGAL NOTICE This email and any files transmitted with it are confidential, may be privileged and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please telephone or email the sender on +44 (0) 1785 827 000 and delete this message and any attachment from your system; you must not copy or disclose the contents of this message or any attachment to any other person. Any views or opinions presented are solely those of the sender and do not necessarily represent those of Capula Limited and we accept no liability for its accuracy or completeness. Copyright in this email and any attachment created by us belongs to Capula Limited. Please ensure you have adequate virus protection before you open or detach any documents from this transmission. Capula Limited does not accept any liability for any loss or damage arising in any way from the receipt or use thereof. Any e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. Capula Limited Registered No 00953504 England Registered Office Orion House, Stone, Staffordshire, ST15 0LT. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] syntax nuances
Am 06.01.2011 12:59, schrieb Vincent Massol: On Jan 6, 2011, at 12:53 PM, Andreas Hahn wrote: Am 06.01.2011 11:11, schrieb Vincent Massol: Yesss - so now I can remove the ugly {{html}}a href= {{/hmtl}} from my wiki. Maybe just an example on the Syntax page might help. However I'm still struggling to find a better way for customizing the visual appearance of my wiki. I just learned by accident that the parameters of an image [[image:myimage.png||theParamter=hi]] will go unparsed into the resultingimg .. theParameter=hi /. That wasn't obvious to me either but it means that customization with a class=myImage should be easily possible. Also the scope of the Parameter - statement (% isn't completely clear to me - it seems to work on the subsequent syntax element - but not for [[image:...]] or it renders a paragraphp but if you want to render aspan you need to use {{html }}span class=myclasstext/span{{/html}} - right ? I've tried this on my local wiki: [[(% class=myclass %)[[image:XWikiLogo.png||width=25 height=25]]http://xwiki.org]] And it generates: pspan class=wikiexternallinka href=http://xwiki.org;span class=myclassimg src=http://localhost:8080/xwiki/bin/download/Sandbox/WebHome/XWikiLogo.png?width=25amp;height=25; width=25 height=25 alt=XWikiLogo.png//span/a/span/p So as you can see it does generate aspan. Now if you want the params to apply to the img tag you need to pass them as image params: image:XWikiLogo.png||width=25 height=25 class=myclass]]http://xwiki.org]] which generates: pspan class=wikiexternallinka href=http://xwiki.org;img src=http://localhost:8080/xwiki/bin/download/Sandbox/WebHome/XWikiLogo.png?width=25amp;height=25; width=25 height=25 class=myclass alt=XWikiLogo.png//a/span/p Hope it's clear. Thanks -Vincent Bingo - again I wasn't aware i need to put it in brackets [[ ]] thanks Andreas Well I'm sort of casual user and it takes time finding out. thanks a lot Andreas On Jan 6, 2011, at 11:09 AM, Vincent Massol wrote: Hi Andreas, On Jan 6, 2011, at 10:59 AM, Andreas Hahn wrote: Seems I haven't yet understood all the nuances of XWiki syntax: According to http://platform.xwiki.org/xwiki/bin/view/Main/XWikiSyntax I can have a sized image with [[image:img.png||width=25 height=25]] I can have an image with a link [[image:img.pnghttp://xwiki.org]] How can I have a sized image with a link ? not working: [[image:img.png||width=25 height=25http://xwiki.org]] not correct [[image:img.pnghttp://xwiki.org||width=25 height=25]] not correct either You need: image:img.png||width=25 height=25]]http://xwiki.org]] What you need to understand is that you have wiki syntax inside a link label In [[linklabelherereference]], linklabelhere is wiki syntax. The wiki syntax to specify an image with params is [[image:...||params]]. Please let us know how to fix the doc to make it more obvious. Thanks -Vincent Hope it helps, -Vincent not working either (with and without 'px'): (% style=height:25px;width:25px %) [[image:img.pnghttp://xwiki.org]] and (% style=height:25px;width:25px [[image:img.pnghttp://xwiki.org]] %) Hmmm... Once again I may not see the obvious ... How can I do it ? Thanks Andreas ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] wrapped exception: XXX is not mapped
Excellent, looks like this may do the trick. Thanks very much for your help :) -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org]on Behalf Of Caleb James DeLisle Sent: 06 January 2011 12:00 To: XWiki Users Subject: Re: [xwiki-users] wrapped exception: XXX is not mapped The problem is that you are using SQL to query against the database and Hibernate is expecting HQL. I assume you added a table called lovtestdata manually. unfortunately hibernate doesn't know that it exists and will not allow you to query against it. The easy solution is to use: {{groovy}} xc = xcontext.getContext() hib = xc.getWiki().getHibernateStore(); hib.beginTransaction(xc); try { conn = hib.getSession().openConnection(); // conn will be a http://download.oracle.com/javase/1.3/docs/api/java/sql/Connection.html // which will give you raw access to the database. // commit hib.endTransaction(xc, true); } catch (Exception e) { // or rollback hib.endTransaction(xc, false); throw e; } {{/groovy}} The right solution is to use XObjects and query for their properties using HQL or XWQL instead of raw database queries. Caleb On 01/06/2011 05:09 AM, Richardson Luke wrote: Hi All, I am having an issue with an error when running a velocity macro in xwiki. Within the Oracle database I have a table containing a list of page names. I am trying to run a script where the system takes this list, cycles through all pages within a space and deletes any pages who's name appears on the list. Here's what I have so far... #set($sql = where doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)) #DeletePagesLocal($sql) #macro(DeletePagesLocal $sql) #foreach($item in $xwiki.searchDocuments($sql)) #set($itemdoc = $xwiki.getDocument($item)) $itemdoc.delete() #end #end The error I am getting is: Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with SQL [select distinct doc.space, doc.name from XWikiDocument as doc where (doc.hidden true or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)] Wrapped Exception: lovtestdata is not mapped [select distinct doc.space, doc.name from com.xpn.xwiki.doc.XWikiDocument as doc where (doc.hidden true or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)] Essentially it is saying that the table is not mapped. If anyone could point me in the right direction it would be great. Many thanks Luke LEGAL NOTICE This email and any files transmitted with it are confidential, may be privileged and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please telephone or email the sender on +44 (0) 1785 827 000 and delete this message and any attachment from your system; you must not copy or disclose the contents of this message or any attachment to any other person. Any views or opinions presented are solely those of the sender and do not necessarily represent those of Capula Limited and we accept no liability for its accuracy or completeness. Copyright in this email and any attachment created by us belongs to Capula Limited. Please ensure you have adequate virus protection before you open or detach any documents from this transmission. Capula Limited does not accept any liability for any loss or damage arising in any way from the receipt or use thereof. Any e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. Capula Limited Registered No 00953504 England Registered Office Orion House, Stone, Staffordshire, ST15 0LT. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users LEGAL NOTICE This email and any files transmitted with it are confidential, may be privileged and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please telephone or email the sender on +44 (0) 1785 827 000 and delete this message and any attachment from your system; you must not copy or disclose the contents of this message or any attachment to any other person. Any views or opinions presented are solely those of the sender and do not necessarily represent those of Capula Limited and we accept no liability for its accuracy or completeness. Copyright in this email and any attachment created by us belongs to Capula Limited. Please ensure you have adequate virus protection before you open or detach any documents from this transmission. Capula Limited does
Re: [xwiki-users] wrapped exception: XXX is not mapped
On 01/06/2011 07:00 AM, Caleb James DeLisle wrote: The problem is that you are using SQL to query against the database and Hibernate is expecting HQL. I assume you added a table called lovtestdata manually. unfortunately hibernate doesn't know that it exists and will not allow you to query against it. The easy solution is to use: {{groovy}} xc = xcontext.getContext() hib = xc.getWiki().getHibernateStore(); hib.beginTransaction(xc); try { conn = hib.getSession().openConnection(); conn = hib.getSession().connection(); My mistake. // conn will be a http://download.oracle.com/javase/1.3/docs/api/java/sql/Connection.html // which will give you raw access to the database. // commit hib.endTransaction(xc, true); } catch (Exception e) { // or rollback hib.endTransaction(xc, false); throw e; } {{/groovy}} The right solution is to use XObjects and query for their properties using HQL or XWQL instead of raw database queries. Caleb On 01/06/2011 05:09 AM, Richardson Luke wrote: Hi All, I am having an issue with an error when running a velocity macro in xwiki. Within the Oracle database I have a table containing a list of page names. I am trying to run a script where the system takes this list, cycles through all pages within a space and deletes any pages who's name appears on the list. Here's what I have so far... #set($sql = where doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)) #DeletePagesLocal($sql) #macro(DeletePagesLocal $sql) #foreach($item in $xwiki.searchDocuments($sql)) #set($itemdoc = $xwiki.getDocument($item)) $itemdoc.delete() #end #end The error I am getting is: Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with SQL [select distinct doc.space, doc.name from XWikiDocument as doc where (doc.hidden true or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)] Wrapped Exception: lovtestdata is not mapped [select distinct doc.space, doc.name from com.xpn.xwiki.doc.XWikiDocument as doc where (doc.hidden true or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)] Essentially it is saying that the table is not mapped. If anyone could point me in the right direction it would be great. Many thanks Luke LEGAL NOTICE This email and any files transmitted with it are confidential, may be privileged and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, please telephone or email the sender on +44 (0) 1785 827 000 and delete this message and any attachment from your system; you must not copy or disclose the contents of this message or any attachment to any other person. Any views or opinions presented are solely those of the sender and do not necessarily represent those of Capula Limited and we accept no liability for its accuracy or completeness. Copyright in this email and any attachment created by us belongs to Capula Limited. Please ensure you have adequate virus protection before you open or detach any documents from this transmission. Capula Limited does not accept any liability for any loss or damage arising in any way from the receipt or use thereof. Any e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. Capula Limited Registered No 00953504 England Registered Office Orion House, Stone, Staffordshire, ST15 0LT. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] wrapped exception: XXX is not mapped
On 01/06/2011 01:18 PM, Caleb James DeLisle wrote: On 01/06/2011 07:00 AM, Caleb James DeLisle wrote: The problem is that you are using SQL to query against the database and Hibernate is expecting HQL. I assume you added a table called lovtestdata manually. unfortunately hibernate doesn't know that it exists and will not allow you to query against it. The easy solution is to use: {{groovy}} xc = xcontext.getContext() hib = xc.getWiki().getHibernateStore(); hib.beginTransaction(xc); try { conn = hib.getSession().openConnection(); conn = hib.getSession().connection(); My mistake. // conn will be a http://download.oracle.com/javase/1.3/docs/api/java/sql/Connection.html // which will give you raw access to the database. // commit hib.endTransaction(xc, true); } catch (Exception e) { // or rollback hib.endTransaction(xc, false); throw e; } {{/groovy}} The right solution is to use XObjects and query for their properties using HQL or XWQL instead of raw database queries. Caleb On 01/06/2011 05:09 AM, Richardson Luke wrote: Hi All, I am having an issue with an error when running a velocity macro in xwiki. Within the Oracle database I have a table containing a list of page names. I am trying to run a script where the system takes this list, cycles through all pages within a space and deletes any pages who's name appears on the list. An alternative is to use the SQL plugin: http://extensions.xwiki.org/xwiki/bin/Extension/SQL+Plugin Here's what I have so far... #set($sql = where doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)) #DeletePagesLocal($sql) #macro(DeletePagesLocal $sql) #foreach($item in $xwiki.searchDocuments($sql)) #set($itemdoc = $xwiki.getDocument($item)) $itemdoc.delete() #end #end The error I am getting is: Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with SQL [select distinct doc.space, doc.name from XWikiDocument as doc where (doc.hidden true or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)] Wrapped Exception: lovtestdata is not mapped [select distinct doc.space, doc.name from com.xpn.xwiki.doc.XWikiDocument as doc where (doc.hidden true or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)] Essentially it is saying that the table is not mapped. If anyone could point me in the right direction it would be great. Many thanks Luke -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Live Table filters on columns for stringsdates
Hoï Jorris, On Thu, Jan 6, 2011 at 12:37 PM, Joris Dirks joris+xw...@user.stekje.nl wrote: Hi Jerome, thanks for the swift reply! As you asked, screenshot (and the code): https://wiki.noiv.nl/xwiki/bin/view/Sandbox/lists Have you tried adding filterable:true to the properties you expect filters for ? (it seems only one has it right now) Also I forgot to ask : which version of XWiki NOiV is running ? Jerome. On Wed, Jan 5, 2011 at 6:18 PM, Jerome Velociter jer...@xwiki.com wrote: Hi Joris, While date filters are not supported yet (also I would like to work on that in a not-so-far future), the other property types should work as expected. We can't see your screenshot since this list does not support attachments. Can you post it somewhere on the web and point us to it ? Thanks, Jerome. On Wed, Jan 5, 2011 at 4:34 PM, Joris Dirks joris+xw...@user.stekje.nl wrote: I'm having fun with the livetable macro but can't seem to enable filtering for certain columns. It seems this is because they aren't TextArea but have the type 'String', 'Date' or 'Static List'. Screenshot for illustration. I am not sure anymore why I made the property 'indieneradres' in my example a string when I created a certain class but it bites me in the back now. (I probably wanted the form to validate the input). Should I just delete that property and make a new one of type TextArea? For the column with static list-values, I sort of expected a drop-down or multiselect filter of sorts. Thanks for your ideas! On a related note, the template for shown class shows up in the livetable (as IssueTemplate matches the option:className:Helpdesk.IssueClass). This results in a row with 'emptyvalue' for every value. Does anyone know of a quick fix for that? ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Live Table filters on columns for stringsdates
On Thu, Jan 6, 2011 at 2:38 PM, Jerome Velociter jerome.xw...@gmail.com wrote: Hoï Jorris, On Thu, Jan 6, 2011 at 12:37 PM, Joris Dirks joris+xw...@user.stekje.nl wrote: Hi Jerome, thanks for the swift reply! As you asked, screenshot (and the code): https://wiki.noiv.nl/xwiki/bin/view/Sandbox/lists Have you tried adding filterable:true to the properties you expect filters for ? (it seems only one has it right now) Yes, to no resort. The filterable=true is set for the first column (a string) but clearly doesn't work ;) (it should be 'true' per default anyway, right? Disabling it for the two that are filterable, does work). Also I forgot to ask : which version of XWiki NOiV is running ? Oh, good point: 2.4, if I'm not mistaken. Thanks again! On Wed, Jan 5, 2011 at 6:18 PM, Jerome Velociter jer...@xwiki.com wrote: Hi Joris, While date filters are not supported yet (also I would like to work on that in a not-so-far future), the other property types should work as expected. We can't see your screenshot since this list does not support attachments. Can you post it somewhere on the web and point us to it ? Thanks, Jerome. On Wed, Jan 5, 2011 at 4:34 PM, Joris Dirks joris+xw...@user.stekje.nl wrote: I'm having fun with the livetable macro but can't seem to enable filtering for certain columns. It seems this is because they aren't TextArea but have the type 'String', 'Date' or 'Static List'. Screenshot for illustration. I am not sure anymore why I made the property 'indieneradres' in my example a string when I created a certain class but it bites me in the back now. (I probably wanted the form to validate the input). Should I just delete that property and make a new one of type TextArea? For the column with static list-values, I sort of expected a drop-down or multiselect filter of sorts. Thanks for your ideas! On a related note, the template for shown class shows up in the livetable (as IssueTemplate matches the option:className:Helpdesk.IssueClass). This results in a row with 'emptyvalue' for every value. Does anyone know of a quick fix for that? ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] java.security.NoSuchAlgorithmException: Cannot find any provider supporting DES/ECB/PKCS5Padding
There's a good idea. I'm running Windows XP with Sun Java 6 Update 22. On Thu, Jan 6, 2011 at 1:07 AM, Paul Libbrecht p...@hoplahup.net wrote: I won't be able to answer your question but it would help to indicate which JVM and which OS your are using. paul Le 6 janv. 2011 à 01:21, Mike a écrit : I've deployed Xwiki enterprise 2.7 on my Glassfish 2.1.1 server with MySQL as the back-end. I can create a user, but when I try to log in to that user, I am rewarded with the stack dump shown below. It's trying to find a provider of DES/ECB/PKCS5Padding. After about 30 minutes on Google and on Java.sun.com, I don't seem to be able to find where I can get this provider. Could some kind soul please give me some hints on where to look to download this? Thanks. Regards, Mike 2011-01-05 18:17:04,890 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/loginsubmit/XWiki/XWikiLogin ] ERROR xwiki.MyPersistentLoginManager - ERROR!! 2011-01-05 18:17:04,890 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/loginsubmit/XWiki/XWikiLogin ] ERROR xwiki.MyPersistentLoginManager - There was a problem encrypting the username or password!! 2011-01-05 18:17:04,890 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/loginsubmit/XWiki/XWikiLogin ] ERROR xwiki.MyPersistentLoginManager - Remember Me function will be disabled!! 2011-01-05 18:17:05,046 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/loginsubmit/XWiki/XWikiLogin ] WARN internal.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.XWiki.parseMessage] in /templates/login...@28,33 2011-01-05 18:17:05,140 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/view/Main/DocumentDoesNotExist ] WARN internal.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.XWiki.parseMessage] in @18,8 2011-01-05 18:17:53,640 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/login/XWiki/XWikiLogin?xredirect=http%3A%2F%2Flocalhost%3A8080%2Fxwiki%2Denterprise%2Dweb%2D2.7%2Fbin%2Fregister%2FXWiki%2FRegister ] WARN internal.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.XWiki.parseMessage] in /templates/login...@28,33 2011-01-05 18:17:57,734 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/loginsubmit/XWiki/XWikiLogin ] ERROR xwiki.MyPersistentLoginManager - Failed to encrypt text: miken java.security.NoSuchAlgorithmException: Cannot find any provider supporting DES/ECB/PKCS5Padding at javax.crypto.Cipher.getInstance(DashoA13*..) at com.xpn.xwiki.user.impl.xwiki.MyPersistentLoginManager.encryptText(MyPersistentLoginManager.java:391) at com.xpn.xwiki.user.impl.xwiki.MyPersistentLoginManager.rememberLogin(MyPersistentLoginManager.java:188) at com.xpn.xwiki.user.impl.xwiki.MyFormAuthenticator.processLogin(MyFormAuthenticator.java:221) at com.xpn.xwiki.user.impl.xwiki.MyFormAuthenticator.processLogin(MyFormAuthenticator.java:187) at com.xpn.xwiki.user.impl.xwiki.XWikiAuthServiceImpl.checkAuth(XWikiAuthServiceImpl.java:243) at com.xpn.xwiki.XWiki.checkAuth(XWiki.java:4125) at com.xpn.xwiki.user.impl.xwiki.XWikiRightServiceImpl.checkAccess(XWikiRightServiceImpl.java:169) ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] syntax nuances
Vincent, The wiki syntax to specify an image with params is [[image:...||params]]. Please let us know how to fix the doc to make it more obvious. My suggestion: show with other examples, how any syntax is allowed. [[--strikethrough-- examplelink]] ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Question about redirecting domain to XWiki.org wiki
Hi! We're trying to make our domain http://www.madridjug.org http://www.madridjug.org point straight to the entry page of http://madridjug.xwiki.com http://madridjug.xwiki.com We have set up a stealth domain redirection but when we point the browser to www.madridjug.org instead of getting the main page (that's http://madridjug.xwiki.com/xwiki/bin/view/Main/WebHome http://madridjug.xwiki.com/xwiki/bin/view/Main/WebHome ) we're presented with the login page in this fashion: http://www.madridjug.org/xwiki/bin/login/XWiki/XWikiLogin?srid=F7w697fQ http://www.madridjug.org/xwiki/bin/login/XWiki/XWikiLogin?srid=F7w697fQ The site can be browsed anonymously when entered via madridjug.xwiki.com so, what are we doing wrong? Can anybody suggest a fix? Best regards and thanks a lot. German -- View this message in context: http://xwiki.475771.n2.nabble.com/Question-about-redirecting-domain-to-XWiki-org-wiki-tp5897981p5897981.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] java.security.NoSuchAlgorithmException: Cannot find any provider supporting DES/ECB/PKCS5Padding
It sounds like your platform is missing a cryptography provider. Can you run this for me and tell me the output please? {{groovy}}println(javax.crypto.Cipher.getProvider().toString() + \n + javax.crypto.Cipher.getProvider().getClass().getName());{{/groovy}} FYI: I opened an issue for switching to a cipher which is included in bouncycastle which is shipped with xwiki. http://jira.xwiki.org/jira/browse/XWIKI-5863 Caleb On 01/06/2011 10:35 AM, Mike wrote: There's a good idea. I'm running Windows XP with Sun Java 6 Update 22. On Thu, Jan 6, 2011 at 1:07 AM, Paul Libbrecht p...@hoplahup.net wrote: I won't be able to answer your question but it would help to indicate which JVM and which OS your are using. paul Le 6 janv. 2011 à 01:21, Mike a écrit : I've deployed Xwiki enterprise 2.7 on my Glassfish 2.1.1 server with MySQL as the back-end. I can create a user, but when I try to log in to that user, I am rewarded with the stack dump shown below. It's trying to find a provider of DES/ECB/PKCS5Padding. After about 30 minutes on Google and on Java.sun.com, I don't seem to be able to find where I can get this provider. Could some kind soul please give me some hints on where to look to download this? Thanks. Regards, Mike 2011-01-05 18:17:04,890 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/loginsubmit/XWiki/XWikiLogin ] ERROR xwiki.MyPersistentLoginManager - ERROR!! 2011-01-05 18:17:04,890 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/loginsubmit/XWiki/XWikiLogin ] ERROR xwiki.MyPersistentLoginManager - There was a problem encrypting the username or password!! 2011-01-05 18:17:04,890 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/loginsubmit/XWiki/XWikiLogin ] ERROR xwiki.MyPersistentLoginManager - Remember Me function will be disabled!! 2011-01-05 18:17:05,046 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/loginsubmit/XWiki/XWikiLogin ] WARN internal.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.XWiki.parseMessage] in /templates/login...@28,33 2011-01-05 18:17:05,140 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/view/Main/DocumentDoesNotExist ] WARN internal.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.XWiki.parseMessage] in @18,8 2011-01-05 18:17:53,640 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/login/XWiki/XWikiLogin?xredirect=http%3A%2F%2Flocalhost%3A8080%2Fxwiki%2Denterprise%2Dweb%2D2.7%2Fbin%2Fregister%2FXWiki%2FRegister ] WARN internal.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.XWiki.parseMessage] in /templates/login...@28,33 2011-01-05 18:17:57,734 [ http://localhost:8080/xwiki-enterprise-web-2.7/bin/loginsubmit/XWiki/XWikiLogin ] ERROR xwiki.MyPersistentLoginManager - Failed to encrypt text: miken java.security.NoSuchAlgorithmException: Cannot find any provider supporting DES/ECB/PKCS5Padding at javax.crypto.Cipher.getInstance(DashoA13*..) at com.xpn.xwiki.user.impl.xwiki.MyPersistentLoginManager.encryptText(MyPersistentLoginManager.java:391) at com.xpn.xwiki.user.impl.xwiki.MyPersistentLoginManager.rememberLogin(MyPersistentLoginManager.java:188) at com.xpn.xwiki.user.impl.xwiki.MyFormAuthenticator.processLogin(MyFormAuthenticator.java:221) at com.xpn.xwiki.user.impl.xwiki.MyFormAuthenticator.processLogin(MyFormAuthenticator.java:187) at com.xpn.xwiki.user.impl.xwiki.XWikiAuthServiceImpl.checkAuth(XWikiAuthServiceImpl.java:243) at com.xpn.xwiki.XWiki.checkAuth(XWiki.java:4125) at com.xpn.xwiki.user.impl.xwiki.XWikiRightServiceImpl.checkAccess(XWikiRightServiceImpl.java:169) ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] java.security.NoSuchAlgorithmException: Cannot find any provider supporting DES/ECB/PKCS5Padding
I ran this in groovy: println(javax.crypto.Cipher.getInstance(DES/CBC/PKCS5Padding).getProvider().toString() + \n + javax.crypto.Cipher.getInstance(DES/CBC/PKCS5Padding).getProvider().getClass().getName()); and got this: SunJCE version 1.6 com.sun.crypto.provider.SunJCE So I wrote a little java program that did the same thing, and got the same result. Then, I wrote a little web app and deployed it on my server, and I got the result that Xwiki is giving me. So, obviously something is lacking from my server's classpath. However, I'm not smart enough to track down exactly what it is that is missing -- I don't know how to find out from where a given class is being resolved. A clue for the clueless would be gratefully received. Many thanks. Regards, Mike On Thu, Jan 6, 2011 at 8:04 PM, Caleb James DeLisle calebdeli...@lavabit.com wrote: println(javax.crypto.Cipher.getProvider().toString() + \n + javax.crypto.Cipher.getProvider().getClass().getName()); ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] java.security.NoSuchAlgorithmException: Cannot find any provider supporting DES/ECB/PKCS5Padding
On 01/07/2011 05:27 AM, Mike wrote: I ran this in groovy: println(javax.crypto.Cipher.getInstance(DES/CBC/PKCS5Padding).getProvider().toString() + \n + javax.crypto.Cipher.getInstance(DES/CBC/PKCS5Padding).getProvider().getClass().getName()); and got this: SunJCE version 1.6 com.sun.crypto.provider.SunJCE So I wrote a little java program that did the same thing, and got the same result. Then, I wrote a little web app and deployed it on my server, and I got the result that Xwiki is giving me. So, obviously something is lacking from my server's classpath. However, I'm not smart enough to track down exactly what it is that is missing -- I don't know how to find out from where a given class is being resolved. Can you run this in your server: System.out.println(System.getProperty(java.vm.vendor) + + System.getProperty(java.vm.name) + + System.getProperty(java.vm.version)); A clue for the clueless would be gratefully received. Many thanks. Regards, Mike On Thu, Jan 6, 2011 at 8:04 PM, Caleb James DeLisle calebdeli...@lavabit.com wrote: println(javax.crypto.Cipher.getProvider().toString() + \n + javax.crypto.Cipher.getProvider().getClass().getName()); ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] java.security.NoSuchAlgorithmException: Cannot find any provider supporting DES/ECB/PKCS5Padding
According to GlassFish: Java vm vendor: Sun Microsystems Inc. Java vm name = Java HotSpot(TM) Client VM Java vm version = 17.0-b16 According to a plain java app: Java vm vendor: Sun Microsystems Inc. Java vm name = Java HotSpot(TM) Client VM Java vm version = 17.0-b16 I've found that javax.crypto lives in jce.jar, which I've plastered all over my server's classpaths, and put into the Xwiki war's WEB-INF/lib but to no avail: I still get the same result. Call me confused. On Thu, Jan 6, 2011 at 10:40 PM, Sergiu Dumitriu ser...@xwiki.com wrote: On 01/07/2011 05:27 AM, Mike wrote: I ran this in groovy: println(javax.crypto.Cipher.getInstance(DES/CBC/PKCS5Padding).getProvider().toString() + \n + javax.crypto.Cipher.getInstance(DES/CBC/PKCS5Padding).getProvider().getClass().getName()); and got this: SunJCE version 1.6 com.sun.crypto.provider.SunJCE So I wrote a little java program that did the same thing, and got the same result. Then, I wrote a little web app and deployed it on my server, and I got the result that Xwiki is giving me. So, obviously something is lacking from my server's classpath. However, I'm not smart enough to track down exactly what it is that is missing -- I don't know how to find out from where a given class is being resolved. Can you run this in your server: System.out.println(System.getProperty(java.vm.vendor) + + System.getProperty(java.vm.name) + + System.getProperty(java.vm.version)); A clue for the clueless would be gratefully received. Many thanks. Regards, Mike On Thu, Jan 6, 2011 at 8:04 PM, Caleb James DeLisle calebdeli...@lavabit.com wrote: println(javax.crypto.Cipher.getProvider().toString() + \n + javax.crypto.Cipher.getProvider().getClass().getName()); ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Sergiu Dumitriu http://purl.org/net/sergiu/ ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users