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#getDatabase%28java.lang.String%29
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, m...@ow2.org <m...@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@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
