-
Type:
Bug
-
Status: Closed
-
Resolution: Won't Fix
-
Affects Version/s: 6.0.5 GA
-
Fix Version/s: 6.2.0 CE M3
-
Component/s: Documentation
-
Labels:None
The portal.properties JDBC settings for Derby does not use a valid URL for the database connection. Also, an additional file is needed when configuring Liferay with Derby. I have documented my process here:
http://www.liferay.com/group/liferayqa/wiki/-/wiki/AWESOME%20QA%20WIKI/How+to+install+Derby
If you cannot access that link:
How to install Derby
Databases: database derby
Summary#
This is the Derby Home Page.
Environment Used#
Derby 10.7.1.1
Windows XP, Windows Vista, Windows 7, Ubuntu 11.04
Items Needed#
Derby Installation file
Java JDK 1.4.2 or higher
Instructions#
Download the zip file from the link above.
Extract the contents at a preferred location. This will be referred to as the Derby Install Directory
Navigate to the bin folder
Execute ij.bat (or ij on a unix terminal) and enter the following
connect 'jdbc:derby:lportal;create=true;user=liferay;password=liferay';quit;
Execute startNetworkServer.bat (or startNetworkServer on a unix terminal)
Navigate to the lib folder of your Derby Install Directory
Copy the files derby.jar and derbyclient.jar
Paste the files in your liferay/lib/ext folder
Enter the following in the portal-ext.properties of your liferay environment and start up liferay:
jdbc.default.driverClassName=org.apache.derby.jdbc.EmbeddedDriver
jdbc.default.url=jdbc:derby://localhost:1527/lportal
jdbc.default.username=liferay
jdbc.default.password=liferay