Isolation level… Join new JAVA development with old, outdated COBOL code…
Anyone have experience dealing with JAVA and isolation levels? The concern or talk at this shop is how to handle current old COBOL code with new JAVA code with record locks. All Cobol code runs batch mode. Reads daily transaction file to update files. The new world, Java, will be interactive update real time code. The business does not want to re-write current COBOL (which I do not agree with). Actually, the data base needs to be redesigned.
Software/Hardware used:
Software/Hardware used:
ASKED:
October 30, 2006 11:52 AM
UPDATED:
October 31, 2006 10:54 AM
Answer Wiki:
How to handle isolation levels depends on which DBMS you're using. DB2 most closely matches Cobol's model. For instance, if you're using DB2, you can control the level on a statement-by-statement basis, using WITH or FOR.
Example:
SELECT x FROM y WITH NC;
SELECT a FROM b WITH RR;
---
Sheldon Linker (sol@linker.com)
Linker Systems, Inc. (www.linkersystems.com)
800-315-1174 (+1-949-552-1904)
To see all answers submitted to the Answer Wiki: View Answer History.
Here is one of many possible solutions.
You mentioned the cobol program is a batch job and you are dealing with Java and record locks. The solution needs to deal with single transaction processor where a data queue will funnel the requests to the Cobol program that would stay resident and handle the record locks. The Java front end needs to pass a request to the server side that ends up on the data queue. This eliminates contention for for recod locks.
Don’t have enough information on your situation to advise other solutions…
Yes, the Cobol program will need some modifications to allow for interactive use of its business processing provided…you can improve the business in a tangible way your customer can conceptualize and be willing to pay for.
A few questions you will need (or have answered) are:
Why is a overnight solution not good enough for the future?
How does a quick response improve the business?
What are the benefits?
How will it be measured?
When will it be be done?