Database | Driver | Notes |
|---|
| MySQL 5.5.x | MySQL Connector/J 5.1.13+ |  Sakai requires transaction support. In the case of MySQL you must implement the InnoDB storage engine to ensure proper transaction handling. |
MySQL 5.1.x | MySQL Connector/J 5.1.13+ | Sakai requires transaction support. In the case of MySQL you must implement the InnoDB storage engine to ensure proper transaction handling. |
Oracle 11g | OJDBC |  Oracle recommends using the latest 11g driver if you are using Java 6 with either 10g or 11g; with Java 6 in combination with the 11g driver, it's recommended that you use kernel-1.2.1+ (2.8), kernel-1.1.11+ (2.7) or kernel-1.0.x (r87324+) in order to include the fix for KNL-637.
 Recommend but not required - convert longs to clobs -
| Jira Legacy |
|---|
| server | System JIRA |
|---|
| serverId | 97e0cfea-fe72-310f-a179-8363adfc350a |
|---|
| key | SAK-7977 |
|---|
|
Only tested on Oracle 11.2.0.3 - https://github.com/daveadams/sakai-tools/blob/master/convert-longs-to-lobs.sql . By default it will scan your tables for LONG and LONG RAW fields but it won't change anything. Add "CONVERT" to the command line to actually perform the conversion and rebuild the indexes in the involved tables. Please be sure you understand what the script will be doing before you run it, and always always test thoroughly on a non-production environment before you attempt to run this on your production system. |
Oracle 10g | OJDBC | Both Oracle 10g AND 9i users must use the 10g driver; the latest 10g "Release 2" (10.2.x) or higher is recommended.
Oracle recommends using the latest 11g driver if you are using Java 6 with either 10g or 11g; with Java 6 in combination with the 11g driver, it's recommended that you use kernel-1.2.1+ (2.8), kernel-1.1.11+ (2.7) or kernel-1.0.x (r87324+) in order to include the fix for KNL-637. |
DB2 | | Deprecated |