Re: [Web-erp-developers] Upgrade SQL Scripts

[Stins, D. <DR...@Zi...>]

I agree that it is much better to use transactions.

I only do not know how mysql handles transactions, but in oracle you can not
encapsulate ddl in a transaction. Every ddl is then one transaction.

With best regards,

Dick Stins
----- Original Message -----
From: "Jesse Peterson" <je...@st...>
To: <web...@li...>
Sent: Sunday, September 05, 2004 6:34 AM
Subject: [Web-erp-developers] Upgrade SQL Scripts


> I ran some of the upgrade scripts today... I ran into a couple bumps,
> mostly mine, 1 theirs. I will be sending Phil the one actual problem I
saw.
> I also would like to suggest that as an additional safety for everyone,
> especially average users, all upgrade scripts be encapsulated in a
> transaction to ensure the whole thing is not run until it will run
> fully. Can anyone see a reason not to do that?
>
>
> jesse
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>