You was right, I have no programming rights. But I dont know where to set them. Because I dont have no administration button in my xwiki. I import XAR file with templates etc, and when I log as new user I have any rights to do something.

You can import xwiki-manager.xar to receive administration UI. But this theme is specific to you wiki installation (I don't know what wiki you installed and how) and are xwiki-specific. So, I will redirect this to xwiki mail list.

2009/11/27 Ruslan Shevchenko <[email protected]>

...

1. are user, which do changes, have programming rights ? (add logEnabled to config, to check this) [ see

http://redmine.gradsoft.ua/repositories/entry/jungleplatform/platform/web/xw... ] line 31

2. Otherwise, on debug enabled you must see messages. (see

http://redmine.gradsoft.ua/repositories/entry/jungleplatform/platform/web/xw... line 85)

...

So I made some changes:

context.xml

<Context>

<Resource name="jdbc/hw" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="root" password="polop" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/hw"/> <WatchedResource>WEB-INF/web.xml</WatchedResource> </Context>

web.xml in xwiki inside <web-app>

<resource-ref> <description>DB Connection</description> <res-ref-name>jdbc/hw</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>

log4j was added

in catalina.log there are just informations about start or stop

I add this line to xwiki.cfg xwikisql.initialContextPrefix=jdbc

this code was used in velocity:

#set($plugin = $xwiki.sql) plugin is $plugin #set($db = $plugin.getDatabase('hw')) db is $db

and result is:

plugin is ua.gradsoft.xwikisql.SqlPluginApi@802ed1

db is $db