Default data population

Now you can start the portal. As you have noticed, the default database, Hypersonic, and the default data are in use. As shown in the following settings, Liferay is configured to use Hypersonic as its database. Do not use Hypersonic in production. Hypersonic is an embedded database useful only for development and demo purposes. The default database settings are defined in portal.properties, which can be overridden by creating portal-ext.properties.

# Hypersonic
jdbc.default.driverClassName=org.hsqldb.jdbcDriver
jdbc.default.url=jdbc:hsqldb:${liferay.home}/data/hsql/lportal
jdbc.default.username=sa
jdbc.default.password=password

As shown in the preceding code, the default data is stored at $LIFERAY_PORTAL/data/hsql/lportal.script. Moreover, the portal provides a dialect detector in com.liferay.portal.spring.hibernate.DialectDetector. This dialect detector will check dialects such as HSQL (Hypersonic), ASE (SybaseASE15Dialect), DB2 (DB2Dialect), Microsoft (SQLServer2008Dialect...