[ic] 4.7.3 and transactions

Viktors Rotanovs interchange-users@lists.akopia.com
Fri Jun 1 13:39:00 2001


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
>