Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-13252

improve oracle connection closed detection

    XMLWordPrintable

    Details

      Description

      We should consider the following oracle error code as a connection closed condition

      • ORA-28 your session has been killed.
      • ORA-1033 Oracle initialization or shudown in progress.
      • ORA-1034 Oracle not available
      • ORA-1041 internal error. hostdef extension doesn't exist
      • ORA-1089 immediate shutdown in progress - no operations are permitted
      • ORA-1090 shutdown in progress - connection is not permitted
      • ORA-3113 end-of-file on communication channel
      • ORA-3114 not connected to ORACLE
      • ORA-12571 TNS:packet writer failure
      • ORA-17002 IO Exception
      • ORA-17008 Closed Connection
      • ORA-7410 No more data to read from socket
      • ORA-24768 commit protocol error occured in the server

      We may also have a better logging of XA exception by printing in any case the

      • oracle XA error code and message
      • oracle error
      • oracle SQL error

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: