THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
To create the data base model, we will use hibernate maven plugin and hibernate.cfg.xml file. This file who will instruct the plugin The plugin will use the following configuration file to generate the SQL script and create table T_Incident.
Remark : MySQL has been used for the purpose of the tutorial
Here is the content of the hibernate.cfg.xml ( that you must create in the folder src/config of hibernate.db
...
Code Block |
---|
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.apache.camel.example</groupId> <artifactId>reportincident.db</artifactId> <packaging>jar</packaging> <name>Report Incident DB </name> <version>1.0-SNAPSHOT</version> <dependencies> <dependency> <groupId>org.apache.camel.example</groupId> <artifactId>reportincident.model</artifactId> <version>1.0-SNAPSHOT</version> </dependency> </dependencies> <build> <plugins> <!-- Hibernate plugin --> <plugin> <groupId>org.codehaus.mojo</groupId> <artifactId>hibernate3-maven-plugin</artifactId> <version>2.2</version> <configuration> <components> <component> <name>hbm2ddl</name> </component> </components> <componentProperties> <drop>true</drop> <create>true</create> <format>true</format> <configurationfile>/src/config/hibernate.cfg.xml</configurationfile> <outputfilename>db_reportincident_create_hsqldb.sql</outputfilename> </componentProperties> </configuration> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.6</version> </dependency> </dependencies> <executions> <execution> <phase>process-classes</phase> <goals> <goal>hbm2ddl</goal> </goals> </execution> </executions> </plugin> </plugins> </build> </project> |
Remarks :
- dependency Dependency with reportincident.model project must be added because the plugin requires the file Incident.hbm.xml to generate the script/db
- if If you prefer to use another DB instead of MySql, change the dependency in the pom.xml , and hibernate.connection.driver_class and hibernate.connection.url in the cfg file
...