Database to database communications over LAN

[Kent Heatherington]

We run oracle messaging to external agencies using MQ and its wonderful, reliable and easy.  We tried to run with Oracle Streams for 9I and it 
simply failed failed and failed miserably and is now uninstalled !!!

My 2 cents...
  ----- Original Message ----- 
  From: cfinley 
  To: 'Penney, John' ; powerh-l at lists.sowder.com 
  Sent: Thursday, August 13, 2009 5:48 PM
  Subject: RE: Database to database communications over LAN


  I would think that Websphere MQ  would be the best choice and require the least amount of programming.  By that I mean, the problem with sockets in any solution is that it is up to the developer to take care of error correction, outages, etc.  Websphere MQ has much of that built in.  Moreover there are multiple API's you can use to write the application including COBOL.  Also, there are many free and low cost commercial tools that can help you with troubleshooting and debugging.

   

  There are several choice available to you to create such a solution.  One that comes to mind is that Oracle side would use a combination of stored procedures, triggers and perhaps transactions. The VMS side will require some sort of simple server application to manage the communications with the Oracle host and the making of the changes to the RDB database.  

   

  If this sounds appealing, please contact me directly and I will brainstorm some implementation ideas with you.

   

  Charles Finley

  (619) 795-0720

   


------------------------------------------------------------------------------

  From: powerh-l-bounces+cfinley=xformix.com at lists.sowder.com [mailto:powerh-l-bounces+cfinley=xformix.com at lists.sowder.com] On Behalf Of Penney, John
  Sent: Thursday, August 13, 2009 2:20 PM
  To: powerh-l at lists.sowder.com
  Subject: Database to database communications over LAN

   

        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
       

   



------------------------------------------------------------------------------


  -- 
  = = = = = = = = = = = = = = = = = = = = = = = = = = = =
  Mailing list: powerh-l at lists.sowder.com
  Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
  Unsubscribe: 'unsubscribe <password>' in message body to powerh-l-request at lists.sowder.com
  http://lists.sowder.com/mailman/listinfo/powerh-l
  This list is closed, thus to post to the list you must be a subscriber.
  Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20090813/0d68d7b7/attachment-0001.htm