Installing JDBC Driver for DB2 and Tomcat

The files to download are db2jcc.jar and db2jcc_license_cu.jar in order to make your apps talk to DB2 database – there are multiple ways to download it from the IBM web site. The easiest way to reach these files and download it to your server is downloading the jdbc driver for all Operating Systems.

Once you have these files then put that in your local lib folder under your app root folder -- I mean you have a lib folder under WEB-INF folder so put these two files in it. If you are running tomcat on windows then it’s all set but if you are running the tomcat on UNIX, Linux or Ubuntu then set a classpath to it. The command to run on command prompt is CLASSPATH = /appRoot/WEB-INF/lib or add this line to your .bashrc file. The way to reach this file is to go root and try this command – vi .bashrc, this file opens up in vi editor. If you have another text editor then try to open this file using that application so that it becomes easier for you to edit it. You can try with this class Class.forName("COM.ibm.db2.jcc.DB2Driver"); instead of Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); because it works for me. If you get this “COM.ibm.db2.jdbc.app.DB2Driver” to work then please post your comment on it.