Package ua.gradsoft.xwikisql

XWikiSQL - plugin which allows us to query foreigh relational databases from velocity pages.

See:
          Description

Interface Summary
SqlErrorable Generic interface for objects, which can track sql errors.
SqlResult Assess object for results of query execution.
SqlResultRow Temporary object, which used for navigation accross query results in velocity #foreach loops.
 

Class Summary
SqlDatabase Object, which holds name of connection pool and can evaluate sql statements on it.
SqlPlugin XWiki sql plugin
SqlPluginApi API Object
SqlPluginConfiguration Object, which holds configuration information.
SqlTypes static class for work with sql types.
 

Exception Summary
SqlRuntimeException Runtime exception, which denote errors inside SQL.
 

Package ua.gradsoft.xwikisql Description

XWikiSQL - plugin which allows us to query foreigh relational databases from velocity pages.

In gnerelal, process of using XWikiSqlPlugin can be described in next way:

Example of usage:

## connect to database.
#set  ($mydb=$xwiki.sql.getDabase('MyDS'))
## print top 10 records from our table.
<table>
#foreach($row in $mydb.executeQuery(
                    'select id, name 
                          from (select id, name, rownum from test_table) 
                          where rownum < 10'
              ))
 <tr>
  <td> $row.getLong('id') </td>
  <td> $row.getString('name') </td>
 </tr>
#end
</table>

(C) GradSoft Ltd, Kiev, Ukraine.
http://www.gradsoft.ua

License: GPL version 3