[Zope-DB] Dynamically generate sql-query in ZSQL Method

[Peter Sabaini]

I did some quick googling and found a thread about problems with manual 
transaction handling in standard_error_message -- did I overlook 
something? Could you summarize your experience in a few sentences?

Thanks,
peter.


Jim Abramson wrote:
>>I've not used this feature much since I try to stay in stored 
>>procedures, but there is the get_transaction().commit() / abort() 
>>functionality. Is this invocation problematic?
> 
> 
> I was under the impression that this was a per-thread thing, not
> per-connection
> which is what I'd need.  Furthermore, I've read many stern
> admonishments, on this 
> here list and elsewhere, never to attempt to mess with commit/rollback
> on an
> external RDBMS connection, unless you want to suffer miserably.  I've
> learned
> (by firsthand experience) that this is indeed good advice.
> 
> Jim
> 
> 
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3216 bytes
Desc: S/MIME Cryptographic Signature
Url : http://mail.zope.org/pipermail/zope-db/attachments/20040407/da725553/smime.bin