Connecting to multiple Databases using Torque

By -
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
torque.dsfactory.default.factory=org.apache.torque.dsfactory.JndiDataSourceFactory
torque.dsfactory.default.jndi.path = java:/jdbc/consumers
torque.dsfactory.default.jndi.java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory
torque.dsfactory.default.jndi.java.naming.factory.url.pkgs = javax.naming
##  Sql Server 2005 Properties
torque.database.mssqldb.adapter=mssql
torque.dsfactory.mssqldb.factory=org.apache.torque.dsfactory.JndiDataSourceFactory
torque.dsfactory.mssqldb.jndi.path=java:/consumers-sqlserver-ds
torque.dsfactory.mssqldb.jndi.java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory
torque.dsfactory.mssqldb.jndi.java.naming.factory.url.pkgs=javax.naming
It is required to use a unique handle name for each and every DB we use. Here we will be using ‘default’ and ‘mssqldb’ as handles for oracle and MS Sql Server Databases respectively .
Note: ‘
a) default’ is used here to indicate that the oracle is used as the default DB. So it’s recommended not to interpret ‘default’ as a string similar to “mssqldb’’.
b) jdbc/consumers and consumers-sqlserver-ds  in the torque.properties are the   jndi-name(s) as mentioned in oracle-ds.xml
The handle names mentioned in torque.properties file are used in java code as shown in the code below
Connection oracleConn = null;
 Connection sqlServerConn = null;   
 try {
         / * Establishes Connection to oracle DB  */
          oracleConn = Torque.getConnection();
          / * Establishes Connection to SQL SERVERDB  */
         sqlServerConn = Torque.getConnection(“mssqldb’’”);
............
.............


      } catch (Exception e) {
      } finally {
   Torque.closeConnection(conn);
   Torque.closeConnection(sqlServerConn); 
}

Comments

Post a Comment

Popular posts from this blog

Creating Custom Code Panels using InstallAnywhere

By -
Image
In this write-up lets look at the way to create a Custom Choose File Panel using InstallAnywhere(IA) tool. IA is a multi-platform software tool for creating customized installers.There are many documents available on IA that gives us a clear picture of IA and its features. This write-up assumes that the reader of this blog is aware of the basic features available in IA and has a licensed InstallAnywhere enterprise Edition and not InstallAnywhere standard edition.In this blog I am adding a small piece of code that tells us how to develop custom panels. In the Advanced Designer we can add a file chooser by using "Panel: Choose File" action. The code below produces the same output as IA's Choose File action minus 'Restore Default File'. To write a custom code panel ,it is necessary to write a class that extends CustomCodePanel class and override a couple of methods present in it. Here is the custom code that demonstrates a custom choose file panel. packag...
Read more

Get JBoss Version using Java Code

By -
The following are the things we will be looking into now. a) How to get the JBOSS version from JBOSS zip file using java code? b) How to get the JBoss version from JBoss folder using java code? c) How to get the manifest details of a jar file that is present inside a Zip file? The actual version of JBoss can be determined by using the run.jar file present inside the bin folder of JBoss. It is not that difficult to get the manifest details of any jar file present either inside a folder or in a zip file[If you think it is difficult, don't worry,very soon we will make it easy for you] We are here trying to get the manifest details of the run.jar file, which answers all the questions we have posted above. The first method "getJbossVersion(String sourcefile)" in the code snippet below not only tells us how to get the Version of JBoss, but also tells us how to get the contents of MANIFEST.MF file that is present inside a jar file which in turn is again present insi...
Read more

Server Migration from JBoss-4.0.5 to JBoss-4.2.3.GA

By -
As the subject line says, this write-up covers a small note on JBoss Server migration. Hopefully it may not be a tough task migrating from JBoss-4.0.5 to JBoss-4.2.3 server, but I rather had a different experience while doing this. The reason behind this was the pre-compilation of the JSPs * in my project, which was performed using the jar files present in jbossweb-tomcat55.sar folder. * If I say compile/compiling in this write-up, please read it as ‘pre-compiling JSPs’ I was supposed to do the same compiling as it was done earlier when we used JBoss-4.0.5. The jar files used to compile are jasper-compiler.jar, jasper-runtime.jar, commons-el.jar and as I said earlier these files resided in the jbossweb-tomcat55.sar folder. Now where can I find jbossweb-tomcat55.sar folder in JBoss-4.2.3.? After some time, with the help of google, I was able to find out that this directory is been replaced by a new Tomcat servlet engine which is been named as jboss-web.deployer . This r...
Read more