Discussions

EJB design: DAo - Connection Pooling

Bookmark and Share Get thread feed

  1. DAo - Connection Pooling (3 messages)

    • Posted by: aakash bhatt
    • Posted on: November 11 2003 05:51 EST
    If the connection code is written in DAO. How will the app server do the connection pooling
    Reply to this

    Threaded Messages (3)

  2. Reply to Message in Discussion / EJB Design[ Go to top ]

    In DAO we just fetch the connection. App. Server is responsible for creating & closing the connections etc.,
    Reply to this Reply to original

  3. DAo - Connection Pooling[ Go to top ]

    The connection pool is managed through the DataSource, not through the EJB class. So long as you retrieve the connection from the DataSource, pooling will work, whether you are calling the DataSource from your EJB class or from another class (such as a DAO).
    Reply to this Reply to original

  4. DAO, DataSource[ Go to top ]

    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/
    Reply to this Reply to original