...
You could, however, use MySQL or Oracle if you prefer and you will just need to adjust your settings and use the appropriate drivers in place of the Derby ones. SakaiAdminX ships with DB scripts for both Derby and MySQL. If you want to run SakaiAdminX on Oracle, you might need to tweak the scripts - if you do, send them to me for inclusion in the release. All SAL SQL in SakaiAdminX should be database independent.
| Note | ||
|---|---|---|
| ||
You will need to create your database using either the MySQL console or your favourite database editor. You should create your database with the UTF-8 character set, ie 'create database sakaiadminx default character set utf8;' |
The following is for those who wish to use Derby, if you are using MySQlMySQL/Oracle, you can skip this section - BUT, make sure you populate your database with the included scripts.
Download, install and configure Apache Derby
...
| Tip | ||
|---|---|---|
| ||
You will also need to run any database upgrade scripts via this same method above. Note that there are TWO SQL scripts that are required for a first time installation, you can either run the creation script then the upgrade script, or the combined script to do it in one go. |
Add the Derby DB driver to Tomcat:
...