PB/Java Database Transactions on EA Server

[SamV]

I currently work on a PB server side application. The application (Tax
Software) was written in PB/Java/EAF running on EA Server. It was
developed about 8 years ago with the then available technologies. The
application is working fine, but there are leftovers from past
legacies that I am trying to to clean up code/design.

There are certain code that does database (Oracle) transactions across
PB and Java and since the 2 happened to be in different Database
(Oracle) sessions, changes in one aren't visible in the other. So, in
these cases, the application uses a switch to use PB code for the
complete transaction instead of splitting across PB and Java.
Otherwise, it uses PB/Java combination.

What this means is that identical sets of program blocks exist in PB
and Java. Maintenance nightmare!! I believe PB objects were created
first and someone ported those to Java for performance reason (not
considering the above split transaction issue). I am trying to
eliminate one (probably the PB code, considering performance). I am
exploring PBNI in this context.

Please let me know, if any of you faced a similar situation and how
you would solve it.

Thanks a lot in advance.

Sam