Stateless Session Beans and Database connection Pooling

[thomas jacob]

Hi All,
I am using EJB3.1 I want to write a Stateless Session Bean which connects to the Oracle Database and reads the database metadata. The session beans basically will have two business methods. First method to return list of Tables in a database schema and second method to return list of columns of a particular table. I will expose a local business interface that will be used by the JSF managed beans

I want to use database connection pooling for connection purpose from stateless session bean. Is there any example available to achieve this.

Thanks

[Paul Sturrock]

There is an FAQ entry about connection pools. It shows an example from a servlet, but the logic is much the same.