Dialect in Hibernate

Hi,

I want to know the importance of dialect other than knowing the database.

dialect is meant for providing database details of which ur making use in ur application to hibernate. In this manner only, hibernate will decide about the SQL statements those have to be used specific to the database vendor and you can make use of HQL in your application.

This idea makes you to develop database vendor independent application.