I have an Oracle database that runs a PL / SQl job once a week to copy data from a table in an Oracle database to another Oracle database using the Oracle database links. Both systems run on Unix / Solaris. The task is scheduled and completed through the installation of Unix Cron.
The remote computer is now migrated from UNIX to the Windows platform with the MSQL Server database. I studied the possibility of using links to Oracle databases to connect from UNIX to the MSSQL Server database, which will run on the Windows platform. It is possible, but it seems to me that there are many problems to make it work, and not much information on how to implement it.
Another solution that I think of is to implement the process as a Java daemon process that will run every week. All he does is connect to the Oracle database, read data from some tables, connect to the MSSQL Server database and run some insert commands. I think for this I will need two types of drivers - for example, jdbc for Oracle and jdbc for MSSQL Server.
Does Spring provide any tool that makes it easier to implement and maintain the above? (In particular, several drivers and part of the requirements planning)
Is Hibernate suitable for managing multiple database connections or is it excessive?
Feel free to also offer the best solution :)
thank