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 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
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
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
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 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
[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] 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-- example>>link]] ___ 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 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@xwiki.org
On Thu, Jan 6, 2011 at 2:38 PM, Jerome Velociter wrote: > Hoï Jorris, > > On Thu, Jan 6, 2011 at 12:37 PM, Joris Dirks > 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 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 >>> 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
users@xwiki.org
Hoï Jorris, On Thu, Jan 6, 2011 at 12:37 PM, Joris Dirks 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 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 >> 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] "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] "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"
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
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}}> resulting. 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 but if
>> you want to render a you need to use {{html }}> class="myclass">text{{/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:
>
> http://xwiki.org";> class="myclass"> src="http://localhost:8080/xwiki/bin/download/Sandbox/WebHome/XWikiLogo.png?width=25&height=25";
> width="25" height="25" alt="XWikiLogo.png"/>
>
> So as you can see it does generate a.
>
> 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:
>
> http://xwiki.org";> src="http://localhost:8080/xwiki/bin/download/Sandbox/WebHome/XWikiLogo.png?width=25&height=25";
> width="25" height="25" class="myclass" alt="XWikiLogo.png"/>
>
> 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.png>>http://xwiki.org]]
>
> How can I have a sized image with a link ?
> not working:
> [[image:img.png||width="25" height="25">>http://xwiki.org]]
not correct
> [[image:img.png>>http://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 [[linklabelhere>>reference]], 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.png>>http://xwiki.org]]
>
> and
> (% style="height:25px;width:25px"
> [[image:img.png>>http://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"
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
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}} resulting . 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 but if
> you want to render a you need to use {{html }} class="myclass">text{{/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:
http://xwiki.org";>http://localhost:8080/xwiki/bin/download/Sandbox/WebHome/XWikiLogo.png?width=25&height=25";
width="25" height="25" alt="XWikiLogo.png"/>
So as you can see it does generate a .
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:
http://xwiki.org";>http://localhost:8080/xwiki/bin/download/Sandbox/WebHome/XWikiLogo.png?width=25&height=25";
width="25" height="25" class="myclass" alt="XWikiLogo.png"/>
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.png>>http://xwiki.org]]
How can I have a sized image with a link ?
not working:
[[image:img.png||width="25" height="25">>http://xwiki.org]]
>>> not correct
>>>
[[image:img.png>>http://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 [[linklabelhere>>reference]], 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.png>>http://xwiki.org]]
and
(% style="height:25px;width:25px"
[[image:img.png>>http://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
Am 06.01.2011 11:11, schrieb Vincent Massol:
Yesss - so now I can remove the ugly {{html}} . 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 but if
you want to render a you need to use {{html }}text{{/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.png>>http://xwiki.org]]
>>>
>>> How can I have a sized image with a link ?
>>> not working:
>>> [[image:img.png||width="25" height="25">>http://xwiki.org]]
>> not correct
>>
>>> [[image:img.png>>http://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 [[linklabelhere>>reference]], 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.png>>http://xwiki.org]]
>>>
>>> and
>>> (% style="height:25px;width:25px"
>>> [[image:img.png>>http://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
users@xwiki.org
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 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 > 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
[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] 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.png>>http://xwiki.org]] >> >> How can I have a sized image with a link ? >> not working: >> [[image:img.png||width="25" height="25">>http://xwiki.org]] > > not correct > >> [[image:img.png>>http://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 [[linklabelhere>>reference]], 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.png>>http://xwiki.org]] >> >> and >> (% style="height:25px;width:25px" >> [[image:img.png>>http://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.png>>http://xwiki.org]] > > How can I have a sized image with a link ? > not working: > [[image:img.png||width="25" height="25">>http://xwiki.org]] not correct > [[image:img.png>>http://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.png>>http://xwiki.org]] > > and > (% style="height:25px;width:25px" > [[image:img.png>>http://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] 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.png>>http://xwiki.org]] How can I have a sized image with a link ? not working: [[image:img.png||width="25" height="25">>http://xwiki.org]] [[image:img.png>>http://xwiki.org||width="25" height="25"]] not working either (with and without 'px'): (% style="height:25px;width:25px" %) [[image:img.png>>http://xwiki.org]] and (% style="height:25px;width:25px" [[image:img.png>>http://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
