<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>Hello Powerhouse-l:</DIV>
<DIV> </DIV>
<DIV>I need some ideas and this was one of the Forums that came immediately to mind.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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.<BR><BR>Already Considered:</DIV>
<DIV> </DIV>
<DIV>Batch processing is not a solution. Too time consuming and potential for Network performance issues. Maybe even locking problems on VMS side?</DIV>
<DIV> </DIV>
<DIV>I thought about using MBXs but how you can access MBXs through a LAN I am unaware of how-to. </DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Socket solution- in the mix.</DIV>
<DIV> </DIV>
<DIV>MQ messaging- in the mix.</DIV>
<DIV> </DIV>
<DIV>Anybody have any experience conceptually with any of my issues I'd appreciate a post.</DIV>
<DIV> </DIV>
<DIV>Thanks for all your help in the past ladies and gents.</DIV>
<DIV> </DIV>
<DIV>Cheers!</DIV>
<DIV> </DIV>
<DIV><STRONG>John M Penney</STRONG></DIV>
<DIV><STRONG>(360)789-8159 cellular</STRONG></DIV></td></tr></table><br>