Using different DataBases with Spring jdbcDaoSupport
<p>Which is the best approach to implement several different databases in one project, using Spring <code>JdbcDaoSupport</code>? </p>

<p>I have several DB with different datasources and syntax: <code>MySQL</code> &amp; <code>Postgres</code>, for example. In pure java-jdbc projects i used Factory Method and Abstract Factory patterns, and multiple DAOimpl classes (one for each DB) with common DAO interfaces for switch between databases. Now i use <code>Spring-jdbc</code> and want to implement similar behavior.</p>