Re: [Webtek-devel] DB Transactions in WebTek

[max d. <pro...@gm...>]

On May 26, 2008, at 4:23 PM, Adrian Smith wrote:

> I notice that the "session" table, in the MySQL table-creation  
> script, is of type "MyISAM" instead of "InnoDB".

> I shall be using InnoDB for my MySQL database tables. I assume this  
> is no problem?

should be no problem

>
> In this case, would you recommend I change the "session" table to be  
> "InnoDB", in order to keep work done on model objects, and values  
> saved in the "session" table, consistent in the case of an  
> unexpected error or power failure?

?? dont understand this question (my poor english) ;)

> I had a look at the code, and could not quite work out how/when/if  
> transactions were started and committed. Can you confirm that I  
> don't have to do anything special in my code - i.e. before every web  
> request, a DB transaction is opened, and after every successful web  
> request, the DB transaction is committed?

transactions are done with events (request-end (=commit) or request- 
had-errors (=rollback).
ups. i didnt update the event-names in WebTek::DB. this is done yet  
and checked in into the trunk repository

ps: i havn't tested transactions so far, because i never used them,  
but the code is there and should work ... :) (hope so)

> (Or do I have to explicitly open/close DB transactions in my code,  
> around logic which I wish to be joined in a transaction?)

no.

> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/_______________________________________________
> Webtek-devel mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/webtek-devel