Developing a new application that includes a database¶
Context¶
A large-scale application is being developed. This application uses a database
whose architecture plays a strategic role in the development that is underway.
Solution¶
- Model your database at conceptual or logical level using the modeling services provided by SQL Designer.
- Generate the SQL database script from the table model using the “Generator: SQL Script” command.
- Transform the table model into a data model using the “Transformation: Table Model to Data Model
” command”.
- Generate the persistent model’s Java classes and the associated Hibernate mapping files using the “Hibernate & Java Generation” command.
You have just produced your application’s Java data model, your database’s SQL script and the Hibernate mapping files used to ensure object / relational
mapping between the Java objects and the database.