Re: [Springframework-developer] Why does SingleConnectionDataSource always set autoCommit=true?

[<jue...@we...>]

Q29saW4sDQogDQpZb3Ugb2J2aW91c2x5IHdhbnQgdG8gcGVyZm9ybSBwbGFpbiBKREJDIGFjY2Vz
cyB3aXRoaW4gdGhlIHNhbWUgdHJhbnNhY3Rpb24gYXMgdGhlIEhpYmVybmF0ZSBhY2Nlc3MuIFRo
aXMgY2FuIGJlIGFjaGlldmVkIGVhc2lseSB2aWEgSGliZXJuYXRlVHJhbnNhY3Rpb25NYW5hZ2Vy
IG9yIEp0YVRyYW5zYWN0aW9uTWFuYWdlciwgd2l0aG91dCBhbnkgc3BlY2lmaWMgZ2x1aW5nLg0K
IA0KSWYgeW91IGRlZmluZSBhIHJlc3BlY3RpdmUgSkRCQyBEYXRhU291cmNlIGluIHRoZSBhcHBs
aWNhdGlvbiBjb250ZXh0LCBwb2ludGluZyB0byB0aGUgc2FtZSBvbmUgdGhhdCBIaWJlcm5hdGUg
dXNlcyAoYmUgaXQgYSBsb2NhbCBvbmUgc3BlY2lmaWVkIG9uIExvY2FsU2Vzc2lvbkZhY3RvcnlC
ZWFuIG9yIGEgc2hhcmVkIEpOREkgb25lKSwgeW91IGNhbiBtYWtlIEhpYmVybmF0ZVRyYW5zYWN0
aW9uTWFuYWdlciBleHBvcnQgaXRzIHRyYW5zYWN0aW9ucyBmb3IgdGhpcyBwYXJ0aWN1bGFyIERh
dGFTb3VyY2UgYnkgcGFzc2luZyB0aGUgRGF0YVNvdXJjZSBhcyBiZWFuIHJlZmVyZW5jZSBpbnRv
IGl0cyAiZGF0YVNvdXJjZSIgcHJvcGVydHkuIEhpYmVybmF0ZVRyYW5zYWN0aW9uTWFuYWdlciB3
aWxsIHNpbXBseSB0YWtlIHRoZSB2ZXJ5IEpEQkMgQ29ubmVjdGlvbiB0aGF0IHRoZSBIaWJlcm5h
dGUgU2Vzc2lvbiB1c2VzIGFuZCBiaW5kIGl0IHRvIHRoZSB0aHJlYWQgdmlhIERhdGFTb3VyY2VV
dGlscyBmb3IgcGxhaW4gSkRCQyBhY2Nlc3Mgb24gdGhhdCBEYXRhU291cmNlLiBUaGUgbGF0dGVy
IGRvZXMgbm90IGhhdmUgdG8gYmUgYXdhcmUgdGhhdCBpdCBpcyB3b3JraW5nIHdpdGggYSBIaWJl
cm5hdGUtcHJvdmlkZWQgQ29ubmVjdGlvbiENCiANCldpdGggSnRhVHJhbnNhY3Rpb25NYW5hZ2Vy
LCBpdCdzIHNpbWlsYXI6IERlZmluZSB0aGUgc2FtZSBKTkRJIERhdGFTb3VyY2UgdGhhdCB0aGUg
SGliZXJuYXRlIFNlc3Npb25GYWN0b3J5IHVzZXMgZm9yIHRoZSBKZGJjVGVtcGxhdGUsIGFuZCBK
VEEgd2lsbCBjYXJlIGZvciByZXR1cm5pbmcgdGhlIHNhbWUgQ29ubmVjdGlvbiB0byBib3RoIHRo
ZSBIaWJlcm5hdGUgU2Vzc2lvbiBhbmQgdGhlIEpEQkMgYWNjZXNzIGNvZGUgaWYgaW4gYW4gYWN0
aXZlIHRyYW5zYWN0aW9uLg0KIA0KU28gaW4gYW55IGNhc2UsIHRoaXMgInNhbWUgRGF0YVNvdXJj
ZSIgYXBwcm9hY2ggaXMgYXMgZWZmaWNpZW50IGFzIHBhc3NpbmcgdGhlIEhpYmVybmF0ZSBTZXNz
aW9uJ3MgSkRCQyBDb25uZWN0aW9uIG1hbnVhbGx5IHRvIGEgSmRiY1RlbXBsYXRlIGluc3RhbmNl
LCBhcyBpdCByZXVzZXMgdGhlIHNhbWUgQ29ubmVjdGlvbiBmb3IgYm90aCB0aGUgSGliZXJuYXRl
IFNlc3Npb24gYW5kIHRoZSBKZGJjVGVtcGxhdGUgd2l0aGluIGEgdHJhbnNhY3Rpb24uIEkgc3Ry
b25nbHkgcmVjb21tZW5kIHN1Y2ggYSBzb2x1dGlvbiBvdmVyIG1hbnVhbCBnbHVpbmcuDQogDQpK
dWVyZ2VuDQogDQogDQoNCgktLS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0tLS0tIA0KCVZv
bjogQ29saW4gU2FtcGFsZWFudSBbbWFpbHRvOmNvbGlubWwxQGV4aXMuY29tXSANCglHZXNlbmRl
dDogTW8gMjUuMDguMjAwMyAyMzoxNCANCglBbjogasO8cmdlbiBow7ZsbGVyIFt3ZXJrM0FUXSAN
CglDYzogc3ByaW5nZnJhbWV3b3JrLWRldmVsb3BlckBsaXN0cy5zb3VyY2Vmb3JnZS5uZXQgDQoJ
QmV0cmVmZjogUmU6IFtTcHJpbmdmcmFtZXdvcmstZGV2ZWxvcGVyXSBXaHkgZG9lcyBTaW5nbGVD
b25uZWN0aW9uRGF0YVNvdXJjZSBhbHdheXMgc2V0IGF1dG9Db21taXQ9dHJ1ZT8NCgkNCgkNCg0K
CVcvcmVnYXJkcyB0byBhdXRvIGNvbW1pdCBpbiB0aGUgZGVmYXVsdCBjYXNlICh3aGVuIHRoZSBj
bGFzcyBnZXRzIHRoZQ0KCWNvbm5lY3Rpb24gaXRzZWxmKSwgSSB3b3VsZCBzYXksIGV4YWN0bHks
IHRoZSBKREJDIHNwZWNzIHNwZWNpZmljYWxseQ0KCXNheSB0aGUgZ2V0Q29ubmVjdGlvbiBjYWxs
ZWQgb24gdGhlIGRhdGFzb3VyY2Ugd2lsbCByZXR1cm4gYSBjb25uZWN0aW9uDQoJd2l0aCBhdXRv
Q29tbWl0IG9uIGJ5IGRlZmF1bHQuIFNvIHdoeSBpcyBTaW5nbGVDb25uZWN0aW9uRGF0YVNvdXJj
ZSB0aGVuDQoJZ29pbmcgYW5kIHNldHRpbmcgaXQgb24gYXMgd2VsbC4gR2l2ZW4gdGhhdCBTaW5n
bGVDb25uZWN0aW9uRGF0YXNvdXJjZQ0KCWRvZXNuJ3QgaGF2ZSBhbnkgY2x1ZSBhYm91dCB0aGUg
aW50ZW5kZWQgdXNlIG9mIHRoZSBjb25uZWN0aW9uLCB0aGUgbW9zdA0KCWNvcnJlY3QgYmVoYXZp
b3VyIGlzIHByb2JhYmx5IHRvIG5vdCBoYXZlIGl0IGNhbGwgc2V0QXV0b0NvbW1pdCB3aXRoDQoJ
ZWl0aGVyIHN0YXRlLCBieSBkZWZhdWx0LCB3aGljaCB3b3VsZCBtaXJyb3Igbm9ybWFsDQoJZGF0
YXNvdXJjZS9jb25uZWN0aW9uIHVzYWdlLCBhbmQgYWxzbyBhbGxvdyBhIG1lY2hhbmlzbSB0byBz
cGVjaWZ5IHRoYXQNCglpdCBzaG91bGQgYmUgY2FsbGVkIG9uZSB3YXkgb3IgYW5vdGhlci4gSG93
ZXZlciwgdGhpcyBtYXkgYmUgbW9yZSB3b3JrDQoJdGhhbiBpcyB3b3J0aCBpdCwgYW5kIGEgZGVm
YXVsdCBjYWxsIHdpdGggdGhlIG9wdGlvbiB0byBvbiwgYWxvbmcgd2l0aCBhDQoJbWVjaGFuaXNt
IChhbm90aGVyIGNvbnN0cnVjdG9yIHdpdGggYSB2YWx1ZSBmb3IgdGhlIGNhbGwpIHRvIG92ZXJy
aWRlDQoJaXQsIHdvdWxkIGJlIGZpbmUuIFNvIHRvIGJlIGNsZWFyLCBJIGRvIHRoaW5rIGV2ZW4g
d2hlbg0KCVNpbmdsZUNvbm5lY3Rpb25EYXRhU291cmNlIGdldHMgdGhlIGNvbm5lY3Rpb24gdGhl
cmUgaXMgYSBuZWVkIGZvciBhbg0KCW92ZXJyaWRlLg0KCQ0KCUFzIGZvciBteSB1c2UgY2FzZSwg
SSBkb24ndCB0aGluayBJIHdhcyBjbGVhciBlbm91Z2guICBJIGhhdmUgc29tZSBjb2RlDQoJaW4g
YSBIaWJlcm5hdGUgc3BlY2lmaWMgREFPL01hcHBlciBvYmplY3QuIEkgYW0gYWxyZWFkeSBleGVj
dXRpbmcgaW5zaWRlDQoJYSB0cmFuc2FjdGlvbiBpbnRyb2R1Y2VkIHZpYSBTcHJpbmcncyBBT1Ag
aW50ZXJjZXB0b3IuIFNvIEkgZG8gaGF2ZSBhDQoJU2Vzc2lvbkZhY3RvcnksIGV0Yy4gYm91bmQg
dG8gdGhlIHRocmVhZC4gTm93IGluc2lkZSBhIG1ldGhvZCBpbiB0aGlzDQoJbWFwcGVyIEkgbmVl
ZCB0byBkbyBhbiBvcGVyYXRpb24gb24gYSBCTE9CL0NMT0IsIHdoZXJlIHRoZXJlIGFyZSBhDQoJ
bnVtYmVyIG9mIGRiIHBsYXRmb3JtIHNwZWNpZmljIGlzc3VlcywgYW5kIEhpYmVybmF0ZSdzIHN1
cHBvcnQgb2YNCglCTE9Ccy9DTE9CcyBpcyBub3QgZ29vZCBlbm91Z2guIEdpdmVuIHRoYXQgSSBo
YXZlIGEgSGliZXJuYXRlIFNlc3Npb24NCgl3aGljaCBhbHJlYWR5IGhhcyBhIGNvbm5lY3Rpb24g
YXZhaWxhYmxlLCB1c2luZyBpdCBpcyB0aGUgYmVzdCBtZWNoYW5pc20NCgkoYXMgb3Bwb3NlZCB0
byB0cnlpbmcgdG8gZ2V0IGEgcmVhbCBEYXRhU291cmNlIGluIFNwcmluZydzIGNvbnRleHQgdG8N
Cgl1c2UpLiBOb3cgSSBhbSB1c2luZyBKREJDVGVtcGxhdGUgYW5kIEpEQkNIZWxwZXIgYXMgY29u
dmVuaWVuY2UgY2xhc3NlcywNCgl0byB3cmFwIEpEQkMgZXhjZXB0aW9ucywgYW5kIGZvciB0aGUg
bWV0aG9kcyB0aGV5IHByb3ZpZGUuIE5vdyBJIGNvdWxkIGNhbGwNCgkgIERhdGFTb3VyY2VVdGls
cy5nZXRUaHJlYWRPYmplY3RNYW5hZ2VyKCkuYmluZFRocmVhZE9iamVjdCguLi4pDQoJdG8gYmlu
ZCB0aGUgU2luZ2xlQ29ubmVjdGlvbkRhdGFzb3VyY2UgdG8gdGhlIHRocmVhZCwgYmVmb3JlIHVz
aW5nIHRoZQ0KCUpEQkNUZW1wbGF0ZSwgYnV0IEknbSBub3Qgc3VyZSB0aGF0J3MgYnV5aW5nIG1l
IG11Y2ggb3ZlciB0aGUgY2FzZSBvZg0KCW5vdCBiaW5kaW5nIGl0LiBJbiBlaXRoZXIgY2FzZSwg
SkRCQ1RlbXBsYXRlIGlzIHNpbXBseSBnb2luZyB0byBlbmQgdXANCglnZXR0aW5nIHRoZSBzYW1l
IENvbm5lY3Rpb24uIEJlY2F1c2UgSSBhbSB1c2luZyB0aGUNCglTaW5nbGVDb25uZWN0aW9uRGF0
YXNvdXJjZSwgaXQncyBub3QgbGlrZSBpbiB0aGlzIGNhc2UgdGhlcmUgaXMgYSByZWFsDQoJRGF0
YVNvdXJjZSBvYmplY3QsIGFuZCB5b3Ugb25seSB3YW50IHRvIGNhbGwgZ2V0Q29ubmVjdGlvbiBv
biBpdCBvbmNlLi4uDQoJDQoJSG9wZWZ1bGx5IG15IGV4YXBsYW5hdGlvbiBpcyBjbGVhciBub3cu
Li4NCgkNCgkNCglqw7xyZ2VuIGjDtmxsZXIgW3dlcmszQVRdIHdyb3RlOg0KCQ0KCT5JIGFncmVl
IHRoYXQgaW4gY2FzZSBvZiBhbiBleGlzdGluZyBjb25uZWN0aW9uLCBTaW5nbGVDb25uZWN0aW9u
RGF0YVNvdXJjZSBzaG91bGQgbm90IG92ZXJyaWRlIHRoZSBjb21taXQgbW9kZS4gRm9yIHRoZSBk
ZWZhdWx0IGNhc2UsIEkgY29uc2lkZXIgYXV0byBjb21taXQgbW9kZSBhcHByb3ByaWF0ZSB0aG91
Z2guIEFueSBKMkVFIERhdGFTb3VyY2Ugd2lsbCByZXR1cm4gYW4gYXV0byBjb21taXQgY29ubmVj
dGlvbiBvdXRzaWRlIGEgdHJhbnNhY3Rpb24sIHNvIHdoeSBzaG91bGRuJ3QgU2luZ2xlQ29ubmVj
dGlvbkRhdGFTb3VyY2UgZG8gdG9vPw0KCT4NCgk+QlRXLCB3aGF0IHlvdSBhcmUgdHJ5aW5nIHRv
IGRvIHNlZW1zIGEgYml0IGF3a3dhcmQuIFdoeSBtYW51YWxseSBmZWVkIHRoZSBDb25uZWN0aW9u
IG9mIGEgSGliZXJuYXRlIFNlc3Npb24gdmlhIFNpbmdsZUNvbm5lY3Rpb25EYXRhU291cmNlIHRv
IEpkYmNUZW1wbGF0ZT8gSmRiY1RlbXBsYXRlIGlzIHN1cHBvc2VkIHRvIGJlIGEgdGhyZWFkc2Fm
ZSwgcmV1c2FibGUgb2JqZWN0LCBmZXRjaGluZyBjb25uZWN0aW9ucyBvbiBkZW1hbmQuIFdvdWxk
bid0IGl0IGJlIGVhc2llciB0byB1c2UgU3ByaW5nJ3MgdGhyZWFkLWJpbmRpbmcgbWVjaGFuaXNt
IChEYXRhU291cmNlVXRpbHMuZ2V0VGhyZWFkT2JqZWN0TWFuYWdlcikgdG8gbWFrZSBKZGJjVGVt
cGxhdGUgdXNlIGEgc3BlY2lmaWMgY29ubmVjdGlvbiwgYmUgaXQgaW1wbGljaXRseSB2aWEgSGli
ZXJuYXRlVHJhbnNhY3Rpb25NYW5hZ2VyIG9yIGV4cGxpY2l0bHkgaW4gc29tZSBjdXN0b20gd2F5
Pw0KCT4NCgk+SnVlcmdlbg0KCT4NCgk+DQoJPg0KCT4gICAgICAgLS0tLS1VcnNwcsO8bmdsaWNo
ZSBOYWNocmljaHQtLS0tLQ0KCT4gICAgICAgVm9uOiBDb2xpbiBTYW1wYWxlYW51IFttYWlsdG86
Y29saW5tbDFAZXhpcy5jb21dDQoJPiAgICAgICBHZXNlbmRldDogTW8gMjUuMDguMjAwMyAyMDow
Mg0KCT4gICAgICAgQW46IHNwcmluZ2ZyYW1ld29yay1kZXZlbG9wZXJAbGlzdHMuc291cmNlZm9y
Z2UubmV0DQoJPiAgICAgICBDYzoNCgk+ICAgICAgIEJldHJlZmY6IFtTcHJpbmdmcmFtZXdvcmst
ZGV2ZWxvcGVyXSBXaHkgZG9lcyBTaW5nbGVDb25uZWN0aW9uRGF0YVNvdXJjZSBhbHdheXMgc2V0
IGF1dG9Db21taXQ9dHJ1ZT8NCgk+ICAgICAgDQoJPiAgICAgIA0KCT4NCgk+ICAgICAgIEkgd2Fu
dCB0byB1c2UgU2luZ2xlQ29ubmVjdGlvbkRhdGFTb3VyY2Ugd2l0aCBIaWJlcm5hdGUsIHNvIEkg
Y2FuIHdyYXAgYQ0KCT4gICAgICAgY29ubmVjdGlvbiBJIGdldCBmcm9tIGEgSGliZXJuYXRlIFNl
c3Npb24sIGFuZCBmZWVkIGl0IGFzIGEgRGF0YVNvdXJjZQ0KCT4gICAgICAgdG8gSkRCQ1RlbXBs
YXRlL0pEQkNIZWxwZXIuDQoJPiAgICAgIA0KCT4gICAgICAgSG93ZXZlciwgcmlnaHQgbm93IEkn
dmUgaGFkIHRvIG1ha2UgbXkgb3duIHZhcmlhbnQgc2luY2UgdGhlIGN1cnJlbnQNCgk+ICAgICAg
IGNvZGUgYWx3YXlzIGNhbGxzDQoJPiAgICAgICAgIHNvdXJjZS5zZXRBdXRvQ29tbWl0KHRydWUp
Ow0KCT4gICAgICAgaW4gdGhlIGluaXQoKSBtZXRob2QuICBUaGlzIHNlZW1zIHZlcnkgYXJiaXRy
YXJ5IHRvIG1lLiBBdCBsZWFzdCBpbiB0aGUNCgk+ICAgICAgIGNhc2Ugd2hlbiB0aGUgY2xhc3Mg
aXMgZ2l2ZW4gYW4gZXhpc3RpbmcgY29ubmVjdGlvbiwgaXQgc2hvdWxkIGp1c3QNCgk+ICAgICAg
IGFzc3VtZSB0aGUgY29tbWl0IG9wdGlvbiBoYXMgYmVlbiBzZXQgYXBwcm9wcmlhdGVseSBvbiB0
aGUgY29ubmVjdGlvbi4NCgk+ICAgICAgDQoJPiAgICAgICBFdmVuIGluIHRoZSBjYXNlIHdoZW4g
dGhlIGNsYXNzIGlzIG9wZW5pbmcgdGhlIGNvbm5lY3Rpb24gaXRzZWxmIGZyb20gYW4NCgk+ICAg
ICAgIGV4aXN0aW5nIERhdGFTb3VyY2UsIHRoZXJlIG5lZWRzIHRvIGJlIGFuIG9wdGlvbiB0byBz
ZXQgYXV0b0NvbW1pdA0KCT4gICAgICAgZWl0aGVyIHdheS4NCgk+ICAgICAgDQoJPiAgICAgICBS
ZWdhcmRzLA0KCT4gICAgICAgQ29saW4NCgk+ICAgICAgDQoJPg0KCQ0KCQ0KCQ0KDQo=