date:20101021

Re: [xwiki-users] DB List Query Problems

2010-10-21 Thread Marius Dumitru Florea

Hi Martin,

On 10/20/2010 09:10 PM, mbryant wrote:

 So using HQL in velocity helps a little, I have been able to get results, and
 for that I thank you.  I did run into an unexpected issues that you might be
 able to help with.  Below is the query that was used

 {{velocity}}


 #set($hql = select obj.name, prop.value from BaseObject obj, StringProperty
 prop where obj.className='CustClasses.ToolClass' and prop.id.id=obj.id and
 prop.name='ProductName')

 #set($results = $xwiki.search($hql, 1000, 0))
 #foreach ($item in $results)
   * $item
 #end
 {{/velocity}}


 While I get a result it is an unexpected value, it appears to have returned
 the object ID see below:


 * [Ljava.lang.Object;@af0baa

That's normal because $item is an array of Java objects (xobject name 
and property value) and by simply printing $item you are in fact calling 
its toString() method which returns the string you see.


 It should be noted when I just try to get the obj.name without the property
 value it works fine.

That's normal too, because in this case $item is not an array of Java 
objects but a string (xobject name).

You can use this code to display the results:

|=Object Name|=Property Value
#foreach ($item in $results)
|$item.get(0)|$item.get(1)
#end

Hope this helps,
Marius


 Now that I know the Query generally works in Velocity, It should be the same
 thing to just cut and paste the Query into the DB List attribute of an
 object.

 Thanks for your continued help and timely response.

 On a side note, I would like to be able to create links on results (when
 used inside of a velocity script on a page), is there an easy way to do that
 as well?

 Martin
 Modus Operandi
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] I'll be in The Hague on November 1st

2010-10-21 Thread Guillaume Lerouge

Hi XWiki users,

I'll be in The Hague on November 1st to give a XWiki workshop. For those of
you who'd like to attend (and who speak Dutch), all the details are on:
https://noiv.nl/actueel/nieuws/2010/10/18/workshop-over-de-waarde-van-open-source-xwiki-voor-organisaties/

Looking forward meeting some of you guys there,

Guillaume
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

[xwiki-users] Java using 100%

2010-10-21 Thread [Ricardo Rodriguez] eBioTIC.

Hi!

In a 2.4.1 XE/XEM installation with contents recently migrated from a XE 
1.3.8295 I'm seeing this:

top - 12:15:06 up 16 days,  8:38,  3 users,  load average: 1.36, 1.39, 1.32
Tasks: 1062 total,   1 running, 1061 sleeping,   0 stopped,   0 zombie
Cpu(s):  7.8%us,  0.2%sy,  0.0%ni, 92.0%id,  0.0%wa,  0.0%hi,  0.0%si,  
0.0%st
Mem:   6216784k total,  5992440k used,   224344k free,95312k buffers
Swap:  2104472k total,  152k used,  2104320k free,  3222044k cached

  PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  
COMMAND  
17689 root  22   0  668m 550m 2852 S  100  9.1 216:28.00 
java  

Java goes back to normal if I shut down the Tomcat instance on which 
XWiki is running. Catalina.out is plenty of errors and warnings and I 
really don't know which of them, if any, could be responsible of this 
situation.

Lucene is not working neither.

I'm linking a catalina.out file truncated by yesterday at 22:19 after a 
Tomcat shutdown. Please, could you help me to work out this errors and 
warnings?

http://ftp.ebiotic.net/fromPeat/catalina.out.201010211227.txt

Thanks for your help!

Ricardo
 

-- 
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] Open Office import plugin is not working in XEM 2.4.3

2010-10-21 Thread AngeloG



AngeloG wrote:
 
 Hi everybody,
 
 I have XEM 2.3 working in a test environment with OpenSuse 11.3, Mysql
 5.1, OpenOffice 3.2.1, and Jetty, as per defualt war distributed, and
 everything is working fine.
 I made the upgrade to XEM 2.4.3 version, importing new xar, also. I made
 modifications to the relevant  
 xwiki.properties file to make the Office importer section identical to the
 previous 2.3 version, (see below) but the office server does not start and
 import is not working in 2.4.3!
 --
 xwiki.log file: (XEM 2.4.3)
 
 2010-10-18 11:23:05,125 [main] ERROR rnal.DefaultObservationManager  -
 Fail to send event
 [org.xwiki.observation.event.applicationstartedev...@1d592a] to listener
 [org.xwiki.officeimporter.internal.openoffice.openofficemanagerlifecycleliste...@c8e4de]
 java.lang.IllegalStateException: invalid templateProfileDir:
 /home/smg/.ooo3/user
 at
 org.artofsolving.jodconverter.office.DefaultOfficeManagerConfiguration.buildOfficeManager(DefaultOfficeManagerConfiguration.java:122)
 at
 org.xwiki.officeimporter.internal.openoffice.DefaultOpenOfficeManager.initialize(DefaultOpenOfficeManager.java:102)
 at
 org.xwiki.officeimporter.internal.openoffice.DefaultOpenOfficeManager.start(DefaultOpenOfficeManager.java:135)
 at
 org.xwiki.officeimporter.internal.openoffice.OpenOfficeManagerLifecycleListener.startOpenOffice(OpenOfficeManagerLifecycleListener.java:96)
 at
 org.xwiki.officeimporter.internal.openoffice.OpenOfficeManagerLifecycleListener.onEvent(OpenOfficeManagerLifecycleListener.java:83)
 at
 org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:269)
 at
 org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:243)
 at
 org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:290)
 at
 org.xwiki.container.servlet.XWikiServletContextListener.contextInitialized(XWikiServletContextListener.java:76)
 at
 org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548)
 at
 org.mortbay.jetty.servlet.Context.startContext(Context.java:136)
 at
 org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)
 at
 org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517)
 at
 org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:467)
 at
 org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
 at
 org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
 at
 org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156)
 at
 org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
 at
 org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
 at
 org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
 at
 org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
 at org.mortbay.jetty.Server.doStart(Server.java:224)
 at
 org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
 at
 org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:985)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:616)
 at org.mortbay.start.Main.invokeMain(Main.java:194)
 at org.mortbay.start.Main.start(Main.java:534)
 at org.mortbay.start.Main.start(Main.java:441)
 at org.mortbay.start.Main.main(Main.java:119)
 
 
 Since it is a test environment, I can easily start/stop Jetty container
 and choose to use 2.3 or 2.4.3 versions, which are in different dirs but
 they use the same database. Since the values of the parameters in the
 Office import section of the xwiki.properties are exactly the same and if
 I use 2.3 version Office server starts and import works fine, I wonder if
 this is a bug of version 2.4.3 or what can be my mistake in configuration.
 ---
 xwiki.properties file: (good for 2.3 , bad for 2.4.3)
 
 # Settings for the OpenOffice server instance consumed by the
 OfficeImporter plugin
 #--
  
 #-# [Since 1.9M2]
 #-# Type of the openoffice server instance used by officeimporter plugin.
 #-# 0 - Internally managed server instance. (Default)
 #-# 1 - Externally managed (local) server instance.
 # openoffice.serverType=0
 
 #-# [Since 1.9M2]
 #-# Port number used for connecting to the openoffice server instance.
 #-# Default port is 8100
 # openoffice.serverPort=8100
 
 #-# [Since 1.9M2]
 #-# If the

Re: [xwiki-users] Open Office import plugin is not working in XEM 2.4.3

2010-10-21 Thread AngeloG



AngeloG wrote:
 
 Hi everybody,
 
 I have XEM 2.3 working in a test environment with OpenSuse 11.3, Mysql
 5.1, OpenOffice 3.2.1, and Jetty, as per defualt war distributed, and
 everything is working fine.
 I made the upgrade to XEM 2.4.3 version, importing new xar, also. I made
 modifications to the relevant  
 xwiki.properties file to make the Office importer section identical to the
 previous 2.3 version, (see below) but the office server does not start and
 import is not working in 2.4.3!
 --
 xwiki.log file: (XEM 2.4.3)
 
 2010-10-18 11:23:05,125 [main] ERROR rnal.DefaultObservationManager  -
 Fail to send event
 [org.xwiki.observation.event.applicationstartedev...@1d592a] to listener
 [org.xwiki.officeimporter.internal.openoffice.openofficemanagerlifecycleliste...@c8e4de]
 java.lang.IllegalStateException: invalid templateProfileDir:
 /home/smg/.ooo3/user
 at
 org.artofsolving.jodconverter.office.DefaultOfficeManagerConfiguration.buildOfficeManager(DefaultOfficeManagerConfiguration.java:122)
 at
 org.xwiki.officeimporter.internal.openoffice.DefaultOpenOfficeManager.initialize(DefaultOpenOfficeManager.java:102)
 at
 org.xwiki.officeimporter.internal.openoffice.DefaultOpenOfficeManager.start(DefaultOpenOfficeManager.java:135)
 at
 org.xwiki.officeimporter.internal.openoffice.OpenOfficeManagerLifecycleListener.startOpenOffice(OpenOfficeManagerLifecycleListener.java:96)
 at
 org.xwiki.officeimporter.internal.openoffice.OpenOfficeManagerLifecycleListener.onEvent(OpenOfficeManagerLifecycleListener.java:83)
 at
 org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:269)
 at
 org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:243)
 at
 org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:290)
 at
 org.xwiki.container.servlet.XWikiServletContextListener.contextInitialized(XWikiServletContextListener.java:76)
 at
 org.mortbay.jetty.handler.ContextHandler.startContext(ContextHandler.java:548)
 at
 org.mortbay.jetty.servlet.Context.startContext(Context.java:136)
 at
 org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1250)
 at
 org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:517)
 at
 org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:467)
 at
 org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
 at
 org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
 at
 org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:156)
 at
 org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
 at
 org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:152)
 at
 org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
 at
 org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:130)
 at org.mortbay.jetty.Server.doStart(Server.java:224)
 at
 org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:50)
 at
 org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:985)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:616)
 at org.mortbay.start.Main.invokeMain(Main.java:194)
 at org.mortbay.start.Main.start(Main.java:534)
 at org.mortbay.start.Main.start(Main.java:441)
 at org.mortbay.start.Main.main(Main.java:119)
 
 
 Since it is a test environment, I can easily start/stop Jetty container
 and choose to use 2.3 or 2.4.3 versions, which are in different dirs but
 they use the same database. Since the values of the parameters in the
 Office import section of the xwiki.properties are exactly the same and if
 I use 2.3 version Office server starts and import works fine, I wonder if
 this is a bug of version 2.4.3 or what can be my mistake in configuration.
 ---
 xwiki.properties file: (good for 2.3 , bad for 2.4.3)
 
 # Settings for the OpenOffice server instance consumed by the
 OfficeImporter plugin
 #--
  
 #-# [Since 1.9M2]
 #-# Type of the openoffice server instance used by officeimporter plugin.
 #-# 0 - Internally managed server instance. (Default)
 #-# 1 - Externally managed (local) server instance.
 # openoffice.serverType=0
 
 #-# [Since 1.9M2]
 #-# Port number used for connecting to the openoffice server instance.
 #-# Default port is 8100
 # openoffice.serverPort=8100
 
 #-# [Since 1.9M2]
 #-# If the

Re: [xwiki-users] Livetable does not show results

2010-10-21 Thread [Ricardo Rodriguez] eBioTIC.

Hi!

Gerritjan Koekkoek wrote:
 Hi

 I only have 2.5, deinstalled the old version
 In my situation It looks like it is only working on classes where the classes 
 sit in the XWiki space and the documents holding the objects are in the same 
 space?
 So it works with users, but not with panels.panelclass (or my own custom 
 developed class). It does work brilliantly with tag-class Even get unexected 
 goodies
   

It also works here with custom developed classes. See this, I've created 
it trying to find an answer to another message sent to the list...

http://ebiotic.net/bin/ICT/LiveTableModusOperandi
 I do not think it's the generator script, but something with livetable?

 Gerritjan

 Op 20 okt 2010, om 01:05 heeft [Ricardo Rodriguez] eBioTIC. het volgende 
 geschreven:

 Hi,

 Thibaut Camberlin wrote:
   
 Hi Gerritjan,

 Ludovic did that script not me I have to say!

 Did you test the same code on another version of XWiki ? If so what is the
 behaviour and the version ?
 Can you generate the livetable based on another class, say XWiki.XWikiUsers,
 what is the result ?


 

 It is working fine in a XE/XEM 2.4.1 system. Thibaut, you can check it 
 here...

 http://ebiotic.net/bin/ICT/LiveTableUsers

   
 On Tue, Oct 19, 2010 at 7:48 PM, Gerritjan Koekkoek 
 gerritjankoekk...@gmail.com wrote:


 
 Hi Thibaut,
 The script works like magic, very nice.
 Copy and Paste from the link created some formatting challenges, but after
 fixing the script generated actually created a live table;
 BUT...
 Still there are no records displayed? Like with the script I put in this
 question.
 The pages where the objects are stored are in a space that has access
 forbidden for unregistered users?
 Off course I run the generated script as a registered user (actually as a
 admin user
 I'm running this on xwiki 2.5

 Gerritjan

 Op 18 okt 2010, om 23:11 heeft Thibaut Camberlin het volgende geschreven:

 Hi Gerritjan,

 You can use the livetable generator code snippet
 http://code.xwiki.org/xwiki/bin/view/Snippets/LivetableGeneratorSnippet

 Hope this helps,
 --
 Thibaut


 On Sun, Oct 17, 2010 at 2:23 PM, Gerritjan Koekkoek 
 gerritjankoekk...@gmail.com wrote:


   
 Hi,

 i'm trying to use LiveTable to improve our user experience.
 This is my code:

 #set($collist = [name, email , subject, status, question,
 answer, generalize])

 #set($colprops = {
 name : { type : text, size : 20,  link : view},
 email :{ type : text, size : 20,  link : view},
 subject :{ type : text, size : 20, link : none},
 status :{ type : text, size : 20, link : none},
 question :{ type : text, size : 20, link : none, html :
 true, sortable:false },
 answer :{ type : text, size : 20, link : none, html :
 true, sortable:false },
 generalize : { type : list, class:
 CdlsatdCode.CdLS_ATD_UserQuestionsClass}
   })

 #set($options = {
 className:CdlsatdCode.CdLS_ATD_UserQuestionsClass,
 rowCount: 15 })
 p/
 #livetable(myLTQuestions $collist $colprops $options)

 It does show the table, but without any rows!
 The last column does recognize the List box as defined in the Class,
 because when I click it it shows the list of values defined in the class

 If I use a jsonQuery as in the example below, I get two records as

 
 defined

   
 in the filter.
 I tried to replace the above options value className with resultPage
 pointing to page containing the jsonQuery below... but with the same

 
 result,

   
 no rows returned

 ===
 {{include document=XWiki.LiveTableResultsMacros /}}
 {{velocity}}
 #gridresultwithfilter(CdlsatdCode.CdLS_ATD_UserQuestionsClass
 $request.collist.split(,)   and doc.creator='$context.user')
 {{/velocity}}

 the page I get shows me:
 {
 totalrows: 2,
 matchingtags: {
 },
 tags : [
 ],
 returnedrows:  0 ,
 offset: 1,
 reqNo: $request.reqNo,
 rows: [
 {
 doc_viewable : true,
 doc_name : GerritjanKoekkoek_doc261,
 doc_fullname : xwiki:CdlsatdPrivate.GerritjanKoekkoek_doc261,
 doc_space : CdlsatdPrivate,
 doc_url :


 
 \/xwiki%2Denterprise%2Dweb%2D2.5\/bin\/view\/CdlsatdPrivate\/GerritjanKoekkoek_doc261,

   
 doc_space_url :
 \/xwiki%2Denterprise%2Dweb%2D2.5\/bin\/view\/CdlsatdPrivate\/,
 doc_hasadmin  : true,
 doc_edit_url :


 
 \/xwiki%2Denterprise%2Dweb%2D2.5\/bin\/inline\/CdlsatdPrivate\/GerritjanKoekkoek_doc261,

   
 doc_copy_url   :


 
 \/xwiki%2Denterprise%2Dweb%2D2.5\/bin\/view\/XWiki\/CopyDocument?sourcedoc=xwiki%3ACdlsatdPrivate.GerritjanKoekkoek_doc261,

   
 doc_delete_url :


 
 \/xwiki%2Denterprise%2Dweb%2D2.5\/bin\/delete\/CdlsatdPrivate\/GerritjanKoekkoek_doc261,

   
 doc_rename_url :


 
 \/xwiki%2Denterprise%2Dweb%2D2.5\/bin\/view\/CdlsatdPrivate\/GerritjanKoekkoek_doc261?xpage=renamestep=1,

   
 doc_rights_url :


 
 \/xwiki%2Denterprise%2Dweb%2D2.5\/bin\/edit\/CdlsatdPrivate\/GerritjanKoekkoek_doc261?editor=rights,

   
 doc_author_url :

Re: [xwiki-users] some problem with Lucene - Exception while switching to database ...

2010-10-21 Thread Thomas Mortagne

On Wed, Oct 20, 2010 at 11:46, [Ricardo Rodriguez] eBioTIC.
ricardo.rodrig...@ebiotic.net wrote:

Thomas Mortagne wrote:
On Tue, Oct 19, 2010 at 21:11, [Ricardo Rodriguez] eBioTIC.
ricardo.rodrig...@ebiotic.net wrote:

Hi!

In a XE/XEM 2.4.1 farm, our Lucene building index process stopped as ...

*Lucene is currently building its index, 41 documents in queue.

*And we can't access Search in XWiki Preferences of any of the subwikis
or even the controller.*
*
I see this in xwiki.log:

com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while
switching to database redpatrimonio

The only way to have this error I know is to have a
XWiki.XWikiServerRedpatrimonio page with a wiki descriptor object and
no corresponding database.

Wrapped Exception: Unknown database 'redpatrimonio'
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:643)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:742)
at
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:683)
at
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:289)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1463)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1506)
at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:166)
at com.xpn.xwiki.api.XWiki.getDocument(XWiki.java:153)
at com.xpn.xwiki.plugin.lucene.SearchResult.init(SearchResult.java:98)
at
com.xpn.xwiki.plugin.lucene.SearchResults.getRelevantResults(SearchResults.java:72)
at
com.xpn.xwiki.plugin.lucene.SearchResults.getHitcount(SearchResults.java:22

In fact, that database is called redepatrimonio, not redpatrimonio.

The wiki descriptor page name in the main wiki is
XWiki.XWikiServerRedepatrimonio.

Are you sure you don't have XWiki.XWikiServerRedpatrimonio too.

I think I haven't it. Please, see...

I think you used to have it and it has been removed but lucene plugin
did not see that and now you have document in lucene index that don't
exists. Try to recreate the lucene index.

http://ebiotic.net/bin/ICT/Subwikis

Please, where the name of the database as listed in the exception is
stored? How could I correct it?

I don't know how I've messed things and if this error is related with
problem, but it seems that need to be corrected before trying anything else!

In any case, it's also a Lucene plugin bug since a ghost wiki should
not break it, would be nice if you could report it on
http://jira.xwiki.org.

I'm doing some more research. I'll create a JIRA issue with the results.

Thanks!

Ricardo

--
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

--
Thomas Mortagne
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] some problem with Lucene - Exception while switching to database ...

2010-10-21 Thread Thomas Mortagne

On Thu, Oct 21, 2010 at 16:50, Thomas Mortagne
thomas.morta...@xwiki.com wrote:
On Wed, Oct 20, 2010 at 11:46, [Ricardo Rodriguez] eBioTIC.
ricardo.rodrig...@ebiotic.net wrote: