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

can not start transaction ORACLE OCI, while having QSqlQuery open in QSqlQueryModel

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • P2: Important
    • 5.0.0
    • 4.7.2
    • SQL Support
    • None
    • Windows XP Prof SP3, Microsoft Developer Studio 2008
    • 85b624a969c2674f726b6e80af1418bdd9f91969

    Description

      If you have a model view with QSqlQueryModel and the query remains open (which is normal) you are not able to start a transaction to do something else.
      The databse will complain with ORA-01453: SET TRANSACTION must be first statement of transaction Unable to begin transaction.

      I believe that the bug for that is based in qsql_oci.cpp line 1967

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

      In my application it works fine.

      Attachments

        1. fachbelegung.cpp
          29 kB
        2. fachbelegung.h
          1 kB
        3. fachbelegung.ui
          7 kB
        4. fachbelegungquerymodel.h
          0.5 kB
        5. fachstatusquerymodel.cpp
          3 kB
        For Gerrit Dashboard: QTBUG-18608
        # Subject Branch Project Status CR V

        Activity

          People

            mabrand Mark Brand
            stefanlatsch Stefan Latsch
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes