# sakai.properties - the demo edition

# set the shared datasource URL to use a file based HSQLDB
url@javax.sql.BaseDataSource=jdbc:hsqldb:file:${sakai.home}db/sakai.db;hsqldb.default_table_type=cached

# the file system root for content hosting's external stored files (default is null, i.e. store them in the db)
# see the readme file (2.2.7 File Based Content Hosting) for more details
bodyPath@org.sakaiproject.content.api.ContentHostingService = ${sakai.home}db/bodyContent/

# when storing content hosting's body bits in files, an optional set of folders just within the bodyPath -
# to act as volumes to distribute the files among - a comma separate list of folders.  If left out, no volumes will be used.
# see the readme file (2.2.7 File Based Content Hosting) for more details
bodyVolumes@org.sakaiproject.content.api.ContentHostingService = vol1

# set to false to disable the release/retract and hiding of resources in ContentHostingService
# if this setting is left out of sakai.properties, the availability features should be enabled
# by default
availabilityChecksEnabled@org.sakaiproject.content.api.ContentHostingService = true

# set to false to disable custom sorts within folders in ContentHostingService 
# if this setting is left out of sakai.properties, the priority sorts should be 
# enabled by default
prioritySortEnabled@org.sakaiproject.content.api.ContentHostingService = true

###################################################################################################
#
# examples of other driver class name values - HSQLDB is the default
#driverClassName@javax.sql.BaseDataSource=org.hsqldb.jdbcDriver
#driverClassName@javax.sql.BaseDataSource=com.mysql.jdbc.Driver
#driverClassName@javax.sql.BaseDataSource=oracle.jdbc.driver.OracleDriver
#
###################################################################################################
#
# examples of other datasource URLs for other technologies: HSQLDB in-memory is the default, and above see how to put this in a file
#url@javax.sql.BaseDataSource=jdbc:hsqldb:.
#url@javax.sql.BaseDataSource=jdbc:mysql://localhost:3306/sakai?useUnicode=true&characterEncoding=UTF-8
#url@javax.sql.BaseDataSource=jdbc:oracle:thin:@monster.oracle.org:1521:db
#
###################################################################################################
#
# example vendor settings - must match your hibernate dialect set in the "placeholder.properties" file - "hsqldb" is the default
#vendor@org.sakaiproject.db.api.SqlService=hsqldb
#vendor@org.sakaiproject.db.api.SqlService=mysql
#vendor@org.sakaiproject.db.api.SqlService=oracle
#
###################################################################################################
#
# set the validation query - the default is for hsqldb "select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"
# for MySQL and Oracle, change it to this:
#validationQuery@javax.sql.BaseDataSource=select 1 from INFORMATION_SCHEMA.SYSTEM_USERS
#
# Note: This has been shown to cause performance problems in Oracle - to leave it unset, set it to:
#validationQuery@javax.sql.BaseDataSource=
#
###################################################################################################
#
# set the default transaction isolation level - Up to and including 1.7.1, HSQLDB supports only "TRANSACTION_READ_UNCOMMITTED" - this is the default
# MySQL and Oracle should be set to TRANSACTION_READ_COMMITTED.
#defaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_UNCOMMITTED
#defaultTransactionIsolationString@javax.sql.BaseDataSource=TRANSACTION_READ_COMMITTED
#
# Note: TRANSACTION_READ_COMMITTED is the default for Oracle, and performance problems have been seen when attempting to set this default.
# To leave it unset, set it to:
#defaultTransactionIsolationString@javax.sql.BaseDataSource=
#
###################################################################################################
#
# Examples of interesting values to set.  This is not an inclusive list, since every property can be overridden in the property files
#
# set the default skin
#skin.default=default
#
# set the path to the skin repository
#skin.repo=/library/skin
#
# maximum allowed user file upload - in megabytes.  Default is 1 (megabyte).
#content.upload.max=20
#
###################################################################################################
#
# set the hibernate dialect (for shared datasource), HSQLDB by default, mySql and Oracle examples
#hibernate.dialect=org.hibernate.dialect.HSQLDialect
#hibernate.dialect=org.hibernate.dialect.MySQLDialect
#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
#
###################################################################################################
#
# set the auto.ddl - default value is "true"
#auto.ddl=true
#auto.ddl=false
#
###################################################################################################

# Supported language locales for user preferences
locales = en, ja_JP, ko_KR, nl_NL, zh_CN, es_ES, fr_CA, ca_ES, sv_SE
