Database support (2.x)

Sakai supports the following production-grade databases:

Sakai	Database	Driver	Notes
2.8, 2.7	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.
2.8. 2.7, 2.6, 2.5	MySQL 5.0.x	MySQL Connector/J 5.0.4+	Sakai requires transaction support. In the case of MySQL you must implement the `InnoDB` storage engine to ensure proper transaction handling.
2.6, 2.5	MySQL 4.1.12+	MySQL Connector/J 3.1.12+	Sakai requires transaction support. In the case of MySQL you must implement the `InnoDB` storage engine to ensure proper transaction handling. Connection issues have been reported for both Connector/J 3.1.10 & 3.1.11 drivers. Choose version 3.1.12+.
2.8, 2.7, 2.6, 2.5	Oracle 10g/Oracle 9i	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 the 11g driver, it's recommended that you have a recent kernel with the KNL-637 patch under high load.
2.7	DB2

Choose the appropriate MySQL or Oracle JDBC driver (or connector) for your installation. For MySQL, download the *zip/*tar.gz archive, extract its contents and copy the mysql-connector-java-<version>-bin.jar to $CATALINA_HOME/common/lib. For Oracle download the ojdbc14.jar file and copy it to $CATALINA_HOME/common/lib.

Note that you will not need to create Sakai database objects (tables, indices, etc) when setting up your database. Sakai generates its own database schema automatically during the Tomcat setup process via the autoDDL setting in sakai.properties.

Sakai requires transaction support. In the case of MySQL you must implement the InnoDB storage engine to ensure proper transaction handling.