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 <teunham(a)hotmail.com>om>:
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users