sqldialect problem in hibernate

got a sqldialect problem in hibernate ... it may be due to the unmatch in the sqldialect provided in the configuration in the xml(if you are configuring thru hibernate.cfg.xml) or in the properties (hibernate.properties) file with the database u r using ... say if u r using mysql and the dialect is for MS SQL or Oracle u cant expect it to work. sounds incrediblely foolish mistake isnt it ... ? but then that is the reason it is so difficult to point out.