We are currently not using connection pooling in our applications, but are pushing the use of CMP EJB, and so, the use of connection pooling as well.
The Oracle DBA is reluctant to use such a means because of the consequences of connection pooling if the Oracle database is not aware of the real userid behind a connection.
They would like us to investigate further in finding a solution whereby web technology is combined with keeping the knowledge of the end-user, at Oracle level, for example.
I am aware that using connection pooling is always depriving the Oracle DBA from specific auditing information about the real user logged in the database, but I am trying to find a solution that suits both DBA and the development team.
Is there another way to use CMP without connection pooling ? For example, by using a self made connector as a datasource ?
Thanks in advance,
Val�ry