Database: Hibernate

by | Mar 14, 2017 | Database Research

Goals:

The goals are to:

  1. Design and develop a command line application to demonstrate interactivity with a database using Hibernate
  2. Be able to retrieve an object using Hibernate
  3. Be able to retrieve related objects (one-to-many collection mapping)
  4. Be able to insert records with Hibernate
  5. Be able to update records with Hibernate
  6. Be able to delete records with Hibernate
Technologies, Tools, and Resources used:
  • Java 1.7
  • Oracle SQL Developer 3.1
  • Cisco VPN Client (to connect to Swinburne VPN for DB access)
  • NetBeans IDE 7.2
  • Hibernate 4.1.7
Tasks undertaken:
  • Ensure all technologies/tools utilised in Spike 3 are installed
  • Installation of NetBeans IDE to code Java command line application in
  • Ensure database connectivity
  • Creation and Testing of Hibernate XML configuration file
  • Creation and Testing of Hibernate Execution Class
  • Creation and Testing of Cinema & Classification Classes
  • Ensure data is being altered correctly through the use of SQL Developer
What we found out:

Hibernate is an extremely useful ORM tool to provide assistance at the business layer of data use. It saves wasted hours attempted on manually developing SQL code to insert objects into a Database, by auto generating code according to the way Hibernate is configured.

By using a configuration file, Hibernate automatically generates tables and configures all attributes for the table according to the values that are inserted into the database.

Hibernate truly shows how effective it can really be toward Object-Relational Mapping, when it needs to deal large quantities of data that need to be inserted into a database, as it can easily accommodate for the slight differences in data types when inserting into a database, as opposed to having to manually alter an SQL insert query and parse data before it is in the correct format to be inserted into a database.

In the case of the Cinema Ticketing System, Hibernate allows easy management of mapping Movies to Categories & Classifications, and more importantly, the linking of a Transaction to all other connecting tables to provide specific information regarding the sale of a movie ticket.

 

 

Open issues/risks
  • Incorrect configuration of Hibernate will result in errors when dealing with data that you wish to manage in a specific way.
  • Hibernate is slower than just using JDBC as Hibernate is constantly generating SQL queries in the background.
Recommendations
  • Great to use for applications that manages a vast amount of data that is constantly being Inserted, Updated or Deleted.

- Mark Fulton