Isolation level… Join new JAVA development with old, outdated COBOL code…

460 pts.
Tags:
AS/400
IBM DB2
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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)

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Tellme
    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?
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following