SQL-less Database Programming
Retrieve data without writing SQLs. Minimum work to use Hibernate by generating an executable to just plug and use.
Java object persistence with Hibernate
Supported specifying annotation for collection in ORM
ORM generates custom annotation specified in class attribute. Now, it supports specifying annotation for collection (association). This feature supports generating annotation for collection by defining it in association role's "Referenced Attribute" property.
Supported Hibernate 4
Enhanced criteria for subqueries, collection property size restriction, collection/association fetch mode, association property restriction on foreign key column.
Supported GregorianCalendar in ORM
Supported the use of java.util.GregorianCalendar in generated ORM
Supported relative output path for ORM code generation
Enables the use of relative path in specifying the output destination of generated ORM code, which is particularly useful for software teams that have multiple people work on ORM and each of them have their own folder for storing ORM -related files.
Visual Paradigm for UML supports generating both database schema (DDL) and Java ORM code for accessing databases. There are various options to configure the generated code and databases. The following screenshots outline the steps involved.
Java object persistence with Hibernate
Step 1 of 7: Get ready for object and data model
Model the system with class diagram (with ORM Persistable classes) and produce the entity relationship diagram (ERD) through synchronization, or the other way round. Make sure the object model is synchronized with the data model.
Step 2 of 7: To generate code and database
Select Tools > Object-Relational Mapping (ORM) > Generate Code... from the main menu to generate ORM Java code.
Step 3 of 7: Specify output destination
Specify the file path of the code, libraries, and DDL to be generated. If you use an IDE, simply set the path to the Java project path.
Step 4 of 7: Configure database
Select Database tab. After that, select Export to database, and configure the target database. After all, click OK to start generating code and database.
Step 5 of 7: Setup development environment
In the IDE, refresh the project node to gain access to the generated files, and add the lib\orm.jar to project build path.
Step 6 of 7: Develop application
Develop the application through the use of the ORM classes. You may learn the usage of generated files by reading the sample files generated to the ormsamples folder.
Step 7 of 7: Execute the code
Run the code, enjoy!
- Generating code and database
- Using Hibernate in Enterprise Scale Project (Paid)
PHP object persistence with Doctrine
Generate executable PHP Doctrine object relational mapping (ORM) layer from standard UML class diagram and entity relationship diagram.
- ORM with PHP Doctrine
Hibernate code generation from existing database
Visual Paradigm for UML supports generating Java ORM code for accessing relational database. The following movie demonstrates how to reverse existing database to ERD, synchronize ERD to UML class diagram, and generate Java ORM code to access database.
Synchronize between ERD and UML class diagram
By usage, entity relationship diagrams (ERD) presents persistent structure of database and class diagrams presents object structure in memory. There is an alignment between ERD and class diagram - Database column in entity can map to attribute in class. Visual Paradigm for UML supports generating class diagram from ERD and synchronizing changes between them, and vice versa.
Configurable ORM code
Visual Paradigm for UML generates Java ORM code for accessing the database. The ORM code is highly configurable. You may control the type of mapping, the persistent API such as Factory, DAO, POJO, and the way to handle association. The following screenshot shows the configuration of ORM code.
- Using Criteria in Hibernate (Paid)