Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OracleConnectionCacheImpl problems

406338Oct 13 2003
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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2003
Added on Oct 13 2003
0 comments
288 views