We are building an application which uses a legacy database schema on Oracle. Security is managed in database by using USER function of oracle sql, so in order to get records, update or delete record we need that the user is connected from his original username/password and also every operation should be performed on a connection with original user name and password. To achieve this and connection pooling we are using OCIConnectionPool implementation and Oracle Proxy connections.
The problem is that we have made our own datasource so it did not enlist itself with ongoing jta transaction. So please tell us the way to enlist with it with ongoing jta transaction.