Hi. I am the author of this extension. After installing it, you just need to go to the space "SQLTools". If you want to do a request on an external database, then go to "SQLTools.Query". Then you fill in the form (user/password, URL of the database, JDBC driver to use). You may need to add your own JDBC driver in the WEB-INF/lib directory of the application if the database is different than the one used by XWiki. The, you just need to write your query. I hope it helps, Louis-Marie 2014-02-14 9:26 GMT+01:00 Hamster <[email protected]>:
To all,
I want to use velocity or groovy to query an external SQL Database. I have found the SQL Tools Extension <http://extensions.xwiki.org/xwiki/bin/view/Extension/SQL+Tools> but I have NO clue how to use this extension! It seems to be out of date (I am using XWiki 5.4) because the page that comes with the extension is garbled (parts of the page shows the code, parts of the page shows an HTML form).
Is the SQL Tools Extension the right tool to use to query an external SQL Database? Does anyone have an example (velocity or groovy) on how to query an external SQL Database?
-- View this message in context: http://xwiki.475771.n2.nabble.com/How-to-use-the-SQL-Tools-tp7589126.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users