Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Transaction Propagation in Legacy System with Web interface

 
Roger Chang
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear all,

Does anyone know how to control transaction propagation from EJB to
a legacy System with web interface, say perl, cgi.... since I dont
want to replicate business logic that has been written in the existing
system?

Using HTTPConnection does not address the transaction propagation problem..
..... get stuck!!!

Thanks

Regards
 
SAFROLE YUTANI
Ranch Hand
Posts: 257
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Roger Chang:
Dear all,

Does anyone know how to control transaction propagation from EJB to
a legacy System with web interface, say perl, cgi.... since I dont
want to replicate business logic that has been written in the existing
system?

Using HTTPConnection does not address the transaction propagation problem..
..... get stuck!!!

Thanks

Regards


I'm assuming that you are trying to devise a method for booking a flight within the COBOL mainframe and including the mileage update to the Oracle database in the same transaction. The mileage database has a CGI/Perl web server for accessing the database from a "read only" context. The documentation does not mention that travel agens use the web-based system to update the mileage, it only says that it's used for getting the mileage. You can assume that travel agents don't use the web server for "updating" the Oracle database since that would be very prone to data integrity issues. What would happen if the agent books the flight then gets killed by a stray bullet immediately after.

If you want to include the mileage update in the "Pay for Itinerary" use case, then create a DAO that uses JDBC to access the Oracle database and call it from the EJB method that books and pays for the flight.

The documentation does not mention exactly how the mileage database gets updated based on new flight bookings, so you can assume that it is updated with some type of out-of-process procedure (cron-job, who know's), and you cannot reuse that procedure.
[ June 11, 2004: Message edited by: SAFROLE YUTANI ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic