/**//* * Created on Jul 8, 2004 * */ /**//** * File: db2Conn.java * * Desc: Utility Class for establishing DB2 connection via JCC Type 4 Driver */ import java.sql.*; public class db2Conn ...{ /**//** * Default Constructor */ public db2Conn() ...{} /**//* * Get Database connection using Database name, username, password, machine name and port number */ public static Connection get(String db, String userName, String passwd, String host, String port)...{ Connection conn=null; try ...{ /**//** Load the DB2(R) JCC driver with DriverManager **/ Class.forName("com.ibm.db2.jcc.DB2Driver"); /**//** Create Database URL and establish DB Connection **/ String databaseURL = "jdbc:db2://"+host+":"+port+"/"+db; java.util.Properties properties = new java.util.Properties (); properties.setProperty ("user", userName); properties.setProperty ("password", passwd); conn = DriverManager.getConnection(databaseURL,properties); /**//** print any error messages **/ if(conn==null)System.out.println("Connection Failed \n"); }catch (ClassNotFoundException e) ...{ System.out.println("Exception in DB2Connection"); e.printStackTrace(); }catch (java.sql.SQLException e) ...{ e.printStackTrace(); System.exit(-1); } return conn; } } |