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 > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
