Database to database communications over LAN

[Penney, John]

Hello Powerhouse-l:
 
I need some ideas and this was one of the Forums that came immediately to mind.
 
Conceptually we have an application running in JSP, HTML, Oracle 10g,etc. that has to send information across the LAN to a native OpenVMS Server running Oracle Rdb and of course PowerHouse. I won't reveal the version numbers to save people falling off their chairs.
 
On VMS in Real Time we need to have a method of receiving the transmitted data stream, posting ENTRY-FIND-CHANGE transactions to the Rdb and sending back an acknowledgement that we were (or were not) successful.
 
We're talking 20 - 30 tables with about 1,300 online users at this point. Order Entry is my main concern. Record maintenance of existing customers is low volume.

Already Considered:
 
Batch processing is not a solution. Too time consuming and potential for Network performance issues. Maybe even locking problems on VMS side?
 
I thought about using MBXs but how you can access MBXs through a LAN I am unaware of how-to. 
 
Using one central Oracle 10g database for both sides of the house - politically sensitive issue - plus the data migration from Database A to B is probably not feasible.
 
Socket solution-  in the mix.
 
MQ messaging- in the mix.
 
Anybody have any experience conceptually with any of my issues I'd appreciate a post.
 
Thanks for all your help in the past ladies and gents.
 
Cheers!
 
John M Penney
(360)789-8159 cellular


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20090813/c9641356/attachment.html