2 Jul
2012
2 Jul
'12
5:43 p.m.
Hi Matt,
On Jul 2, 2012, at 5:11 PM, Matt Lamoureux wrote:
Hmm, ExecuteSQL looks like it will only work on the
wiki database. I was
looking for something similar to XwikSqlPlugin - where it could generate
wiki pages from our application database schemas. Then I found things like
SchemaSpy and SQLFairy. It would be sweet if there was a plugin built
around either of those technologies, but maybe I will have time to play
with that later. For now, if there is nothing readily available or easily
adapted, I think we will just have to rely on manual updates…
Another solution is just to write JDBC code in Groovy inside a wiki page.
Groovy even has some syntactic sugar to make that easy, see
http://extensions.xwiki.org/xwiki/bin/view/Extension/Execute+SQL
(I've updated it)
Note that it would be nice to find out how to define a data source in xwiki's web.xml
and use that instead of having to specify the credentials in the page. I haven't
researched that but it should be pretty easy to do by doing some JNDI lookup or something
similar.
Thanks
-Vincent