19 Dec
2014
19 Dec
'14
4:50 p.m.
Hi Bryn,
On 17 Dec 2014 at 22:49:26, Bryn Jeffries
(bryn.jeffries@sydney.edu.au(mailto:bryn.jeffries@sydney.edu.au)) wrote:
I wrote:
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
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.