Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- connect DB2 with Java
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.DriverManager;
- import java.sql.Connection;
- import java.sql.SQLException;
- public class connection {
- public static void main(String[] argv) {
- try {
- Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
- }
- catch (ClassNotFoundException e) {
- System.out.println("Please include Classpath Where your DB2 Driver is located");
- e.printStackTrace();
- return;
- }
- System.out.println("DB2 driver is loaded successfully");
- Connection conn = null;
- PreparedStatement pstmt = null;
- ResultSet rset=null;
- boolean found=false;
- try {
- conn = DriverManager.getConnection("jdbc:db2:sabarish","db2admin","Murugasaranam");
- if (conn != null)
- {
- System.out.println("DB2 Database Connected");
- }
- else
- {
- System.out.println("Db2 connection Failed ");
- }
- pstmt=conn.prepareStatement("Select * from bo");
- rset=pstmt.executeQuery();
- if(rset!=null)
- {
- while(rset.next())
- {
- found=true;
- System.out.println("Class Code: "+rset.getString("clcode"));
- System.out.println("Name: "+rset.getString("name"));
- }
- }
- if (found ==false)
- {
- System.out.println("No Information Found");
- }
- } catch (SQLException e) {
- System.out.println("DB2 Database connection Failed");
- e.printStackTrace();
- return;
- }
- }
- }
- java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver
- at java.net.URLClassLoader$1.run(Unknown Source)
- at java.security.AccessController.doPrivileged(Native Method)
- at java.net.URLClassLoader.findClass(Unknown Source)
- at java.lang.ClassLoader.loadClass(Unknown Source)
- at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
- at java.lang.ClassLoader.loadClass(Unknown Source)
- at java.lang.Class.forName0(Native Method)
- at java.lang.Class.forName(Unknown Source)
- at connection.main(connection.java:11)
- Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
- Class.forName("com.ibm.db2.jcc.DB2Driver");
Add Comment
Please, Sign In to add comment