How to configure IceScrum² with my own DataBase :

To install IceScrum² with your own database, you have to change some core configuration in a single file. Please ensure that the database you have created is set to use the UTF-8 encoding character. In MySQL, set the default character encoding for your database to utf8_general_ci. Moreover you will need the Java driver from your DataBase provider.

You have two ways for doing this, by using the Administrator account in IceScrum, or by manually editing the configuration file of IceScrum.

Note : Check if your database is supported on http://www.hibernate.org/80.html

1. With IceScrum Administrator account :

This simple tutorial will show you how to do it in 4 steps.

1. Download the Java driver in your [Tomcat-WebApps Root]/[icescrum2 Root]/WEB-INF/lib repertory. Let’s taking MySQL driver for example (note : MySQL driver is already included in the icescrum2 libs). On MySQL official website, you will search for MySQL Java Connector and you will find mysql-connector-java-5.x.x-bin.jar file. Put it in the said lib repertory and go step 2.
2. Log as an admin (default login: sa, pwd: sa). Use driverClassName provided by the Java Connector documentation. For MySQL this is : « org.gjt.mm.mysql.Driver ».
   Don’t forget to change your database URL which begins usually with jdbc:[name of your database provider in lower case]://[DB adress]/[databaseName which contains icescrum2 tables]. If you’re using MySQL, add the string ?useUnicode=true&characterEncoding=utf8 at the end to force the UTF-8 character encoding (required if you’re using non-latin-based characters).
   You can also define your database login and password here.
3. Change the database Dialect. In order to fully support your DB, you have to change the database dialect used : for mysql org.hibernate.dialect.MySQLInnoDBDialect
4. Validate the changes and restart the server.

2. Manually :

1. Download the Java driver in your [Tomcat-WebApps Root]/[icescrum2 Root]/WEB-INF/lib repertory. Let’s taking MySQL driver for example (note : MySQL driver is already included in the icescrum2 libs). On MySQL official website, you will search for MySQL Java Connector and you will find mysql-connector-java-5.x.x-bin.jar file. Put it in the said lib repertory and go to step 2.
2. Search for the file named « configuration.properties » located in
   • C:\Users\<your_user_name>\.icescrum\icescrum-web-R2 (on Windows Vista/7)
   • C:\Documents and Settings\<your_user_name>\.icescrum\icescrum-web-R2 (on Windows XP)
   • /home/<your_user_name>/.icescrum/icescrum-web-R2 (on Unix-based systems).
3. Open this file with a text editor and search for these lines :
database.driverClassName = org.hsqldb.jdbcDriver
database.url = jdbc:hsqldb:file:${user.home}/.icescrum/${contextRoot}/icescrum2_db.tmp;shutdown=true
database.dblogin = sa
database.dbpwd =
database.dialect = org.hibernate.dialect.HSQLDialect
4. Replace the database driverClassName by the one provided in the Java Connector documentation of your database management system. For MySQL this is : « org.gjt.mm.mysql.Driver ».
5. Replace the database URL to fit your own database. The syntax is generally jdbc:[name of your database provider in lower case]://[DB adress]/[databaseName which contains icescrum2 tables]
   . If you’re using MySQL, add the string ?useUnicode=true&characterEncoding=utf8 at the end to force the UTF-8 character encoding (required if you’re using non latin-based characters).
6. Define your database login and password.
7. Change the database Dialect. In order to fully support your DB, you have to change the database dialect used : for mysql it is org.hibernate.dialect.MySQLInnoDBDialect
   
8. Save the changes, and if IceScrum² was already running, restart the server.

An example with a MySQL DataBase Management System :