Hi

I have one doubt.
"Dialect" is tells to hibernate which database we are using.
The same job is done by particular database Driver.
Example:

org.hibernate.dialect.MySQLDialect: it means we are using mysql database.
com.mysql.jdbc.Driver:This driver telling same.

Why we are using Dialect and Driver.

Please any body answer this question.

regards
Srinivas.d

No. Dialect tells Hibernate which dialect to use while driver names the driver. Driver is needed for the JDBC-connection - sometimes there is more than one driver for a database product. Dialect is used to tell Hibernate about some specific SQL. What if there is a new function in a new version our your database but you can use the same driver?

The dialect in hibernate refers to the SQL customizations or syntax that each particular database has to perform an operation, you
can also think as a set of grammar and syntax that it's used by hibernate to generate a valid SQL sentence for the db associated with
that dialect. Hibernate have one dialect for each mayor database vendor. Another distinction it's that the driver it's made by the vendor while the dialect it's made
by the hibernate team.

Regards

all true, additionally you don't need to define the Dialect as it defaults to an appropriate one depending on the driver ;-)
Still it might be useful to declare the Dialect you want to override/fix the automagical selection.