Hi All,

I have a couple of questions. One of them is about OracleOCIConnection pool and I understand that this might not be the correct place to ask. But, I am posting it so that you can understand the fix I am in.

We have a web-app that uses spring framework and hibernate to connect to an Oracle 8i db. The connection to the db is authenticated through a generic username/password. So, at db, there is no way of knowing who is connecting to it. But, we know that at the app-layer: so we had user authentication through a security filter, but no logging of changes.

I also have to mention that as of now, the project is not into production and therefore we are not using any pooling, instead relying on Hibernate's default connection pooling.

It is the current requirement to have a logging mechanism to keep track of all the INSERT/UPDATE changes to the db. The db is also used by several other legacy systems and has a trigger functionality to do this. It uses the db connection's user-name and does the logging.

A proposed solution was to use a connection pooling that supports Proxy username/password to connect to the db. This would facilitate the logging process without the team having to spend a lot of time trying to code this kind of logging at the app.

My first question is:
Is it possible to use OracleOCIConnection pool with Hibernate? If it is, does the Spring's HibernateTemplate also support it?

My Second question is:
I am unsure about how to configure the OracleOCIConnection pool correctly to be used as in a standalone fashion. I am able to use the OracleConnection object to create proxy connections and connect to db, but unable to use the same through a pool. Does anyone know where to find good documentation/examples of this problem? Do I have to configure something else at the web-app server (JBoss or Tomcat)?

I might have come across as naive, but I did read through a lot of documentation and spent more than a week on this and am beginning to get a little frustrated. I believe that Hibernate is restricted to C3PO, proxool, etc and might not be applicable to OCIpool. Someone please correct me.

Any comment is greatly appreciated.

Regards,
Chandra.