OracleConnectionCacheImpl problems
Hi,
I've detected some problems when using the OracleConnectionCacheImpl.
First, I'm using a FIXED_WAIT_SCHEME and the Cache timeout parameters don�t seem to work. The CacheInactivityTimeout work but doesn't�t respect the time specified by me.
The CacheTimeToLiveTimeout doesn�t work at all. I use an UPDATE to lock a table and maintain the connection alive, the time expired and the connection doesn�t close until I released the table. Meanwhile all the inactive connection that expired during this experience doesn�t die until I released the lock on the earlier table. Someone can help me on this.
When a connection was closed during an (UPDATE, INSERT) with autoCommit(false) the operation was committed. Why this happens? How could I change the connection parameters to in case of this happens rollbacks the session.
Thanks,