Dao - connection pool

[aakash bhatt]

If the connection code is written in DAO. How will the app server do the connection pooling

[Lasse Koskela]

It depends on how the DAO is implemented. The pattern itself doesn't mandate any particular approach to getting JDBC connections -- or even using one in the first place.

[Sean Sullivan]

If you want to take advantage of the connection pooling provided by the application server, you will need to:

1) lookup the javax.sql.DataSource object via JNDI
2) invoke DataSource.getConnection()
Example code:
http://daoexamples.sourceforge.net/
Article:
http://www-106.ibm.com/developerworks/java/library/j-dao/