Re: [xwiki-users] Show hidden spaces

2015-01-05 Thread Jean SIMARD
Hi Matthias,

Happy New Year too.

Not sure if this is relevant for your problem but in your user preferences, 
there is
an option about Display Hidden Documents.  Did you try to activate it?

But maybe this solution does not completely fit with your need.

Hope this helps.
On Sun, Jan 04, 2015 at 05:36:40AM -0700, Matthias Wegner wrote:
 Hi All,
 
 first of all. A happy new year to everybody.
  
 I hide some spaces with the extension
 http://extensions.xwiki.org/xwiki/bin/view/Extension/Hide+a+space because my
 user should not see my macro-space or some other admin-stuff. But i want to
 display for myself a simple page where i can list all hidden spaces and
 documents. The displaying of documents is easy with
 http://extensions.xwiki.org/xwiki/bin/view/Extension/Display+hidden+pages+from+a+specific+space.
 
 But how can i find the hidden spaces? $xwiki.spaces only gives me the
 not-hidden ones.
 
 Regards,
 Matthias
 
 
 
 --
 View this message in context: 
 http://xwiki.475771.n2.nabble.com/Show-hidden-spaces-tp7593554.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

-- 
Jean Simard
jean.sim...@xwiki.com
Research engineer at XWiki SAS
http://www.xwiki.com
Committer on the XWiki.org project
http://www.xwiki.org
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Show hidden spaces

2015-01-05 Thread Eduard Moraru
Hi Matthias,

Try this quick query/script to show you all spaces in which all documents
are hidden (i.e. do not contain visible documents):

{{velocity}}
#set ($spaces = $services.query.hql(SELECT DISTINCT doc.space FROM
XWikiDocument doc WHERE NOT EXISTS (SELECT doc2.fullName FROM XWikiDocument
doc2 WHERE doc2.space = doc.space AND doc2.hidden  1)).execute())

Hidden spaces:
#foreach ($space in $spaces)
  * $space
#end
{{/velocity}}

Thanks,
Eduard

On Mon, Jan 5, 2015 at 11:58 AM, Jean SIMARD jean.sim...@xwiki.com wrote:

 Hi Matthias,

 Happy New Year too.

 Not sure if this is relevant for your problem but in your user
 preferences, there is
 an option about Display Hidden Documents.  Did you try to activate it?

 But maybe this solution does not completely fit with your need.

 Hope this helps.
 On Sun, Jan 04, 2015 at 05:36:40AM -0700, Matthias Wegner wrote:
  Hi All,
 
  first of all. A happy new year to everybody.
 
  I hide some spaces with the extension
  http://extensions.xwiki.org/xwiki/bin/view/Extension/Hide+a+space
 because my
  user should not see my macro-space or some other admin-stuff. But i want
 to
  display for myself a simple page where i can list all hidden spaces and
  documents. The displaying of documents is easy with
 
 http://extensions.xwiki.org/xwiki/bin/view/Extension/Display+hidden+pages+from+a+specific+space
 .
 
  But how can i find the hidden spaces? $xwiki.spaces only gives me the
  not-hidden ones.
 
  Regards,
  Matthias
 
 
 
  --
  View this message in context:
 http://xwiki.475771.n2.nabble.com/Show-hidden-spaces-tp7593554.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

 --
 Jean Simard
 jean.sim...@xwiki.com
 Research engineer at XWiki SAS
 http://www.xwiki.com
 Committer on the XWiki.org project
 http://www.xwiki.org
 ___
 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] [myxwiki] new wiki request

2015-01-05 Thread Steen Klingenberg
description: Wiki for documenting a private software solution named
Zucchini

 

owner name:  Steen Klingenberg

 

wiki name:   Zucchini

 

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


Re: [xwiki-users] Using a JDNI DataSource for connection pooling

2015-01-05 Thread Bryn Jeffries
I finally got a JDNI connection pool working, at least with Java, and 
presumably Groovy will work too with the same code. The main problem was that 
the documented Tomcat convention of using a context file at WEB_INF/context.xml 
wasn't working, and so the connection details weren't being read. I finally 
solved this by putting the Resource details into xwiki.xml instead. In case 
it's of any help to others I've added the details to 
http://extensions.xwiki.org/xwiki/bin/view/Extension/Execute+SQL#HUsingaJNDIDatasource
 

Regards,

Bryn

From: Bryn Jeffries [bryn.jeffr...@sydney.edu.au]
Sent: 23 December 2014 14:31
To: users@xwiki.org
Subject: [xwiki-users] Using a JDNI DataSource for connection pooling

I've been exploring connection pooling for an external database, but I'm 
struggling to use it. I'm running XWiki 6.3 on a Ubuntu server. In 
/etc/xwiki/context.xml I have

?xml version=1.0 encoding=UTF-8?
Context
  !-- JDBC datasource for myDB --
  Resource name=jdbc/mydbds
auth=Container
type=javax.sql.DataSource
username=dbuser
password=dbpass
driverClassName=org.postgresql.Driver
url=jdbc:postgresql:alertdb
maxActive=10
maxIdle=4 /
  /Context

And I have a symlink to this at /usr/lib/xwiki/WEB-INF/context.xml

I'm trying to test that I can access this with a Groovy script. I'm not 
entirely sure of the correct approach here, but the most successful I've got it 
with
{{groovy}}
import groovy.sql.Sql
import javax.naming.Context
import javax.naming.InitialContext
import javax.sql.DataSource

Context ctx = new InitialContext();
DataSource dataSource = (DataSource) ctx.lookup(jdbc/mydbds);
def sql = new Sql(dataSource)
{{/groovy}}

However this fails with
javax.naming.NameNotFoundException: Name [jdbc/mydbds] is not bound in this 
Context. Unable to find [jdbc].

Would anyone be able to tell me whether this is the right sort of way to be 
going about using a JNDI resource, and what's wrong with my implementation?

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