27 Nov
2014
27 Nov
'14
6:31 p.m.
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, mh(a)ow2.org <mh(a)ow2.org> 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users