Every close Connection pool call rollback

Every close Connection pool call rollback

Postby 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 http://forums.devart.com/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
BobreshovR
 
Posts: 1
Joined: Tue 03 Oct 2017 09:19

Re: Every close Connection pool call rollback

Postby 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.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle