[ic] 4.7.3 and transactions

John Beima interchange-users@lists.akopia.com
Fri Jun 1 14:32:00 2001


Thanks I'll give it a try!


Quoting Viktors Rotanovs <Viktors@Rotanovs.com>:

> Yep, I've changed log to log_entry in ORDER_ROUTES variable and
> commented out flag type=transaction in etc/log_entry.
> But the best way is to upgrade to some database which supports
> transactions, MySQL Max or PostgreSQL (I prefer PostgreSQL because
> it's transaction commands are well-tested).
> Interchange supports Oracle too, but I haven't tested this
> capability yet.
> 
> Best Wishes,
> Viktors Rotanovs
> Phone +371 7377-472, fax +1 760-418-8128
> viktors@IRCNET, ICQ# 113090923, AOL: ViktorsRotanovs
> 
> ----- Original Message -----
> From: "John Beima" <jbeima@palb.com>
> To: <interchange-users@developer.akopia.com>
> Sent: Friday, June 01, 2001 8:07 PM
> Subject: Re: [ic] 4.7.3 and transactions
> 
> 
> > Did you by chance find the fix for this one?
> >
> > I just found a problem with it posting the order to the transaction
> table,
> but
> > not the orderlines to the orderlines table and it complaining on the
> browser
> > about rollback???
> >
> > What I hit this one at 3 in the morning I just went to bed and I
> havn't
> looked
> > at it yet today...
> >
> > John
> >
> >
> > Quoting Viktors Rotanovs <Viktors@Rotanovs.com>:
> >
> > > Thanks, finally found the problem:
> > > in etc/log_transaction there is
> > > [flag type=transaction table="[loop-code]"]
> > > which does not work if you've installed MySQL without
> > > transaction support (with ISAM tables).
> > >
> > > Best Wishes,
> > > Viktors Rotanovs
> > > Phone +371 7377-472, fax +1 760-418-8128
> > > viktors@IRCNET, ICQ# 113090923, AOL: ViktorsRotanovs
> > >
> > > ----- Original Message -----
> > > From: "Stefan Hornburg (Racke)" <racke@linuxia.de>
> > > To: <interchange-users@developer.akopia.com>
> > > Sent: Friday, June 01, 2001 2:39 PM
> > > Subject: Re: [ic] 4.7.3 and transactions
> > >
> > >
> > > > "Viktors Rotanovs" <Viktors@Rotanovs.com> writes:
> > > >
> > > > > Hi,
> > > > >
> > > > > does 4.7.3 require transaction support in the database?
> > > >
> > > > From WHATSNEW:
> > > >
> > > > Database
> > > > --------
> > > > * Transactions now fully supported. Can open a transaction-capable
> > > >   database in transactions mode [flag type=transactions
> table="table"]
> > > >   and it will commit all changes not done in transaction mode and
> > > reopen
> > > >   under transaction constraints. [flag type=commit table=table]
> > > commits,
> > > >   [flag type=rollback table=table] rolls back.
> > > >
> > > > Ciao
> > > >         Racke
> > > >
> > > > --
> > > > Master of Swiss Web 2001: http://www.zweifel.ch/
> > > >
> > > > For projects and other business stuff please refer to COBOLT
> > > NetServices
> > > > (URL: http://www.cobolt.net; Email: info@cobolt.net; Phone:
> > > 0041-1-3884400)
> > > > _______________________________________________
> > > > Interchange-users mailing list
> > > > Interchange-users@lists.akopia.com
> > > > http://lists.akopia.com/mailman/listinfo/interchange-users
> > > >
> > >
> > > _______________________________________________
> > > Interchange-users mailing list
> > > Interchange-users@lists.akopia.com
> > > http://lists.akopia.com/mailman/listinfo/interchange-users
> > >
> >
> >
> >
> > John Beima
> > jbeima@palb.com, support@alocalagent.com, and support@alocalchurch.com
> >
> > P.A.L.B. Systems - Phone: (780)451-1086 - Fax: (780)447-4760
> > 11639-122 Street, Edmonton, Alberta, Canada, T5M 0B6
> >
> > Affordable Web Pages - Phone: (888)932-9990 - Fax: (256)351-7297
> > 2713B Spring Place SW, Decatur, Alabama, United States, 35603
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> >
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
> 



John Beima
jbeima@palb.com, support@alocalagent.com, and support@alocalchurch.com

P.A.L.B. Systems - Phone: (780)451-1086 - Fax: (780)447-4760
11639-122 Street, Edmonton, Alberta, Canada, T5M 0B6

Affordable Web Pages - Phone: (888)932-9990 - Fax: (256)351-7297
2713B Spring Place SW, Decatur, Alabama, United States, 35603