Retrieve data without writing SQLs. Minimum work to use Hibernate by generating an executable to just plug and use.
Writing SQL statements is not easy, not to mention writing SQL statements that work across different databases. Visual Paradigm suggests to develop database application in an entirely object oriented approach. With the persistable objects and Hibernate generated from class diagram/ERD, you can develop application that accesses database without writing a single line of SQL.
Just draw a class diagram (or ERD) for the database tables and generate the required Hibernate code for accessing database(s). After that, start programming in your IDE, with the use of generated code. You don't need to learn SQL. You don't even need to know anything about database!
Generate class diagram from ERD and synchronizing changes between them, and vice versa.
Object-relational mapping diagram (ORM diagram) presents the mapping between classes and entities visually.
Generate Hibernate ORM code from an existing database.
Allow specifying how mapping information is to be stored.
Allow specifying how error is being handled when occur.
Allow specifying how exception is being handled when occur.
Reduce database loading. Avoid objects from being loaded when the main object is loaded with the 'lazy' option.
Allow specifying the behavior of update when updating a bi-directional association.
Allow specifying the way objects can be retrieved with generated code.
Improve performance by configuring second level cache.
Include optional libraries and JDBC drivers in generated orm.jar.
Generate sample files that teaches you how to work with the generated code.
Generate servlet sample to learn web application development with generated code.
Generate Java Server Page (JSP) sample.
Generate the file web.xml essential in Web application development
Automatically form the ORM persistence model from generated Hibernate mapping files.
Automatically form the ORM persistence model from generated ORM classes.
Command line support to schedule an ORM code generation task to perform on a regular basis, say, on every evening.