Hi Bryn,
On 17 Dec 2014 at 22:49:26, Bryn Jeffries ([email protected](mailto:[email protected])) wrote: > I wrote: > > I have managed the following with an external PostgreSQL server: > > Retrieve and display queried data in a page with Groovy; Write a Java > > component to perform query, call and display with Groovy or Velocity; > > Generate JSON data of query results with Groovy, call and display from > > LiveTable. > > > > Happy to share but not near my computer till later today, so let me know > > which of the above is closest to what you want to do and I'll post something > > when I can. > > I've put some examples into the following wiki page: > http://platform.xwiki.org/xwiki/bin/view/DevGuide/ExternalDBAccess > > I hope that's the correct approach to sharing this kind of stuff - please > advise if not. Thanks for this! :) It’s great to see participation in the wiki. Now, I’ve done some gardening and since we already have a page about executing SQL (http://extensions.xwiki.org/xwiki/bin/view/Extension/Execute+SQL), I have merged your tutorial on this page. Hope it’s fine with you! Also note that you should use a connection pool and use a data source instead of defining the user/password/url directly. Thanks! -Vincent _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
