Hi, I did not use that extension, nor had to write SQL queries on remote databases in velocity (you usually write a component and/or script service to do that for your and expose the results to the velocity UI), but that extension seems to have an impressive amount of documentation linked from the description: http://xwikisql.gradsoft.ua/docs/XWikiSqlPluginGuide.html including code http://xwikisql.gradsoft.ua/docs/api/ua/gradsoft/xwikisql/SqlPluginApi.html#... Also, googling for "jetty data source" gives a pretty good results https://wiki.eclipse.org/Jetty/Howto/Configure_JNDI_Datasource + https://wiki.eclipse.org/Jetty/Feature/JNDI Same for tomcat, etc. Hope this helps, Eduard On Wed, Nov 26, 2014 at 11:30 AM, [email protected] <[email protected]> wrote:

Hi,

We are looking for the best way to access an external SQL database using velocity exclusively (because we can't write a macro using groovy language).

So, we installed and tried to use this plugin : http://extensions.xwiki.org/xwiki/bin/view/Extension/SQL+Plugin. The plugin is properly installed. Now we are unsure how to use it : there is no mention of the user which is used to connect to the database, do we have to to configure a JNDI ? How ?

As a side question, what is you guys your preferred method to program xwiki pages with external database access ?

Thanks

-- Martin _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users