cx_oracle + two phase
Issue #2611
resolved
apparently two phase "works", but we aren't doing it right, as prepare() returns a boolean which we need to honor. the attached patch begins to address this, however we'd need to test fully to see what we do with subsequent transactions, rollbacks, etc.
Comments (4)
-
reporter -
reporter see also
#736for related notes. -
reporter - changed status to resolved
well I put out the request for help which can be seen at: http://sourceforge.net/mailarchive/forum.php?thread_name=377D4733-B804-4EEB-B638-55A8EB5EF0ED%40zzzcomputing.com&forum_name=cx-oracle-users . I'm not optimistic about a response so the changesets here include detail on the issue and how to work around it.
af1a545bdd9d5210981a07f74e62f5d343b14537 (0.8) 0b0415f49b25a0ceba67898af49d4c0dda695b80 (0.7)
-
reporter - removed milestone
Removing milestone: 0.8.0final (automated comment)
- Log in to comment
we will put this patch in, but for now we may need special tests that are specific to test_oracle, as the generic "two phase tranasction" tests aren't working with cx_oracle. The attached test suite illustrates cx_oracle's failing to return the connection to a standard DBAPI usage pattern after a two phase.