Date of First Response: 2008-04-28 18:48:42
project_key: SOA

In GA and CP01 the management console DB (for DBs other than HSQLSB) is configured outside of the DB schema tool. Can we extend the DB schema tool to and remove the task described in the getting started guide:


2.1.1.1. Monitoring/Management Console Configuration

By default, the monitoring/management console uses hsqldb as a back-end database. It has also been tested with Oracle and MySQL, but could be extended to use any other JDBC/hibernate-supported database.

In the management-esb directory there is a db.properties file. In order to change the database from hsqldb to mysql or oracle, edit this file and change the db property to mysql or oracle.

Next, change the /tools/management-esb/src/main/resources//management-ds.xml file so that the settings match the datasource for your database.

JBoss ships with hsqldb.jar in the server//lib directory. In order to use a different database as a back-end, please also the JDBC driver into the server//lib directory of your application server.

For MySQL, it may be necessary to create the database "statistics" before deploying if you have not edited the management-ds.xml file.

Please refer to tools/console/MANAGEMENT-README.txt for further information.