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.