Changing to logging under New Era App 
Author Message
 Changing to logging under New Era App

When we first coded our New Era application, we were developing on a
database that did not have transaction logging. Now, for various
reasons, we MUST turn logging on (on an OnLine 7 database).

Unfortunately, we never wrote code into our application to handle
transactions. All our SuperTables are set to no lock mode and there is
no code to handle the begin and end work equivelents.

We tried turning logging on, but of course no changes made to the
database using our New Era application were committed. What a disaster.

I would like to do the least amount or re-coding as possible to start
with, as the need to change to transaction logging is critical.

Has anyone tried the following:

Set the connection options for the implicit connection object to
autoCommit mode, and left the SuperTables in no lock mode? How does the
application behave? what are the risks?

Has anyone, written all the code for handling transactions? What are the
benefits of each SuperTable mode (pessimistic and optimistic)?

Again, I am looking for the quickest short term solution and then we can
go back and re-code to handle things the right way.

Thanks for any comments,

Devan

Devan Dewey
Manager of Technology Services
Segue Software
http://www.***.com/



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. New Era App Partitioning

2. 1363 Error - Memory using New Era App on Windows 3.11

3. New Era app as background process...

4. New Era App Class Library

5. FMP v5 Protocol changes when new user logs on

6. US-VA-SOFTWARE ENGINEER - NEW-ERA FINANCE / ORACLE

7. please revive project 4GL++, using 4gl for Windows and New Era

8. Oracle and New Era 2.2

9. Split Big Application in New Era

10. NEW ERA

11. NEW ERA

12. FW: New Era Installation/Setup Problems


 
Powered by phpBB® Forum Software