Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-18272

Transactions in sql Oracle driver are not working

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • P3: Somewhat important
    • None
    • 4.7.1, 4.7.2, 5.4.2
    • SQL Support
    • None
    • linux Ubuntu 10.10

    Description

      The Oracle SQL driver is not working correctly, executing the attached test, all tuples after the rollback remain on the table, the patch is the following for qsql_oci.cpp :

      < const bool *transaction;

      > bool transaction;
      1534c1534
      < *d->transaction ? OCI_DEFAULT : OCI_COMMIT_ON_SUCCESS);

      > d->transaction ? OCI_DEFAULT : OCI_COMMIT_ON_SUCCESS);
      1770c1770
      < sql(0), transaction(&driver->transaction), serverVersion(driver->serverVersion),

      > sql(0), transaction(driver->transaction), serverVersion(driver->serverVersion),
      1970c1970
      < mode = *d->transaction ? OCI_DEFAULT : OCI_COMMIT_ON_SUCCESS;

      > mode = d->transaction ? OCI_DEFAULT : OCI_COMMIT_ON_SUCCESS;

      Attachments

        1. TestProgram1.tgz
          3 kB
          Manuel Soriano
        2. TestProgram.tgz
          3 kB
          Manuel Soriano

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              Unassigned Unassigned
              manu007 Manuel Soriano
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes