title: Not specifying Hibernate dialect
body: <p>I am new to Hibernate. While reading Hibernate, I came across the <code>Dialect</code> property. Whatever database we will use in our application, we need to set dialect related to that database and Hibernate will generate appropriate query related to that database.  </p>
  
  <p>Just want to know if it is the mandatory property to be set? If it is not and not specified in the <strong>hibernate.cfg.xml</strong> file, then how will Hibernate generate the SQL queries i.e. which database compliant SQL query will be generated?</p>