how to use two databases with one web application

[scropio80]

Hi

I am using spring framework with hibernate. I have to use two databases with a single web application. I m not getting any idea how can I do this.......can any one help me

[Bron]

Create multiple datasource beans.

Any controller or DAO that extends JdbcDaoSupport can only use one connection through its JdbcTemplate (retrieved via getJdbcTemplate()), but you can define your extra instances of JdbcTemplate that use whatever datasource you want. You can then inject those JdbcTemplates into any beans you wish to.

[scropio80]

hey thanx...........it worked