This website uses cookies to ensure you get the best experience. Learn More.
Portal 6 with Derby DB
These are some quick steps how to use Derby DB with Portal 6.
(1) Prepare Portal Database
This shall be done only once.
+ modify derby/bin/ij.bat by adding:
set DERBY_OPTS="-Dderby.system.home=c:\liferay\bundles\data\derby"
+ start ij.bat and create the database:
connect 'jdbc:derby:lportal;create=true;user=liferay;password=liferay';quit;
+ create derby.properties in liferay/bundles/data/derby_opts . This file contains Derby DB settings and may looks like:
# when running embedded mode, also start the network server #derby.drda.startNetworkServer=true # Listen on all interfaces (allow connections from other IPs, not just localhost) #derby.drda.host=0.0.0.0 # Turn on authentication - a good move when running network server derby.connection.requireAuthentication=true # hard code a user/password for username liferay, change to use LDAP or RDBMS users etc... derby.user.liferay=liferay
(2) Integration with portal
+ Add derby.jar to liferay/bundles/tomcat-xxx/lib/ext
+ modify portal-ext.properties to set Derby DB connection:
jdbc.default.driverClassName=org.apache.derby.jdbc.EmbeddedDriver jdbc.default.url=jdbc:derby:lportal jdbc.default.username=liferay jdbc.default.password=liferay
+ add Tomcat VM parameter for Derby DB home:
-Dderby.system.home=c:\liferay\bundles\data\derby
When started, portal should print out something like this:
... Determining dialect for Apache Derby 10 ... Using dialect org.hibernate.dialect.DerbyDialect