Hey there,
We are building a
Struts webapp for a client that will use a MySQL database.
The webapp will only do getMethods (selects).
The main database were all the info is, is an Oracle DB and so somehow the necessary data will have to go from the Oracle to the MySQL DB.
As the budget is rather limited, I would like to ask you guys with experience what the best way is to do this?
We were thinking of the following:
- Some kind of scheduling, being done via the commandline
- Do a dump of the oracle db to csv or xml and upload it to MySQL
- Some kind of transfer application that will do this locally (as Oracle is NOT connected to the internet and MySQL is)
I hope you understand above points.
Does anyone of you have experience with this? Commercial applications will be our last thing to do, so please advise me other methods.
I was thinking something like, since
Tomcat can handle multiple datasources, even the struts webapp can handle multiple datasources, would it be possible to define 2 datasources for the app or Tomcat and somehow do a transfer from time to time?