MySQL database
If you don't have one yet, download and install MySQL server.
Create a database and a user with all rights granted to this database:
$mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.60-enterprise-gpl-log MySQL Enterprise Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql:root:(none)> CREATE DATABASE IF NOT EXISTS petals;
Query OK, 1 row affected (0.02 sec)
mysql:root:(none)> GRANT ALL PRIVILEGES ON petals.* TO 'petals'@'%' IDENTIFIED BY 'petals';
Query OK, 0 row affected (0.04 sec)
mysql:root:(none)> quit
Bye
$
petals-view.properties file
Open this file (located in PetalsView-docs directory) and adapt informations to fit your database configuration (database name, users id and password, MySQL server address). Save the file.
MySQL jdbc-driver isn't into the classpath directory. You need to copy mysql-connector-java-5.1.x.jar into PetalsView/ WEB-INF/lib |
SE-KPI Component configuration
Open the jbi.xml file into the META_INF directory (open the petals-se-kpi-*.zip archive to find it).
Replace the line:
<petals-se-kpi:hibernateURL xmlns:petalsCDK="http://petals.ow2.org/components/extensions/version-5" xmlns:petals-se-kpi="http://petals.ow2.org/components/petals-se-kpi/version-1.0-SNAPSHOT" xmlns:jbi="http://java.sun.com/xml/ns/jbi" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:kpi-config="http://petals.ow2.org/components/petals-se-kpi/specific"/>
By another with the used properties:
<petals-se-kpi:hibernateURL xmlns:petalsCDK="http://petals.ow2.org/components/extensions/version-5" xmlns:petals-se-kpi="http://petals.ow2.org/components/petals-se-kpi/version-1.0-SNAPSHOT" xmlns:jbi="http://java.sun.com/xml/ns/jbi" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:kpi-config="http://petals.ow2.org/components/petals-se-kpi/specific">file:/home/user/Desktop/petals-view.properties</petals-se-kpi:hibernateURL>
MySQL jdbc-driver isn't into the classpath directory. You need to copy mysql-connector-java-5.1.x.jar into the se-kpi-*.zip archive (at the root path, with the others jars). You also need to add this new jar to the element list of the jbi.xml:
<path-element>mysql-connector-java-5.1.x.jar</path-element> |
Petals View configuration
Go to PetalsView-webapp/PetalsView.war/WEB-INF/spring
Open petals-view-annotation.xml
On the line <property >, in value quotation marks, fill in "petals-view.properties" file location.