This week's book giveaway is in the Java 9 forum.
We're giving away four copies of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications and have Sander Mak & Paul Bakker on-line!
See this thread for details.
Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Publishing to another database  RSS feed

 
Shruti Sharma
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I create some data in my system (one application). I need to publish that data in the Oracle database of another system (another application) by calling their stored procedure. How can I do that?
One way is to send data to this second system and they can populate it on their own. Is there any other way? Is there a way to directly connect to the second system and invoke their stored procedure to insert data into their database?

Thank you,
-Shruti
 
Agador Paloi
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is a couple of ways you can do this.
- you can use a trigger in system A table to update a table in system B
- System B can grant permissions to system A to execute a stored procedure that does the update in system B,
assuming the system run in different schemas.

In either case , permissions will need to be granted for the update of system B.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!