[Zope] begin/commit

Tino Wildenhain tino@wildenhain.de
Tue, 03 Jul 2001 13:41:01 +0200


Hi Gustavo,

--On Montag, 2. Juli 2001 21:51 -0300 Gustavo Vieira Goncalves Coelho Rios 
<gustavo@ifour.com.br> wrote:

> Hi folks,
>
> First, i would like to thanks all of you who provided me with the
> necessary help to get zope + mysql running, THANKS!
>
> I am facing a "problem": i added a mysql connection to my folder, zope is
> executing a begin + my query + commit. How may i stop zope from doing
> that. I want it only execute <my query>, nothing more, nothing else.

Thats a feature of zope. The support for transactions is relatively
new in mysql. However it makes sense. I cant think of a case where
it can get in the way. May be you can show me where the problem with
the transaction lives? Then, you might modify the DA or write
your special own.

> Another problem: Just some of the query i run works when testing mysql
> connection. For instance, the following query does not work: select now()
>
> Looking at mysql log i saw zope exec the folloging:
>
> select now() limit 1000

limit 1000 is not nessecary. Look at the "advanced" tab of ZSQL Methods
for options to the query.
There might be a problem with the now() call concerning names. Try
select now() as now
as a workaround.

Regards
Tino