title: Does Spring embedded database support different SQL dialects?
body: <p>H2 has a range of <a href="http://www.h2database.com/html/features.html#feature_list" rel="noreferrer">compatibility modes</a> for various other databases such as MS SQL Server, MySQL, Oracle, etc that support different SQL dialects. However, when setting up an <a href="http://static.springsource.org/spring/docs/3.1.x/spring-framework-reference/html/jdbc.html#jdbc-embedded-database-support" rel="noreferrer">embedded database</a> in Spring I do not find any corresponding setting. Does this imply that I have to use "plain" SQL without any dialect specific features if I for example use Oracle in production and H2 during test? Have I overlooked something? </p>