Thread: [Sqlalchemy-tickets] [sqlalchemy] #822: Twophase Support for MSSQL
Brought to you by:
zzzeek
From: sqlalchemy <mi...@zz...> - 2007-10-19 14:09:50
|
IzgyMjogVHdvcGhhc2UgU3VwcG9ydCBmb3IgTVNTUUwNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBS ZXBvcnRlcjogIGd1ZXN0ICAgICAgICAgICAgICAgICAgIHwgICAgICAgICAgT3duZXI6ICByYW0g ICAgICAgICAgICAgICAgICAgDQogICAgIFR5cGU6ICBlbmhhbmNlbWVudCAgICAgICAgICAgICB8 ICAgICAgICAgU3RhdHVzOiAgbmV3ICAgICAgICAgICAgICAgICAgIA0KIFByaW9yaXR5OiAgbWVk aXVtICAgICAgICAgICAgICAgICAgfCAgICAgIE1pbGVzdG9uZTogICAgICAgICAgICAgICAgICAg ICAgICANCkNvbXBvbmVudDogIG1zc3FsICAgICAgICAgICAgICAgICAgIHwgICAgICAgU2V2ZXJp dHk6ICBubyB0cmlhZ2Ugc2VsZWN0ZWQgeWV0DQogS2V5d29yZHM6ICBtc3NxbCB0d29waGFzZSBw eW1zc3FsICB8ICAgU3RhdHVzX2ZpZWxkOiAgYXdhaXRpbmcgdHJpYWdlICAgICAgIA0KLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLQ0KIEknbSB1c2luZyBib3RoIGEgTXlTUUwgYW5kIGEgTVNTUUwgc2VydmVy IGZvciBhbiBhcHBsaWNhdGlvbiwgc28gSSBhZGRlZA0KIHRoZSBmb2xsb3dpbmcgY29kZSB0byB0 aGUgTVNTUUxEaWFsZWN0IHRvIGdldCB0d29waGFzZSBzdXBwb3J0Lg0KDQogQWRkaXRpb25hbGx5 LCBJIGNoYW5nZWQgdGhlIGRlZmF1bHQgZGlhbGVjdCdzIGNyZWF0ZV94aWQgbWV0aG9kLCB3aGlj aA0KIHJldHVybnMgYSB0cmFuc2FjdGlvbiBJRCwgdG8gcmVmZXJlbmNlIGFuZCB0cnVuY2F0ZSB0 bw0KIG1heF9pZGVudGlmaWVyX2xlbmd0aCAoaXQgd2FzIGZhaWxpbmcgZHVlIHRvIHRoaXMgd2l0 aCBweW1zc3FsKSBhbmQgIHRvDQogbm90IHVzZSBhbnkgdW5kZXJzY29yZXMgaW4gdGhlIG5hbWUg KHdoaWNoLCBJIGJlbGlldmUsIGZhaWxzIHdpdGggTVNTUUwgaW4NCiBnZW5lcmFsKS4NCg0KIEJv dGggcGF0Y2hlcyBhdHRhY2hlZCwgYWdhaW5zdCBjdXJyZW50IHRydW5rIChyMzY0MykuIFRoZXkg d29yayB3aXRoIGFuDQogYXBwbGljYXRpb24gSSBoYXZlIHJ1bm5pbmcgdXNpbmcgcHltc3NxbCwg YnV0IGFyZSB1bnRlc3RlZCB3aXRoIHB5b2JkYyBvcg0KIGFkb2RiYXBpIGFzIEkgZG9uJ3QgaGF2 ZSBlbnZpcm9ubWVudHMgZm9yIHRoZW0uDQoNCi0tIA0KVGlja2V0IFVSTDogPGh0dHA6Ly93d3cu c3FsYWxjaGVteS5vcmcvdHJhYy90aWNrZXQvODIyPg0Kc3FsYWxjaGVteSA8aHR0cDovL3d3dy5z cWxhbGNoZW15Lm9yZy8+DQpUaGUgRGF0YWJhc2UgVG9vbGtpdCBmb3IgUHl0aG9u |
From: sqlalchemy <mi...@zz...> - 2007-10-19 14:30:11
|
IzgyMjogVHdvcGhhc2UgU3VwcG9ydCBmb3IgTVNTUUwNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAg ICBSZXBvcnRlcjogIGd1ZXN0ICAgICAgICB8ICAgICAgIE93bmVyOiAgcGFqIG9yIHJhbSAgICAg ICAgICAgIA0KICAgICAgICBUeXBlOiAgZW5oYW5jZW1lbnQgIHwgICAgICBTdGF0dXM6ICBuZXcg ICAgICAgICAgICAgICAgICAgDQogICAgUHJpb3JpdHk6ICBtZWRpdW0gICAgICAgfCAgIE1pbGVz dG9uZTogIDAuNC54eCAgICAgICAgICAgICAgICANCiAgIENvbXBvbmVudDogIG1zc3FsICAgICAg ICB8ICAgIFNldmVyaXR5OiAgbm8gdHJpYWdlIHNlbGVjdGVkIHlldA0KICBSZXNvbHV0aW9uOiAg ICAgICAgICAgICAgIHwgICAgS2V5d29yZHM6ICBtc3NxbCB0d29waGFzZSBweW1zc3FsDQpTdGF0 dXNfZmllbGQ6ICBpbiBxdWV1ZSAgICAgfCAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpDaGFuZ2Vz IChieSB6enplZWspOg0KDQogICogb3duZXI6ICByYW0gPT4gcGFqIG9yIHJhbQ0KICAqIHN0YXR1 c19maWVsZDogIGF3YWl0aW5nIHRyaWFnZSA9PiBpbiBxdWV1ZQ0KICAqIG1pbGVzdG9uZTogID0+ IDAuNC54eA0KDQpDb21tZW50Og0KDQogaSBjYW4gcGF0Y2ggdGhlc2UgYnV0IGl0IHdvdWxkIGJl IG5pY2UgdG8gc2VlIGlmIHNvbWVvbmUgY2FuIHRlc3Qgb24gYSBmZXcNCiBlbnZpcm9ubWVudHMu Li4NCg0KLS0gDQpUaWNrZXQgVVJMOiA8aHR0cDovL3d3dy5zcWxhbGNoZW15Lm9yZy90cmFjL3Rp Y2tldC84MjIjY29tbWVudDoxPg0Kc3FsYWxjaGVteSA8aHR0cDovL3d3dy5zcWxhbGNoZW15Lm9y Zy8+DQpUaGUgRGF0YWJhc2UgVG9vbGtpdCBmb3IgUHl0aG9u |
From: sqlalchemy <mi...@zz...> - 2007-11-06 10:05:16
|
IzgyMjogVHdvcGhhc2UgU3VwcG9ydCBmb3IgTVNTUUwNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAg ICBSZXBvcnRlcjogIGd1ZXN0ICAgICAgICB8ICAgICAgIE93bmVyOiAgcGFqIG9yIHJhbSAgICAg ICAgICAgIA0KICAgICAgICBUeXBlOiAgZW5oYW5jZW1lbnQgIHwgICAgICBTdGF0dXM6ICBuZXcg ICAgICAgICAgICAgICAgICAgDQogICAgUHJpb3JpdHk6ICBtZWRpdW0gICAgICAgfCAgIE1pbGVz dG9uZTogIDAuNC54eCAgICAgICAgICAgICAgICANCiAgIENvbXBvbmVudDogIG1zc3FsICAgICAg ICB8ICAgIFNldmVyaXR5OiAgbm8gdHJpYWdlIHNlbGVjdGVkIHlldA0KICBSZXNvbHV0aW9uOiAg ICAgICAgICAgICAgIHwgICAgS2V5d29yZHM6ICBtc3NxbCB0d29waGFzZSBweW1zc3FsDQpTdGF0 dXNfZmllbGQ6ICBpbiBxdWV1ZSAgICAgfCAgDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpDb21tZW50 IChieSBtc3p1bW9ja2kpOg0KDQogSSdtIHVzaW5nIE1TU1FMIDIwMDUgd2l0aCBhZG9kYmFwaS4g V291bGQgdGhhdCBoZWxwPw0KDQotLSANClRpY2tldCBVUkw6IDxodHRwOi8vd3d3LnNxbGFsY2hl bXkub3JnL3RyYWMvdGlja2V0LzgyMiNjb21tZW50OjI+DQpzcWxhbGNoZW15IDxodHRwOi8vd3d3 LnNxbGFsY2hlbXkub3JnLz4NClRoZSBEYXRhYmFzZSBUb29sa2l0IGZvciBQeXRob24= |
From: sqlalchemy <mi...@zz...> - 2008-03-06 19:13:09
|
#822: Twophase Support for MSSQL ----------------------------+----------------------------------------------- Reporter: guest | Owner: paj or ram Type: enhancement | Status: new Priority: medium | Milestone: 0.4.xx Component: mssql | Severity: no triage selected yet Resolution: | Keywords: mssql twophase pymssql Status_field: in queue | ----------------------------+----------------------------------------------- Comment (by guest): mssql.diff makes the following changes: * savepoint support * real two phase support using the jdbc XA stored procs (see [wiki:MSSQLTwoPhaseCommit]) * turns implicit transactions off and manually begins normal transactions. Laurence (l...@lr...) -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/822#comment:3> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
From: sqlalchemy <mi...@zz...> - 2008-03-06 19:16:00
|
#822: Twophase Support for MSSQL ----------------------------+----------------------------------------------- Reporter: guest | Owner: paj or ram Type: enhancement | Status: new Priority: medium | Milestone: 0.4.xx Component: mssql | Severity: no triage selected yet Resolution: | Keywords: mssql twophase pymssql Status_field: in queue | ----------------------------+----------------------------------------------- Comment (by guest): (This is tested with pyodbc, MSSQL 2005 and the sqljdbc 1.2 driver's dll) -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/822#comment:4> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
From: sqlalchemy <mi...@zz...> - 2008-03-06 19:23:50
|
#822: Twophase Support for MSSQL ----------------------------+----------------------------------------------- Reporter: guest | Owner: paj or ram Type: enhancement | Status: new Priority: medium | Milestone: 0.4.xx Component: mssql | Severity: no triage selected yet Resolution: | Keywords: mssql twophase pymssql Status_field: in queue | ----------------------------+----------------------------------------------- Changes (by jek): * cc: l...@lr... (added) -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/822#comment:5> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
From: sqlalchemy <mi...@zz...> - 2008-03-13 19:22:39
|
#822: Twophase Support for MSSQL ----------------------------+----------------------------------------------- Reporter: guest | Owner: paj or ram Type: enhancement | Status: new Priority: medium | Milestone: 0.4.xx Component: mssql | Severity: no triage selected yet Resolution: | Keywords: mssql twophase pymssql Status_field: in queue | ----------------------------+----------------------------------------------- Comment (by guest): Two phase support requires sending a specific TDS packet (see [wiki:MSSQLTwoPhaseCommit MSSQLTwoPhaseCommit]) in order to enlist a connection in the DTC transaction, so this part is on hold until I can work out how (and if) I can manage this. The savepoint support is however working and tests pass (with pyodbc and mssql 2005). Laurence (l...@lr...) -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/822#comment:6> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
From: sqlalchemy <mi...@zz...> - 2008-03-13 23:43:22
|
#822: Twophase Support for MSSQL ----------------------------+----------------------------------------------- Reporter: guest | Owner: paj or ram Type: enhancement | Status: new Priority: medium | Milestone: 0.4.xx Component: mssql | Severity: no triage selected yet Resolution: | Keywords: mssql twophase pymssql Status_field: in queue | ----------------------------+----------------------------------------------- Comment (by zzzeek): laurence - does this invalidate the mssql.diff patch you attached ? -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/822#comment:7> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
From: sqlalchemy <mi...@zz...> - 2008-03-14 10:24:18
|
#822: Twophase Support for MSSQL ----------------------------+----------------------------------------------- Reporter: guest | Owner: paj or ram Type: enhancement | Status: new Priority: medium | Milestone: 0.4.xx Component: mssql | Severity: no triage selected yet Resolution: | Keywords: mssql twophase pymssql Status_field: in queue | ----------------------------+----------------------------------------------- Comment (by guest): Yes, I think I need to add methods to the pyodbc driver before two phase commit can work. Laurence -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/822#comment:8> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
From: sqlalchemy <mi...@zz...> - 2008-12-22 18:58:05
|
#822: Twophase Support for MSSQL -----------------------------+---------------------------------------------- Reporter: guest | Owner: paj or ram Type: enhancement | Status: new Priority: medium | Milestone: 0.6.xx Component: mssql | Severity: major - 1-3 hours Resolution: | Keywords: mssql twophase pymssql Status_field: needs review | -----------------------------+---------------------------------------------- Changes (by zzzeek): * status_field: in queue => needs review * severity: no triage selected yet => major - 1-3 hours * milestone: 0.4.xx => 0.6.xx Comment: pushing this to 0.6 for the dialect refactor, but 0.5.xx code will be accepted as well. -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/822#comment:9> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
From: sqlalchemy <mi...@zz...> - 2011-12-06 22:44:11
|
#822: Twophase Support for MSSQL ---------------------------------+------------------------------------------ Reporter: guest | Owner: paj or ram Type: enhancement | Status: closed Priority: medium | Milestone: 0.x.xx Component: mssql | Severity: major - 1-3 hours Resolution: wontfix | Keywords: mssql twophase pymssql Status_field: completed/closed | ---------------------------------+------------------------------------------ Changes (by zzzeek): * status: new => closed * resolution: => wontfix * status_field: needs review => completed/closed Comment: For now I've just turned on the already present savepoint functionality, that's in r0522003bec3f. As far as two-phase, I've reviewed the notes on the above mentioned wiki page and it appears 2-phase is tremendously complex and not really implemented. This ticket can of course be reopened if there's interest/progress on getting 2-phase to work but I don't see this happening now. -- Ticket URL: <http://www.sqlalchemy.org/trac/ticket/822#comment:10> sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |