Database to database communications over LAN

[cfinley]

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

 

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