Every close Connection pool call rollback

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
BobreshovR
Posts: 1
Joined: Tue 03 Oct 2017 09:19

Every close Connection pool call rollback

Post by BobreshovR » Tue 03 Oct 2017 09:28

Hi!
We created statistics from our oracleDB http://www.dba-oracle.com/m_user_rollbacks.htm.
And DevArt oracle provider create 75% rollback.
dbMonitor show that every close connection pool call rollback.
We found this topic about it viewtopic.php?f=1&t=24015&hilit=rollback
And we can't disable pooling, because we have highload system.
How can we disable rollback after commits ans select query?

Thanks

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

Re: Every close Connection pool call rollback

Post by Shalex » Wed 04 Oct 2017 16:47

At the moment there is no possibility to disable rolling back of all pending operations on a connection before returning the connection to pool. We will investigate the possibility of implementing this functionality, but we can't tell any timeframe at the moment. We will inform you when any results are available.

Post Reply