Hi Michel, Are Zope's transaction facilities not enough for you? Zope commits or rolls back all data stores at the end of a request... the Sybase adapter does this automatically. ----- Original Message ----- From: "Michel" <michel@titus.u-strasbg.fr> To: <zope@zope.org> Sent: Wednesday, May 02, 2001 9:48 AM Subject: [Zope] USE TRansaction : _begin()

Hello,

I'm a young user of zope. I use Zope with SYBASE (we created a Product SybaseDAv2 and it seems to work perfectly). Zope created only one connection to sybase and all my Zope users used this connection to send SQL requests.

Now I would like to modify some tables from my database. I need to use transaction. I unchecked "use transaction" into properties of my SybaseDAV2. I created 3 DTML Methods (begin, commit and rollback) which call a ZSQL Method (begintran, commitran,rollbacktran) but it doesn't work because the first user doesn't avoid the second user to modify the same data.

By reading documentation, I found there are these methods implemeted with my SybaseDAv2 product : _begin(self) _finish(self) _abort(self)

But how can I call them ? I tried :

<dtml-call SybDA._begin()> <dtml-call expr="SybDA._begin()"> <dtml-call expr="TM._begin()"> and a lot of other possibilities .... but it doesn't work!!

SybDA is the name of SybaseDAv2 product in my example.

Maybe this will not work too. So How can I use transaction into Zope ? Could you send me an example ?

Thank you very much for your help

OFFNER Michel IGBMC France

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )