Add ORA-03114 support

qgis · Jul 2, 2019 · 6287fd6 · 6287fd6
1 parent 0acc7f3
commit 6287fd6
Showing 1 changed file with 5 additions and 3 deletions.
diff --git a/src/providers/oracle/qgsoraclefeatureiterator.cpp b/src/providers/oracle/qgsoraclefeatureiterator.cpp
@@ -534,10 +534,12 @@ bool QgsOracleFeatureIterator::execQuery( const QString &query, const QVariantLi
   {
     if ( retryCount != 0 )
     {
-      // If the connection has been closed
-      // Try again N times in case of timeout
+      // If the connection has been closed try again N times in case of timeout
       // ORA-12170: TNS:Connect timeout occurred
-      if ( mQry.lastError().number() == 12170 )
+      // Or if  there is a problem with the network connectivity try again N times
+      // ORA-03114: Not Connected to Oracle
+      if ( mQry.lastError().number() == 12170 ||
+           mQry.lastError().number() == 3114 )
       {
         // restart connection
         mConnection->reconnect();