Installing the database
In production environments, IBM® UrbanCode™ Release can be used with DB2®, Oracle, MySQL, or Microsoft™ SQL Server databases. By default, IBM UrbanCode Release uses the Apache Derby database. The bundled Derby database is for evaluation purposes.
IBM UrbanCode Release supports Oracle, Microsoft SQL Server, DB2, and MySQL relational databases. The provided Derby database, though sufficient for proof-of-concept work, is insufficient for the enterprise. Ideally, the database you use is configured for high-availability, high-performance, and is backed up regularly.
- Oracle RAC
- Microsoft SQL Server, clustered
- MySQL, cluster
- DB2 9.7 or later
When you install IBM UrbanCode Release, you are prompted to specify the database parameters. The database parameters are stored in the installed.properties file in the installation_directory/conf/server/ directory.
Because IBM UrbanCode Release is deployed as a Tomcat web application, the values in the installed.properties file are not used until IBM UrbanCode Release is deployed.
To change the database configuration, shut down the Tomcat application server by running the file server.shutdown on Linux™ or server.shutdown.bat on Windows. This file is in the server folder of the server installation directory. Then, edit the installed.properties file and restart Tomcat.