Connecting to multiple Databases using Torque
To begin with, let me say that , “Torque” is an Object Relational Mapping(ORM) Tool for Java. I have some expertise working with Torque when compared to iBatis and Hibernate, so I thought of sharing one of my experiences that I came across when I WAS using Torque[yes, that’s right I am not using Torque anymore]. The requirement here was to connect to two databases, fetch data from one database and insert it into another. Fetching and inserting into Databases is a very basic thing that I would like not to discuss here (at least in this blog). However, before we Fetch or Insert, there are few more operations that we need to perform, and one of those is “Establishing a Connection with the database”. This write-up with a small example data explains us the concept of connecting to multiple DBs using the ‘Torque’ ORM tool. torque.properties file appears to be like this ## Oracle DB Properties torque.database=default torque.database.default.adapter=oracle...