Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-202

Preparing Statements outside Transaction

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Drivers
    • Security Level: All
    • Labels:
      None

      Description

      From the mailing list:

      I'm using DBAL 2.1 with Oracle and it appears that if I call prepare() for my SQL and cache the prepared statement for later, if I then start a new transaction and call execute() on the statement, it commits the transaction. Is this behavior intentional? If so, does that mean I have to prepare my statement anew for every transaction?

      Note that I'm seeing the aforementioned behavior with code as basic as the following:

      $stmt = $dbh->prepare("INSERT INTO test_table (id, description) VALUES
      (:my_id, :my_desc)");
      $dbh->beginTransaction();
      $stmt->execute(array(":my_id" => 1, ":my_desc" => "test"));
      $dbh->rollBack();
      

      After executing the above, a record has been committed to the db. If I had a more complex scenario involving a transaction with multiple statements where the entire transaction is inside a loop, this becomes problematic--I can't then prepare my statements outside the loop to improve performance.

      When I try the same thing using straight PDO, it works fine. Can anyone else confirm this behavior?

        Activity

        Benjamin Eberlei created issue -
        Benjamin Eberlei made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 2.2.3 [ 10210 ]
        Resolution Fixed [ 1 ]
        Benjamin Eberlei made changes -
        Workflow jira [ 13359 ] jira-feedback2 [ 17779 ]
        Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 17779 ] jira-feedback3 [ 20134 ]
        Guilherme Blanco made changes -
        Fix Version/s 2.2.3 [ 10210 ]

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Benjamin Eberlei
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: