Sakai Database Property Settings

Owned by Former user (Deleted)
Last updated: Oct 05, 2005Version comment
1 min read

Sakai database property settings are stored in sakai.properties and placeholder.properties. Both files are located by default in tomcat/sakai.

Every sakai.properties MUST HAVE these settings: 

# sakai.properties

## Placeholder properties : the complete set must be defined here 

# set the hibernate dialect (for shared datasource) 
hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect 

#set the auto DDL feature 
auto.ddl=true

This is due to a "bug" in Spring's placeholder system that we will address later.

Then you need some more stuff:

  1. set the hibernate dialect (for shared datasource), HSQLDB by default, mySql and Oracle examples
  2. NOTE: this is required, and must be in any sakai.properties file
    hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect
    #hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
    #hibernate.dialect=net.sf.hibernate.dialect.Oracle9Dialect
  1. set the shared datasource driver, HSQLDB by default, mySql and Oracle examples
    driverClassName@javax.sql.DataSource=org.hsqldb.jdbcDriver
    #driverClassName@javax.sql.DataSource=com.mysql.jdbc.Driver
    #driverClassName@javax.sql.DataSource=oracle.jdbc.driver.OracleDriver
  1. set the shared datasource URL, HSQLDB in-memory by default, mySql and Oracle examples
    url@javax.sql.DataSource=jdbc:hsqldb:.
    #url@javax.sql.DataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8
    #url@javax.sql.DataSource=jdbc:oracle:thin:@monster.oracle.org:1521:db
  1. set the vendor for legacy sql access
    vendor@org.sakaiproject.service.framework.sql.SqlService=hsqldb
    #vendor@org.sakaiproject.service.framework.sql.SqlService=mysql
    #vendor@org.sakaiproject.service.framework.sql.SqlService=oracle

And:

username@javax.sql.DataSource=
password@javax.sql.DataSource=

MySQL (sakai.properties)

auto.ddl=true 
hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect 
vendor@org.sakaiproject.service.framework.sql.SqlService=mysql 
driverClassName@javax.sql.DataSource=com.mysql.jdbc.Driver 
url@javax.sql.DataSource=jdbc:mysql://127.0.0.1:3306/sakai?useUnicode=true&characterEncoding=UTF-8 
username@javax.sql.DataSource=sakai 
password@javax.sql.DataSource=rocks

Oracle (sakai.properties)

auto.ddl=true 
hibernate.dialect=net.sf.hibernate.dialect.Oracle9Dialect 
vendor@org.sakaiproject.service.framework.sql.SqlService=oracle 
driverClassName@javax.sql.DataSource=oracle.jdbc.driver.OracleDriver 
url@javax.sql.DataSource=jdbc:oracle:thin:@monster.oracle.org:1521:db 
username@javax.sql.DataSource=sakai 
password@javax.sql.DataSource=rocks