Configuring Liberty Profile for Derby manually
IBM Worklight V5.0.5. automatically configures your databases. However, if you are using an older version of IBM Worklight, or if you are experiencing problems with the automatic configuration process for Liberty Profile on Derby, you must manually set up and configure your Apache Derby database and then the Liberty Profile for Derby. Complete the Apache Derby database setup procedure before continuing.
Configure the data source in the LIBERTY_HOME/usr/servers/defaultServer/server.xml file as follows:
<variable name="DERBY_JDBC_DRIVER_PATH" value="C:/Drivers/derby" /> <library id="derbyLib"> <fileset dir="${DERBY_JDBC_DRIVER_PATH}" includes="derby.jar" /> </library> <dataSource id="DefaultDerbyDatasource" jndiName="jdbc/DefaultDerbyDatasource" statementCacheSize="10"> <jdbcDriver libraryRef="derbyLib" javax.sql.ConnectionPoolDataSource="org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource"/> <properties.derby.embedded databaseName="path_to_db/WorklightDB" shutdownDatabase="false" connectionAttributes="upgrade=true" /> <properties.derby.embedded databaseName="<path_to_db>/WorklightReportsDB" shutdownDatabase="false" connectionAttributes="upgrade=true" /> <connectionManager connectionTimeout="180" maxPoolSize="10" minPoolSize="1" reapTime="180" maxIdleTime="1800" agedTimeout="7200" purgePolicy="EntirePool" /> </dataSource>
Parent topic Troubleshooting