Time for action – changing the file
So first create a property file called portal-ext.properties, within the LIFERAY_HOME directory and add the following properties into it:
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/neighbourhood_portal?useUnicode=true&characterEncoding=UTF8&useFastDateParsing=false
jdbc.default.username={your_username}
jdbc.default.password={your_password}
Replace {your_username} and {your_password} with your actual credentials for MySQL.
Note
Downloading the example code for this book
You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.
What just happened?
Restart your server and Liferay will now be using MySQL instead of Hypersonic database.
For Oracle WebLogic, place the portal-ext.properties in WEBLOGIC_HOME\user_projects\domains. Besides that you also need to copy mysql.jar in the DOMAINS_HOME\Liferay\lib along with the other dependencies. Restart the server and you should be able to see that now Liferay is using MySQL.