This will reduce the effort utilized in drawing ER diagrams, normalization (conceptual design) as well as physically writing SQL coding to complete the physical design inside the RDBMS.
Hibernate will prevent getting your java code dirty via writing SQL within it. If you use hibernate, no sql within your java application at all.
Also hibernate provides:-
• Caching of frequently used data record. Its several times efficient than retrieving from the database.
• Needn’t opening and closing database connections. This will prevent memory leakage problems
• Allow the java application to work with multiple DBMSes.
• Small change in the java code will alter the table in the DB. Needn’t dropping the table.
• 80% of code reduction in the application program
When the required operation was initiated from the application, hibernate is versatile enough to auto generate the required SQL coding
Go to this site called www.hibernate.org/downloads
After going into the site .. notice some changes
Look at the release bundles .. under the release bundle , download the latest version
Add those into the library.. all those jar files to the library
And then add a xml file and name as hibernate.cfg
And then go to project file and search for a file in the name of hibernate.cfg.xml
And from that get the one with the highest capacity, and then paste it in the xml file
Then change the local host thingy user name and password and all
Go to library and add hibernate jar file
Then go into hibernate3.jar and in that go to org.hibernate.dialect and in that go get mysqldialect
And paste that name and path thingy in the dialect part
And then make the sql